Curriculum
Getting Started with Microsoft Office Excel 2016 | |||
Navigate the Excel User Interface 00:28:00 | |||
Use Excel Commands 00:10:00 | |||
Create and Save a Basic Workbook 00:19:00 | |||
Enter Cell Data 00:12:00 | |||
Use Excel Help 00:05:00 | |||
Performing Calculations | |||
Create Worksheet Formulas 00:15:00 | |||
Insert Functions 00:17:00 | |||
Reuse Formulas and Functions 00:17:00 | |||
Modifying a Worksheet | |||
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 | |||
Search for and Replace Data 00:09:00 | |||
Use Proofing and Research Tools 00:07:00 | |||
Formatting a Worksheet | |||
Apply Text Formats 00:16:00 | |||
Apply Number Format 00:08:00 | |||
Align Cell Contents 00:09:00 | |||
Apply Styles and Themes 00:12:00 | |||
Apply Basic Conditional Formatting 00:11:00 | |||
Create and Use Templates 00:08:00 | |||
Printing Workbooks | |||
Preview and Print a Workbook 00:10:00 | |||
Set Up the Page Layout 00:09:00 | |||
Configure Headers and Footers 00:07:00 | |||
Managing Workbooks | |||
Manage Worksheets 00:05:00 | |||
Manage Workbook and Worksheet Views 00:07:00 | |||
Manage Workbook Properties 00:06:00 | |||
Working with Functions | |||
Work with Ranges 00:18:00 | |||
Use Specialized Functions 00:11:00 | |||
Work with Logical Functions 00:23:00 | |||
Work with Date & Time Functions 00:08:00 | |||
Work with Text Functions 00:11:00 | |||
Working with Lists | |||
Sort Data 00:10:00 | |||
Filter Data 00:10:00 | |||
Query Data with Database Functions 00:09:00 | |||
Outline and Subtotal Data 00:09:00 | |||
Analyzing Data | |||
Create and Modify Tables 00:15:00 | |||
Apply Intermediate Conditional Formatting 00:07:00 | |||
Apply Advanced Conditional Formatting 00:05:00 | |||
Visualizing Data with Charts | |||
Create Charts 00:13:00 | |||
Modify and Format Charts 00:12:00 | |||
Use Advanced Chart Features 00:12:00 | |||
Using PivotTables and PivotCharts | |||
Create a PivotTable 00:13:00 | |||
Analyze PivotTable Data 00:12:00 | |||
Present Data with PivotCharts 00:07:00 | |||
Filter Data by Using Timelines and Slicers 00:11:00 | |||
Working with Multiple Worksheets and Workbooks | |||
Use Links and External References 00:12:00 | |||
Use 3-D References 00:06:00 | |||
Consolidate Data 00:05:00 | |||
Using Lookup Functions and Formula Auditing | |||
Use Lookup Functions 00:12:00 | |||
Trace Cells 00:09:00 | |||
Watch and Evaluate Formulas 00:08:00 | |||
Sharing and Protecting Workbooks | |||
Collaborate on a Workbook 00:19:00 | |||
Protect Worksheets and Workbooks 00:08:00 | |||
Automating Workbook Functionality | |||
Apply Data Validation 00:13:00 | |||
Search for Invalid Data and Formulas with Errors 00:04:00 | |||
Work with Macros 00:18:00 | |||
Creating Sparklines and Mapping Data | |||
Create Sparklines 00:07:00 | |||
MapData 00:07:00 | |||
Forecasting Data | |||
Determine Potential Outcomes Using Data Tables 00:08:00 | |||
Determine Potential Outcomes Using Scenarios 00:09:00 | |||
Use the Goal Seek Feature 00:04:00 | |||
Forecasting Data Trends 00:05:00 |
What our STUDENT says
Based on 812 Reviews
No Reviews found for this course.