Excel 101: Course Outline

Do you feel like you're the only one who doesn't know Excel? Don't worry, you're in good company, and we're here to help! Welcome to Excel Introduction 101, where we'll guide you through the essentials of this vital spreadsheet software. With hands-on practice and interactive lessons, you'll gain the skills you need to excel in no time.

In this course, you'll finally understand the features you've seen in Excel at work. By the end of Excel Introduction 101, you'll be confidently creating your own professional spreadsheets, such as:

Structured Lists: Learn how to create well-organized lists for employees, products, customers, and more. Master the use of Excel's row and column formatting, adjust fonts, sizes, and colors, and freeze table headers for easy navigation and presentation.

Detailed Calculations: Excel excels at data analysis. You'll discover how to apply various arithmetic functions like averages, sums, and counts to your data, transforming raw information into meaningful insights.

Financial Spreadsheets: Handle financial data with confidence. Whether you're working on budgets, income statements, invoices, or tax calculations, you'll learn how to create dynamic spreadsheets where changes in one cell automatically update related figures. Understand how to use formulas to reference and manipulate data accurately.

Upon completing Excel Introduction 101, you'll be ready to take on more advanced Excel courses. Join us and start your journey to becoming an Excel pro today!

Module 1: Excel Fundamentals and Basic Functions (2 Hours)

Outcomes:

• Navigate Excel and create effective spreadsheets.

• Use essential Excel functions such as SUM, MAX, MIN, and AVERAGE.

• Select cells and sheets using keyboard shortcuts.

Topics:

• Introduction to Excel’s Interface

• Utilizing Search & Help Features

• Exploring Smart Lookup

• Adjusting Zoom Levels

• Navigating and Selecting Cells

• Mastering Keyboard Shortcuts

• Deleting and Replacing Cell Data

• Performing Basic Calculations

• Saving Your Workbook

• Overview of the Formulas Ribbon

• Creating Basic Formulas

• Using Essential Functions

• Employing Autofill for Formulas and Functions

• Understanding Relative and Absolute Cell References

Module 2: Spreadsheet Formatting, Design, & Printing (2 Hours)

Outcomes:

• Edit spreadsheets by adding and formatting columns and rows.

• Create reusable styles and formats by saving workbooks as templates.

• Adjust workbook settings for optimal printing using Excel’s print options.

Topics:

• Inserting and Managing Rows & Columns

• Moving, Copying, and Pasting Data

• Using Autofill to Complete Series of Values

• Formatting Data with Cell Styles

• Introducing Worksheet Themes

• Creating Custom Templates

• Managing Worksheets: Insert, Delete, Rename, Move, and Copy

• Grouping Worksheets for Better Organization

• Freezing and Splitting Panes

• Hiding and Grouping Rows/Columns

• Creating and Utilizing Custom Views

• Spell Checking Your Worksheets

• Setting Print Options

• Using Page Layout View for Print Preparation

• Printing Your Worksheet

Excel 201: Course Outline

Mastery of Excel is developed in stages: first, you learn basic formatting, functions, and formulas, and build a few spreadsheets yourself. Easy enough. But moving to the next level of proficiency is hard! To create truly professional-looking spreadsheets, you'll need to know how to organize data into elegant, interactive tables that dynamically generate colorful charts and graphs. To bring you up to an intermediate-level usage of Excel, we'll train you in how to use these core features:

Module 3: Advanced Tables and Data Organization (2 Hours)

Outcomes:

• Organize and filter data efficiently.

• Sort tables based on specific criteria.

• Apply advanced table formatting for better data presentation.

Topics:

• Creating and Managing Advanced Tables

• Using Filters to Display Specific Data

• Sorting Tables by Multiple Columns

• Applying "Format As Table" for Instant Formatting

• Adding Subtotals and Calculating Data Automatically

Module 4: Data Visualization with Charts and Pivot Tables (2 Hours)

Outcomes:

• Create and customize various chart types.

• Utilize pivot tables for dynamic data analysis.

• Generate pivot charts for enhanced data visualization.

Topics:

• Introduction to Excel's Chart Types

• Creating Line Charts, Bar Graphs, and Pie Charts

• Customizing Chart Appearance and Settings

• Understanding and Creating Pivot Tables

• Using Pivot Tables for Dynamic Data Grouping and Aggregation

• Generating Pivot Charts from Pivot Table Data

By the end of Excel Intermediate 201, you'll have the skills to create professional, dynamic, and visually appealing spreadsheets. Join us and take your Excel abilities to the next level!

Excel 301: Course Outline

After mastering basic formatting, formulas, functions, and charts, it's time to unlock Excel's more powerful features. Whether you're puzzled by someone else's advanced spreadsheet or need extra capabilities to enhance your own, this course will provide the solutions you need.

Module 5: Advanced Functions and Data Management (2 Hours)

Outcomes:

• Utilize advanced lookup and summary functions.

• Efficiently audit and manage errors in spreadsheets.

• Apply techniques for data cleanup and consolidation.

Topics:

• Naming and Using Ranges

• Exploring VLOOKUP and XLOOKUP

• Implementing the ROUND Function

• Auditing Formulas with Built-In Tools

• Creating Complex Conditions with Nested IF Functions

• Handling Errors with IFERROR

• Utilizing Summary Functions: SUMIF, COUNTIF, AVERAGEIF

• Manipulating Text with LEFT, RIGHT, and MID Functions

• Combining Text with CONCAT and Text-To-Columns

Module 6: What-If Analysis and Macro Automation (2 Hours)

Outcomes:

• Optimize data using Goal Seek and Solver.

• Automate tasks with macros and integrate them into the Excel interface.

Topics:

• Consolidating Data for Analysis

• Performing What-If Scenarios with Goal Seek

• Solving Complex Problems with Solver

• Managing Different Scenarios with Scenario Manager

• Recording and Running Macros for Automation

• Exploring the VBA Developer Interface

• Customizing Macros with the Visual Basic Editor

• Adding Macro Buttons to the Ribbon for Quick Access

By the end of Excel Advanced 301, you'll have the skills to tackle complex tasks and enhance your efficiency in Excel. Join us to become an Excel expert!