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

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