Microsoft Excel

Section 1: Introduction to Microsoft Excel

 Introduction

 How to Get the Most Out of This Course

 Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon

 Using Excel Templates to Save Time and Effort

Section 2: Creating Your First Excel Document

 Saving Your Document Where You Can Find It

 Entering Data and Navigating Around the Cells

 Creating Simple Formulas to Do Powerful Calculations

 Working with Workbooks and Worksheets

 Put Your Knowledge to Work - Create Your First Excel Document

Section 3: Create a Kitchen Remodel Cost Worksheet

 Introduction - Creating and Formatting Your Heading

 Formatting Subheadings and Columns and Alphabetizing Lists

 Entering and Formatting Numbers

 Create Formulas to Quickly Calculate Your Costs

 Formatting - Grids and Spacing

Section 4: Introduction to Excel Formulas and Functions

 Introduction to Excel Formulas and Functions

 What is a Formula and What Can It Do for You?

 What is a Function and What Does IT Do?

Section 5: 3 Things to Know Before You Start Using Functions

 The Anatomy of a Formula

 Quickly Select Cells to Use in Your Formula

 Absolute vs. Relative Cell References

Section 6: How to Use the 7 Most Popular Excel Functions

 How to Use the Downloads to Learn Functions Faster

 AVERAGE and AVERAGE Functions

 COUNT, COUNTA and COUNTBLANK Functions

 IF Functions

 SUMIF and SUMIFS Functions

 COUNTIF and COUNTIFS Functions

 VLOOKUP Function

 LEFT, RIGHT, and MID Functions

Section 7: Other Popular Excel Functions

 CONCATENATE - Combining Text

 LEN - Length of Text

 FIND and SEARCH

 MIN and MAX

 AND and OR

 ROUND, CEILING, and FLOOR

 TODAY and NOW

 CONDITIONAL FORMATTING

 ALT Shortcut Keys for INDEX/MATCH Lecture

 INDEX and MATCH

 UPPER, LOWER, and PROPER

Section 8: Creating Charts from Your Spreadsheet

 Introduction - How to Create a Chart

 Format Your Chart

 Create a Bar Chart

 Create a Pie Chart

 Create a Line Chart

Section 9: Pivot Tables and Pivot Charts

 Introduction to Pivot Tables - Preparing Your Data

 How to Create a Pivot Table

 Put Your Pivot Table to Work

 Pivot Charts Download

 Pivot Charts

Section 10: Importing Data from Other Sources

 Import from Web, Copy/Paste, and Cleaning Up Data

Section 11: Excel Quick Tips and Tricks

 Flash Fill and AutoFill for Fast Data Entry

 Shortcut Keystrokes for Working Faster

 Paste Special for Better Pasting

 Laying Out Pages and Printing

 Find and Delete Empty Cells Located Outside of Your Data

 Use the Power of Tables

Section 12: Real-time project

 Microsoft Excel project environment setup

 Real-time Microsoft Excel project

 Project demonstration

 Expert evaluation and feedback

Section 13: You made it!!

 Spark Databox Microsoft Excel course certification

 Interview preparation

 Mock interviews

 Resume preparation

 Knowledge sharing with industry experts

 Counseling to guide you to the right path in Microsoft Excel development career