Overview
-
Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2016 features.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- What is Excel used for?
- Using the menu system
- Using the Quick Access Toolbar
- Understanding workbooks and worksheets
- Using the Formula bar
- Using the Status bar
- Using navigation tools
- Using shortcut menus and the Mini toolbar
- Creating new workbooks
- Using Excel Help
- Exploring data entry and editing techniques
- Entering data with AutoFill
- Working with dates and times
- Using Undo and Redo
- Adding comments
- Using Save or Save As
- Creating simple formulas
- Copying a formula into adjacent cells
- Calculating year-to-date totals
- Creating a percentage-change formula
- Working with relative, absolute, and mixed references
- Using SUM and AVERAGE
- Using other common functions
- Exploring font styles and effects
- Adjusting row heights and column widths
- Working with alignment and Wrap Text
- Designing borders
- Exploring numeric and special formatting
- Formatting numbers and dates
- Using conditional formatting
- Creating and using tables
- Inserting shapes, arrows, and other visual features
- Inserting and deleting rows and columns
- Hiding and unhiding rows and columns
- Moving, copying, and inserting data
- Finding and replacing data
- Exploring the Page Layout tab and Page Layout view
- Previewing page breaks
- Working with Page Setup and printing controls
- Creating charts
- Exploring chart types
- Formatting charts
- Working with axes, titles, and other chart elements
- Creating in-cell charts with sparklines
- New charts in Excel 2016
- Freezing and unfreezing panes
- Splitting screens horizontally and vertically
- Collapsing and expanding data views with outlining
- Displaying multiple worksheets and workbooks
- Renaming, inserting, and deleting sheets
- Moving, copying, and grouping sheets
- Using formulas to link worksheets and workbooks
- Locating and maintaining links
- Using IF functions and relational operators
- Getting approximate table data with the VLOOKUP function
- Getting exact table data with the VLOOKUP function
- Using the COUNTIF family of functions
- Unlocking cells and protecting worksheets
- Protecting workbooks
- Assigning passwords to workbooks
- Sharing workbooks
- Tracking changes
- Sorting data
- Inserting subtotals in a sorted list
- Using filters
- Splitting data into multiple columns
- Splitting and combining columnar data with Flash Fill
- Removing duplicate records
- Using validation tools
- Using Goal Seek
- Using Solver
- Using Scenario Manager
- Using data tables
- Creating PivotTables
- Manipulating PivotTable data
- Grouping by date and time
- Grouping by other factors
- Using slicers to clarify and manipulate fields
- Using PivotCharts
- Exploring the need for macros
- Creating a simple macro
- Running a macro
- Goodbye
