watching now
4 Students

#### 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.

#### 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
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
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
04:40
Defining the Page Margins
09:49
01:25