Course Topics
Getting started with Excel
- Finding your way around Excel
- Getting to know the Excel web app
- Creating a new workbook
- Inserting and moving worksheets
- Renaming a worksheet
Entering values
- Filling a worksheet
- Adjusting the column width or row height
- Copying with the fill-in function
- Creating data series
- Using Flash Fill
- Using wrap text
- Setting manual text wrapping
Performing simple calculations
- Getting to know how to structure and enter formulas
- Subtracting Values
- Multiplying Values
- Dividing values
- Calculating a sum total
- Calculating an average
Editing rows and columns
- Showing column and row labels
- Selecting whole rows and columns
- Inserting and deleting cells
- Moving and copying cells
- Merging cells
Formatting cells
- Formatting a cell
- Formatting numbers as text
- Showing and hiding decimal places
- Creating a custom number format
- Applying a table style
- Applying a cell format to multiple cells
Working with multiple worksheets
- Working with multiple worksheets
- Copying and moving a worksheet
- Showing and hiding worksheets
- Deleting worksheets
- Switching between workbooks
Creating and using templates
- Creating a Template
- Using Templates
Protecting cells
- Aligning text
- Protecting sheet
- Unprotecting a sheet
- Protecting a workbook
- Releasing locked cells in a protected worksheet
Preparing spreadsheets for printing or export
- Setting a page break with the mouse
- Setting a page break using the ribbon
- Changing page orientation
- Setting up headers and footers
- Setting a repeat line for printing
- Setting print area
Printing and exporting
- Printing a table
- Printing comments
- Using Quick Print
- Exporting data