Our Tutorial is created to teach you the basic and advanced features of Microsoft Excel. This course consists of richly illustrated lessons and examples.
If you want to learn more, check out formulas and advanced VBA tutorials that are not included in this tutorial.
Introduction
Interface
- Start Screen
- Application window
- Worksheets
- Ribbon
- Quick Access Toolbar
- Formula Bar
- Status Bar
- Backstage View
Basics
- Entering and editing data
- Data Types
- Copy, cut and paste data
- Windows and Office clipboard
- Paste Special
- AutoCorrect
- AutoComplete
- AutoFill
- Flash fill
- Spell check
- Undo and Redo
- Hyperlinks
- Data Validation
- Comments
- Selecting cells
- Select rows and columns
- Inserting cells
- Cell references
- Merging cells
- Merging text with numbers
- Text to Columns Wizard
- Finding and replacing data
- Go To Special
- Cell Ranges
- Inserting rows and columns
- Deleting rows and columns
- Hiding rows and columns
- Aligning data
- Adjusting text
- Text orientation
- Color, type, and font size
- Bold, italic, underline, and strikethrough
- Filling cells
- Cell borders
- Simple fractions and decimal fractions
- Currency and accounting format
- Custom number formatting
- How Excel stores date and time
- Mathematical operations on date and time
- Formatting date and time
- Saving files
- Recovering files
- Print Preview
Functions
Data Analysis
- Tables
- Removing duplicates
- Slicers
- Charts
- Column Chart
- Line Chart
- Pie Chart
- Trendlines
- Sparklines
- Pivot Tables