Microsoft Excel 101 Course Introduction
- Ask Questions
- Course Exercise Files
- Certificate of Completion
Microsoft Excel Fundamentals
- Launching Excel
- Microsoft Excel Startup Screen
- Introduction to the Excel Interface
- 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
- Excel Fundamentals Quiz
Entering and Editing Text and Formulas
- 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
- Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)
- Entering and Editing Text and Formulas Quiz
Working with Basic Excel Functions
- The structure of an Excel Function
- Working with the SUM() Function
- Working with the MIN() and MAX() Functions
- Working with the AVERAGE() Function
- Working with the COUNT() Function
- Adjacent Cells Error in Excel Calculations
- Using the AutoSum Command
- Excel's AutoSum Shortcut Key
- Using the AutoFill Command to Copy Formulas
- Basic Excel Functions Quiz
Modifying an 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
- Modifying Worksheets Quiz
Formatting Data in an 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
- Formatting Data Quiz
Inserting Images and Shapes into an Excel Worksheet
- Inserting Images
- Inserting Excel Shapes
- Formatting Excel Shapes
- Working with Excel SmartArt
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
- Working with Excel Charts Quiz
Printing an Excel Worksheet
- Viewing your Document in Print Preview
- Changing the Margins, Scaling and Orientation
- Excel Worksheet Margins
- Working with Page Layout View
- Adding Header and Footer Content
- Printing a Specific Range of Cells
- Printing and Excel Worksheet Quiz
Working with Excel Templates
- Intro to Excel Templates
- Opening an Existing Template
- Creating a Custom Template
Congratulations! You've Built a Solid Microsoft Excel Foundation
- Congratulations!
Microsoft Excel 102 Course Introduction
- Excel 102 Course Exercise Files -- DOWNLOAD
Working with an Excel List
- Understanding Excel List Structure
- Sorting a List Using Single Level Sort
- Sorting a List Using Multi-Level Sorts
- Using Custom Sorts in an Excel List
- Filter an Excel List Using the AutoFilter Tool
- Creating Subtotals in a List
- Format a List as a Table
- Using Conditional Formatting to Find Duplicates
- Removing Duplicates
Excel List Functions
- Introduction to Excels Function: DSUM()
- Excel DSUM Function Single Criteria Continued
- Excel DSUM Function with OR Criteria
