Excel tutorials that use real-world examples to teach the core features and tools in Excel 2010.
Overview
Syllabus
Introduction
- Welcome
- Using the exercise files
- Exploring three common uses for Excel
- Touring the interface
- Finding the commands you need
- Using Backstage view or the File tab
- Maintaining file compatibility
- Creating a worksheet
- Techniques for copying and pasting
- Entering data automatically with Auto Fill
- Targeting large data groups
- Changing a worksheet's structure
- Understanding formulas and functions
- Entering data in a worksheet
- Adding numbers manually
- Adding numbers using Sum and AutoSum
- Adding a whole worksheet
- Working with numbers in columns
- Preventing errors using absolute references
- Working with times and dates
- Using IF
- Using SUMIF and AVERAGEIF
- Naming and using cell ranges
- Formatting numbers and dates
- Applying fonts, background colors, and borders
- Adjusting columns, rows, and text
- Using conditional formatting
- Using custom conditional formatting
- Adding pictures and shapes
- Inserting SmartArt
- Coordinating a look using themes
- Applying built-in styles
- Creating and sharing styles
- Using templates
- Creating and using original templates
- Making the pieces fit
- Inserting headers and footers
- Printing and PDFs
- Finding and replacing data
- Freezing panes
- Repeating row and column titles
- Creating multiple custom worksheet views
- Hiding or grouping rows and columns
- Managing worksheets
- Calculating formulas across worksheets
- Importing and exporting data in Excel
- Setting workbook permissions
- Inserting and editing comments
- Sharing a workbook
- Tracking changes
- Saving files in shared locations
- Splitting cell data into multiple cells
- Joining data from multiple cells
- Basic and multi-field sorting
- Using tables to sort and filter data
- Inserting automatic subtotals
- Creating lookup tables
- Using auditing to diagram
- Using evaluation in Excel
- Working with Goal Seek
- Using data tables in formulas
- Using scenarios in formulas
- Exploring the Analysis ToolPak
- Discovering PivotTables
- Creating a basic PivotTable
- Modifying a PivotTable
- Creating and modifying a PivotChart
- Choosing chart types
- Inserting Sparklines
- Creating a column chart
- Modifying a column chart
- Creating and modifying a pie chart
- Placing Excel charts into other Office applications
- Understanding macros
- Recording and using a simple macro
- Editing a macro
- Customizing the Quick Access toolbar
- Customizing the Ribbon bar
- Setting Excel options
- Goodbye
Taught by
Bob Flisser
