by Ryan Stebbins | Released March 2019 | ISBN: 12345EXCL365BEG

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. Show and hide more

1. Introduction
   • Introduction 00:00:56
2. Getting Started with Excel
   • What is Excel? 00:02:30
   • Opening Excel 00:04:29
   • Navigating the Excel User Interface 00:04:27
   • Using the Excel Ribbon 00:06:59
   • Understanding Excel Worksheet Components 00:06:36
   • Using the Backstage View 00:05:37
3. Creating Workbooks and Using Templates
   • Creating a New Workbook 00:06:12
   • Saving an Excel Workbook 00:04:42
   • Using the Accessibility Checker 00:03:59
4. Entering Data
   • Navigating a Worksheet by Mouse or Keyboard 00:04:48
   • Understanding Excel Data Types 00:03:36
   • Using the Inking Tools 00:05:13
   • Working with Cell and Range Addressing 00:04:49
   • Using Various Data Selection Techniques 00:04:41
   • Working with Common Excel Commands 00:05:43
   • Using Flash Fill and AutoFill 00:06:15
5. Excel Formula Basics
   • What are Formulas and Functions? 00:04:50
   • Understanding the Components of a Formula 00:05:11
   • Understanding Calculation Hierarchy and the Order of Operations 00:03:12
   • Creating Basic Formulas 00:04:58
   • Working with Basic Functions and AutoSum 00:06:17
   • Using Cell References 00:04:57
   • Using the Quick Analysis Tool 00:03:28
6. Adjusting a Worksheet
   • Modifying Columns and Rows 00:05:58
   • Hiding and Unhiding Columns and Rows 00:05:48
7. Formatting and Aligning Data
   • Formatting and Aligning Data 00:07:10
   • Merging Data 00:06:41
   • Wrapping Text and Adjusting Orientation 00:06:10
   • Formatting Numbers 00:05:27
   • Using the Format Painter 00:04:07
   • Removing Formatting Quickly 00:03:40
8. Using Cell Styles and Themes
   • Using Cell Styles 00:06:00
   • Applying Themes 00:04:43
9. Inserting Objects and Graphics
   • Inserting and Formatting Images and Shapes 00:08:02
   • Inserting and Formatting SmartArt 00:04:32
   • Working with Icons 00:03:45
   • Inserting Hyperlinks 00:05:50
   • Inserting Symbols and Equations 00:05:01
   • Inserting WordArt and Text Boxes 00:04:40
   • Inserting 3D Models 00:04:04
   • Arranging Objects 00:06:24
10. Proofing a Workbook
    • Using Find and Replace 00:05:24
    • Using Go To and Go To Special 00:03:19
    • Using the Spell Checker 00:04:45
    • Using the Thesaurus and Translation Features 00:04:55
11. Printing an Excel File
    • Printing and Previewing Excel Files 00:05:38
    • Creating Custom Margins and Scaling 00:05:15
    • Adding Headers and Footers 00:03:49
    • Formatting a Page with the Page Layout Tab 00:06:00
    • Printing Titles and Specific Worksheet Areas 00:02:45
    • Exporting to PDF and XPS 00:03:44
12. Managing Worksheets
    • Renaming and Coloring Worksheet Tabs 00:03:02
    • Adding, Deleting, and Navigating Worksheets 00:03:15
    • Hiding and Unhiding Worksheets 00:02:41
13. Navigating and Viewing Excel Files
    • Viewing Workbooks 00:03:14
    • Using Zoom Tools 00:02:55
    • Configuring Sheet Options 00:04:43
    • Using the Freeze Panes and Split Commands 00:04:00
    • Adjusting Worksheet Properties 00:03:31
14. Conclusion
    • Course Recap 00:01:39
Show and hide more