Introduction to Excel
- Accessing Excel
- Describing and customizing the application interface
- Getting help
- Creating, saving, closing, and opening workbooks
- The Workbook concept
- Excel Templates
Working in the Worksheet
- Cells, rows, columns
- Active cell
- Navigating the worksheet
- Address concept
- Entering and editing data
- Data types
- Selecting, moving, and copying cells
- Paste Special
- Clear command
- Inserting, editing, copying, and deleting comments
- Configuring regional settings in the control panel
Column and Row Operations
- Selecting, inserting, and deleting rows and columns
- Modifying column width and row height
- Hiding and showing rows and columns
Worksheet Operations
- Selecting, inserting, and deleting sheets
- Renaming sheets
- Moving and copying sheets within and between workbooks
- Navigating between sheets
- Handling multiple sheets
Formatting Cells
- Formatting numbers and text
- Defining cell fill and borders
- Aligning and orienting cell content
- Copying and deleting formats
- Applying automatic formats
Data Series
- Creating and using data series
- Custom lists
- Auto-complete
Performing Calculations
- Formula and function syntax
- Operators
- Error values
- Relative, absolute, and mixed references
- Circular references
- Creating formulas
- Calculations with functions
- Moving and copying cells with formulas and functions
Links
- Linking cells
- External references
- Pasting, embedding, and linking information between applications
Working with Data Lists and Tables
- Best practices for creating a list
- Selecting and navigating a data list
- Sorting data in a list
- Searching records using AutoFilter
- Applying automatic subtotals to a list
- Format as Table
- Find and Replace
Printing
- Page setup
- Printing options
- Print Preview
- Inserting and deleting page breaks
- Workbook views
- Inserting headers and footers
Charts
- Selecting data to represent
- Creating 2D and 3D charts
- Recommended charts
- Defining chart type, options, and location
- Adding, deleting, and formatting chart items