Overview
-
These comprehensive Excel tutorials reveal over 65 Excel tips, tricks, and shortcuts.
Syllabus
-
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Entering numbers with leading zeros
- Entering a data series using the fill handle
- Adding text to a number format
- Printing a sheet on a set number of pages
- Using an Excel table column as a named range
- Numbering rows in a range or table
- Creating hyperlinks to other resources
- Analyzing data using the Quick Analysis Lens
- Super-hiding worksheets
- Creating recommended PivotTables
- Controlling the user interface using your keyboard
- Customizing the Ribbon
- Customizing the Quick Access Toolbar
- Finding commands not on the Ribbon
- Hiding sheet tabs and scrollbars
- Moving among worksheets quickly
- Displaying a workbook's full path
- Setting the number of worksheets in a workbook
- Limiting a worksheet's scroll area
- Setting a print area
- Zooming in or out quickly
- Creating a custom view
- Creating a table using Ctrl+L
- Applying a table style and replacing existing formatting
- Creating a linked picture of a range
- Finding a target value
- Creating substitute data sets using scenarios
- Entering a line break in a cell
- Wrapping and shrinking cell text
- Entering data into every cell in a range
- Picking data from a list
- Entering data into cells across multiple sheets
- Entering data using an AutoCorrect value
- Creating a data entry form
- Finding a specific color using RGB values
- Basing conditional formats on a formula
- Extending a date series
- Using a custom list with the fill handle
- Using Flash Fill to manage data
- Removing duplicate values
- Inserting the current date or time
- Displaying times that exceed twenty-four hours
- Calculating days between dates
- Calculating time to reach an investment goal
- Displaying thousandths of a second
- Generating a list of unique random numbers
- Using INDEX and MATCH to look up data without using the left-most column
- Summarizing data on the status bar
- Rounding values
- Calculating remainders and whole units
- Calculating running totals
- Creating and selecting named ranges quickly
- Commenting within a formula
- Displaying a cell formula using FORMULATEXT
- Exiting a cell without saving changes
- Analyzing a formula for errors
- Watching a cell's value
- Creating a chart by pressing one key (or two)
- Creating recommended charts
- Summarizing data using a sparkline
- Using a PivotTable value in a formula
- Delaying PivotTable updates
- Creating separate sheets from a PivotTable
- Drilling down into PivotTable data
- Additional resources
