Outline - MS Excel Quick Start
Microsoft Excel: Quick Start
Course Outline
This course teaches you the key features of Microsoft Excel and gives you the skills that most employers require.
In less than a day, you can have the skills you need to use Excel like a pro!
- Section 1: Introduction
- Lecture 1: Course Introduction
- Section 2: The Excel Interface
- Lecture 1: Interface Introduction
- Lecture 2: The Title Bar
- Lecture 3: The File Command and Backstage View
- Lecture 4: The Command Ribbon
- Lecture 5: Command Icons
- Lecture 6: The Name Box and Formula Bar
- Lecture 7: The Workbook and Worksheets
- Lecture 8: The Status Bar
- Section 3: Entering and Changing Data
- Lecture 1: Entering Data
- Lecture 2: Changing Data
- Lecture 3: Moving Data
- Lecture 4: Copying Data
- Lecture 5: Clearing Data
- Lecture 6: Deleting Data
- Lecture 7: Using Paste Special
- Lecture 8: The AutoFill Feature
- Section 4: Formatting
- Lecture 1: Fonts
- Lecture 2: Borders
- Lecture 3: The Format Painter
- Lecture 4: Cell Alignment
- Lecture 5: Number Formatting
- Lecture 6: Wrapping Text
- Lecture 7: Merging Cells
- Lecture 8: Freezing Panes
- Section 5: Creating Formulas
- Lecture 1: Formulas Introduction
- Lecture 2: Cell References
- Lecture 3: Other Operators
- Lecture 4: Moving Formulas
- Lecture 5: Cell Reference Types
- Lecture 6: Copying Formulas
- Lecture 7: Copying Formulas - More Examples
- Section 6: Working with Functions
- Lecture 1: Functions Introduction
- Lecture 2: The SUM Function
- Lecture 3: Getting Function Help
- Lecture 4: AutoSum Functions
- Lecture 5: Counting Functions
- Lecture 6: Common Text Functions
- Lecture 7: Combining Functions
- Lecture 8: Adding Functions to Product List
- Section 7: Designing Tables
- Lecture 1: Tables Introduction
- Lecture 2: Creating a Table
- Lecture 3: Table Styles
- Lecture 4: Table Style Options
- Lecture 5: Table Totals
- Lecture 6: Formulas in Tables
- Lecture 7: Adding Table Rows and Columns
- Lecture 8: Deleting Rows and Columns
- Lecture 9: Row and Column Addition Shortcuts
- Section 8: Sorting Data
- Lecture 1: Sorting Introduction
- Lecture 2: Quick Sorts
- Lecture 3: The Sort Command
- Lecture 4: Multiple Column Sort
- Section 9: Filtering Data
- Lecture 1: Filtering Introduction
- Lecture 2: Applying Filters
- Lecture 3: Number Filtering Options
- Lecture 4: Text Filtering Options
- Lecture 5: Multiple Column Filters
- Lecture 6: Reapplying Filters
- Section 10: Using Multiple Worksheets
- Lecture 1: Multiple Worksheets Introduction
- Lecture 2: Adding Worksheets to a Workbook
- Lecture 3: Grouping and Ungrouping Worksheets
- Lecture 4: Adding Data to Multiple Worksheets
- Lecture 5: Formatting Multiple Worksheets
- Lecture 6: Adding Formulas to Multiple Worksheets
- Lecture 7: Multiple Worksheet Formulas
- Section 11: Printing
- Lecture 1: Printing Introduction
- Lecture 2: Print Preview
- Lecture 3: Selecting What to Print
- Lecture 4: Working with Print Areas
- Lecture 5: Print Titles
- Lecture 6: Predefined Headers and Footers
- Lecture 7: Custom Headers and Footers
- Lecture 8: Page Break Preview
- Section 12: Pivot Tables
- Lecture 1: Pivot Tables Introduction
- Lecture 2: A Simple Pivot Table
- Lecture 3: A More Useful Pivot Table
- Lecture 4: Multiple Rows and Columns
- Lecture 5: Functions in a Pivot Table
- Lecture 6: Formatting Pivot Table Values
- Lecture 7: Formatting Pivot Tables
- Lecture 8: Pivot Table Filters
- Lecture 9: Updating Pivot Tables
- Section 13: Creating Charts
- Lecture 1: Charts Introduction
- Lecture 2: Creating a Chart
- Lecture 3: How Charts Work
- Lecture 4: Chart Elements
- Lecture 5: Chart Elements Icon
- Lecture 6: Formatting Chart Elements
- Lecture 7: Chart Styles
- Lecture 8: Chart Design Tab
- Lecture 9: Chart Format Tab
- Lecture 10: Chart Formatting Pane
- Lecture 11: Updating Charts
- Lecture 12: Select Data Icon
- Lecture 13: Common Chart Types
- Lecture 14: Pivot Charts
- Section 14: Using Lookups
- Lecture 1: Lookups Introduction
- Lecture 2: VLOOKUP Explained
- Lecture 3: VLOOKUP Example
- Lecture 4: HLOOKUP Explained
- Lecture 5: HLOOKUP Example
- Section 15: Conclusion
- Lecture 1: Course Conclusion