Teaches you the fundamental skills you need to work with Excel.
Overview
Syllabus
Introduction
- Welcome
- Why use Excel?
- Checking out the Backstage view with the File tab
- Examining your file's info
- Exploring the Ribbon
- Customizing the Ribbon and Quick Access Toolbar
- Creating workbooks from templates
- Saving workbooks to different file formats
- Switching between views
- Moving around your worksheets and workbooks
- Adding, copying, and removing worksheets
- Entering and formatting text and numbers
- Aligning text and numbers
- Choosing number formats
- Totaling rows and columns with AutoSum and Fill
- Referencing cells by row and column
- Referencing cells in another worksheet
- Cutting, copying, and pasting
- Clearing contents and deleting cells
- Splitting the worksheet view and freezing panes
- Working with two workbooks and syncing the view
- Writing your own formulas
- Understanding relative and absolute references
- Using functions like ROUNDUP, AVERAGE, and IFERROR
- Formatting dates and times
- Using date and time functions
- Naming cells and ranges
- Fixing common errors
- Tracing Errors
- Moving, inserting, and removing cells, rows, and columns
- Transposing rows and columns
- Merging and unmerging cells
- Adding comments to worksheets
- Changing worksheet colors, fonts, and effects
- Creating charts
- Choosing the right chart for your data
- Changing your chart's appearance
- Using sparklines as "data words"
- Inserting photos, graphics, and clip art
- Using an image for a header
- Creating a data table
- Adding records and modifying a data table
- Sorting and filtering data in a table
- Importing data from an outside source
- Grouping data in outlines
- Building a pivot table
- Highlighting data with conditional formatting
- Printing a worksheet with column and row headers
- Setting up page breaks
- Emailing a workbook
Taught by
Chris Grover