About This Course
Course Curriculum
-
Navigate the Excel User Interface00:28:00
-
Use Excel Commands00:10:00
-
Create and Save a Basic Workbook00:19:00
-
Enter Cell Data00:12:00
-
Use Excel Help00:05:00
-
Create Worksheet Formulas00:15:00
-
Insert Functions00:17:00
-
Reuse Formulas and Functions00:17:00
-
Insert, Delete, and Adjust Cells, Columns, and Rows00:10:00
-
Search for and Replace Data00:09:00
-
Use Proofing and Research Tools00:07:00
-
Apply Text Formats00:16:00
-
Apply Number Format00:08:00
-
Align Cell Contents00:09:00
-
Apply Styles and Themes00:12:00
-
Apply Basic Conditional Formatting00:11:00
-
Create and Use Templates00:08:00
-
Preview and Print a Workbook00:10:00
-
Set Up the Page Layout00:09:00
-
Configure Headers and Footers00:07:00
-
Manage Worksheets00:05:00
-
Manage Workbook and Worksheet Views00:07:00
-
Manage Workbook Properties00:06:00
-
Work with Ranges00:18:00
-
Use Specialized Functions00:11:00
-
Work with Logical Functions00:23:00
-
Work with Date & Time Functions00:08:00
-
Work with Text Functions00:11:00
-
Sort Data00:10:00
-
Filter Data00:10:00
-
Query Data with Database Functions00:09:00
-
Outline and Subtotal Data00:09:00
-
Create and Modify Tables00:16:00
-
Apply Intermediate Conditional Formatting00:07:00
-
Apply Advanced Conditional Formatting00:05:00
-
Create Charts00:13:00
-
Modify and Format Charts00:12:00
-
Use Advanced Chart Features00:12:00
-
Create a PivotTable00:13:00
-
Analyze PivotTable Data00:12:00
-
Present Data with PivotCharts00:07:00
-
Filter Data by Using Timelines and Slicers00:11:00
-
Use Links and External References00:12:00
-
Use 3-D References00:06:00
-
Consolidate Data00:05:00
-
Use Lookup Functions00:12:00
-
Trace Cells00:09:00
-
Watch and Evaluate Formulas00:08:00
-
Collaborate on a Workbook00:19:00
-
Protect Worksheets and Workbooks00:08:00
-
Apply Data Validation00:13:00
-
Search for Invalid Data and Formulas with Errors00:04:00
-
Work with Macros00:18:00