🔥$100K Hit! Where Will Bitcoin Go Next? Find Out Live!
watching now
5 Students

Description

What Will You Learn?

  • Student will learn how to navigate through Excel.
  • Students will learn how to work within different sheets in Excel.
  • Student will learn how to create formulas for adding, subtracting and multiplying.
  • Students will Learn how to format cells and worksheets.

Requirements

  • having Microsoft Excel Application installed on their computer.
  • NFT Certificate
  • 52 Lessons
  • Beginner
  • English
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 5h 20min of content, in total.

Section 1: Introduction to Excel
54:50
Exploring the Excel Window
12:34
Navigating within a Worksheet
09:00
Planning a Workbook
09:47
Entering Text and Numbers
09:15
Working with Columns and Rows
08:06
Section 2: Working with Cells and Ranges
14:40
Moving and Copying a Range
07:31
Inserting and Deleting a Range
02:53
Section 3: Working with Formulas
09:10
Entering a Formula
04:44
Copying and Pasting Formulas
04:26
Section 4: Intro to Functions
17:04
Entering a Function
09:49
Using the Function to AutoSum + Min, Max Count
07:15
Section 5: Working with Worksheets
13:04
Inserting or Deleting a Worksheet
03:51
Renaming a Worksheet
04:04
Moving and Copying a Worksheet
05:09
Section 6: Editing Worksheet Content
13:31
Using Find and Replace
03:56
Using the Spell Checker
04:23
Section 7: Previewing and Printing a Workbook
13:50
Changing Worksheet View
05:51
Working with Portrait or Landscape Orientation and Page Setup
03:24
Printing the Workbook
01:51
Viewing and Printing Worksheet Formulas
02:39
Hands on Assignment
00:05
Section 8: Formatting Cell Text
12:08
Applying Font and Font Styles
05:24
Applying a Font Color
03:35
Formatting Text Selection
03:09
Section 9: Working with Colors and Borders
09:34
Applying a Fill Color
03:09
Adding a Background Image
06:25
Section 10: Formatting Calculated Values
30:15
Creating Formulas to Add, Subtract and Divide Values
09:13
Applying Number Formats
08:26
Section 11: Formatting Worksheet Cells
40:06
Aligning Cell Content
08:31
Indenting Cell Content
09:55
Merging Cells
06:24
Rotating Cell Content
08:00
Adding Borders to a Cell
07:16
Section 12: Copying and Pasting Formulas
17:33
Copying Formats with Format Painter
04:48
Copying Formats with the Paste Option Button
06:02
Copying Formats with Paste Special
06:43
Section 13: Table Styles and Themes
44:20
Applying Cell Styles
06:44
Creating Formulas to Calculate Totals
07:17
Creating Formulas to Subtract Values
14:42
Highlighting Cells using Conditional Formatting
07:44
Hiding Worksheet Data
02:49
Section 14: Formatting Worksheet for Printing
29:22
Defining the Print Area
05:23
Inserting Page Breaks
05:42
Creating Page Headers and Footers
04:40
Defining the Page Margins
09:49
Section 15: Summary of Course
01:25

About the Instructor

91.2% of students rated this instructor as excellent!

My name is Lazaro Diaz and I am a Network Engineer with many years in the field and in the teaching industry. I hold the following certifications: CCNA, CCNA Security, CCNA Voice, CCNP, Security+, Network+, A+, MCP, MCTS & MOS.

See All Instructor Courses

BitDegree platform reviews