Getting Started
-
Starting Excel
-
Understanding the Display Screen
-
Working with the Ribbon
-
Working with the Quick Access Toolbar
-
Exploring the File Tab
-
Opening a Workbook
-
Managing Open Workbooks
-
Using Excel Help
Entering Data
-
Moving the Cell Pointer
-
Selecting a Range of Cells
-
Creating a New Workbook
-
Entering Constant Values
-
Saving a Workbook
-
Editing Cell Contents
-
Clearing Cell Contents
-
Working with Undo and Redo
-
Closing a Workbook
-
Exiting Excel
Using Formulas
-
Entering Formulas
-
Using the SUM Function
-
Summing Columns or Rows Automatically
-
Using Statistical Functions
-
Working with the Range Finder
-
Using Formula Error Checking
Formatting Worksheets
-
Formatting Numbers
-
Changing the Font Format
-
Aligning Cell Contents
-
Merging Cells
-
Adding Borders
-
Applying Cell Styles
Modifying
Columns and Rows
-
Changing Column Width and Row Height
-
Using AutoFit
-
Inserting and Deleting Columns or Rows
-
Hiding Columns or Rows
-
Using Custom Worksheet Views
Microsoft Excel
