Microsoft Excel Fundamentals
Microsoft Excel Startup Screen
Customizing the Excel Quick Access Toolbar
More on the Excel Interface
Understanding the Structure of an Excel Workbook
Saving an Excel Document
Opening an Existing Excel Document
Common Excel Shortcut Keys
Entering Text to Create Spreadsheet Titles
Entering Text to Create Spreadsheet Titles
Working with Numeric Data in Excel
Entering Date Values in Excel
Working with Cell References
Creating Basic Formulas in Excel
Relative Versus Absolute Cell References in Formulas
Working with Basic Excel Function
Working with the SUM() Function
Working with the MIN() and MAX() Functions
Working with the AVERAGE() Function
Working with the COUNT() Function
Using the AutoSum Command
Excel’s AutoSum Shortcut Key
Using the AutoFill Command to Copy Formulas
Modifying Excel Worksheet
Moving and Copying Data in an Excel Worksheet
Inserting and Deleting Rows and Columns
Changing the Width and Height of Cells
Hiding and Unhiding Excel Rows and Columns
Renaming an Excel Worksheet
Deleting an Excel Worksheet
Moving and Copying an Excel Worksheet
Formatting Data in Excel Worksheet
Working with Font Formatting Commands
Changing the Background Color of a Cell
Adding Borders to Cells
Excel Cell Borders Continued
Formatting Data as Currency Values
Formatting Percentages
Using Excel’s Format Painter
Creating Styles to Format Data
Merging and Centering Cells
Using Conditional Formatting
Editing Excel Conditional Formatting
Creating Basic Charts in Excel
Creating an Excel Column Chart
Working with the Excel Chart Ribbon
Adding and Modifying Data on an Excel Chart
Formatting an Excel Chart
Moving a Chart to another Worksheet
Working with Excel Pie Charts