Course Curriculum
Introduction | |||
Introduction | FREE | 00:01:00 | |
Getting Started with Excel | |||
What is Excel | 00:02:00 | ||
Opening Excel | 00:04:00 | ||
Navigating the Excel User Interface | 00:08:00 | ||
Using the Excel Ribbon | 00:03:00 | ||
Understanding Excel Work Components | 00:04:00 | ||
Using the Backstage View | 00:03:00 | ||
Creating Workbooks and Using Templates | |||
Creating a New Workbook | 00:03:00 | ||
Creating Workbooks Using Templates | 00:03:00 | ||
Saving an Excel Workbook | 00:05:00 | ||
Using Convert and Checking Compatiblity | 00:02:00 | ||
Entering Data | |||
Navigating a Worksheet by Mouse or Keyboard | 00:05:00 | ||
Excel Data Types | 00:03:00 | ||
Cell and Range Addressing | 00:02:00 | ||
Data Selection Techniques | 00:05:00 | ||
Common Excel Commands | 00:07:00 | ||
Using the Autofill Handle | 00:03:00 | ||
Excel Formula Basics Data | |||
What are Formulas and Functions | 00:02:00 | ||
Components of a Formula | 00:06:00 | ||
Calculation Hierarchy Using the Order of Operations_Revise | 00:02:00 | ||
Creating Basic Formulas | 00:08:00 | ||
Working with Basic Functions and Autosum | 00:04:00 | ||
Using Cell References | 00:04:00 | ||
Using the Quick Analysis Tool | 00:01:00 | ||
Adjusting a Worksheet | |||
Modifying Columns and Rows | 00:06:00 | ||
Hiding and Unhiding Worksheets | 00:02:00 | ||
Formatting and Aligning Worksheet Data | |||
Formatting and Aligning Data | 00:06:00 | ||
Merging Data | 00:04:00 | ||
Wrapping Text Orientation | 00:02:00 | ||
Formatting Numbers | 00:03:00 | ||
Using Borders and Shading | 00:03:00 | ||
Using the Format Painter | 00:01:00 | ||
Removing Formatting Quickly | 00:01:00 | ||
Using Cell Styles and Themes | |||
Understanding Cell Styles | 00:02:00 | ||
Applying Cell Styles | 00:04:00 | ||
Applying Themes | 00:03:00 | ||
Inserting Objects and Graphics | |||
Inserting and Formatting Images | 00:03:00 | ||
Inserting and Formatting Shapes | 00:04:00 | ||
Inserting and Formatting Smart Art | 00:04:00 | ||
Inserting Screenshots | 00:02:00 | ||
Inserting Hyperlinks | 00:03:00 | ||
Inserting Symbols and Equations | 00:03:00 | ||
Inserting Word Art Or Text Boxes | 00:04:00 | ||
Inserting Other Excel Objects | 00:04:00 | ||
Arranging Objects | 00:04:00 | ||
Proofing a Workbook | |||
Using Find and Replace | 00:04:00 | ||
Finding and Replacing Formatting | 00:01:00 | ||
Using Got to and Go to Special | 00:02:00 | ||
Using the Spell Checker | 00:03:00 | ||
Using the Theasaurus and Translation Feature | 00:03:00 | ||
Printing an Excel File | |||
Printing and Previewing Excel Files | 00:03:00 | ||
Creating Custom Margins and Scaling | 00:05:00 | ||
Adding Headers and Footers | 00:04:00 | ||
Formatting a Page with the Page Layout Tab | 00:03:00 | ||
Printing Titles and Specific Worksheet Areas | 00:05:00 | ||
Exporting to PDF and XPs | 00:02:00 | ||
Managing Worksheets | |||
Renaming and Coloring Worksheet Tabs | 00:03:00 | ||
Adding, Deleting, and Navigating Worksheets | 00:03:00 | ||
Moving and Copying Worksheets | 00:04:00 | ||
Hiding and Unhiding Worksheets | 00:02:00 | ||
Navigating and Viewing Excel Files | |||
Viewing Workbooks | 00:03:00 | ||
Using Zoom Tools | 00:02:00 | ||
Configure Sheet Options | 00:02:00 | ||
Using Freeze Panes and Split Commands | 00:05:00 | ||
Working with Window Commands | 00:04:00 | ||
Adjusting Workbook Properties | 00:03:00 | ||
Conclusion | |||
Course Recap | 00:02:00 | ||
Resources | |||
Resources – Excel 2016 Introduction | 00:00:00 |
Review
COURSE REVIEWS
Course Reviews
No Reviews found for this course.