Microsoft Excel Intermediate

An accessible course for people who know Excel basics and wish to extend their skills and become more confident users.

| taught by G Com Solutions

Watch Intro Video  |   Free Trial

$75.00
SKU
Microsoft Excel Intermediate

Course Description

This is a practical, hands-on course for Excel middleweights looking to gain more confidence in using the program. It provides step-by-step practice in building formulas with useful text functions like LEFT, RIGHT, MID, PROPER and CONCATENATE; conditional functions like IF, IFERROR, SUMIF AND COUNTIF; lookup functions like VLOOKUP, INDEX and MATCH; and date functions like NETWORKDAYS.

The course also covers charts, sparklines, conditional formating, and graphics. It then moves on to look at all of Excel's key facilities for working with tabular data: customized sorting and filtering, subtotalling and the use of Excel tables and pivot tables.

All of the worksheets used by the trainer are available to students, enabling them to follow along and practice all of the techniques being demonstrated


COURSE CURRICULUM

Text Functions
  1. Flash Fill Revision
  2. Using the TRIM Function
  3. Changing the Case of Text
  4. The LEFT and RIGHT Functions
  5. The MID Function
  6. The CONCATENATE Function
Conditional Functions
  1. The IF Function
  2. The IFERROR Function
  3. Nested IF Statements
  4. The OR Function
  5. The AND Function
Conditional Number Crunching Functions
  1. The COUNTIF Function
  2. The SUMIF Function
Lookup Functions
  1. VLOOKUP Exact Match
  2. VLOOKUP Approximate Match
  3. Using INDEX and MATCH
Date and Time Functions
  1. The Today and Now Functions
  2. Inserting Dates using AutoFill
  3. The NETWORKDAYS Function
Advanced Formatting
  1. Text Alignment
  2. Text Wrap
  3. Using the Format Painter
  4. Conditional Formatting
  5. Creating Cell Styles
Managing Multiple Workbooks and Worksheets
  • Setting the Number of Sheets in a New Workbook
  • Working in Group Mode
  • Viewing Multiple Workbooks
  • Moving and Duplicating Sheets
Working with Charts
  1. Anatomy of an Excel Chart
  2. Creating a Column Chart
  3. Creating a Line Chart
  4. Creating a Pie Chart
  5. Creating a Pie of Pie Chart
  6. Creating a Doughnut Chart
  7. Creating a Bar Chart
Sparklines and Graphics
  1. Creating Sparklines
  2. Using Formulas with Graphics
Working with Excel Tables
  1. The Benefits of Using Excel Tables
  2. Creating an Excel Table
  3. Entering Data into a Table
  4. Using a Total Row
  5. Creating Dynamic Charts from a Table
Sorting Data
  1. Sorting by a Single Column
  2. Sorting by Multiple Column
  3. Using a Custom List for Sorting
  4. Sorting Columns instead of Rows
  5. Sorting Data in a Random Order
Filtering Data
  1. Filtering Specific Values
  2. Using the Search Box
  3. Using Text Filters
  4. Using Number Filters
  5. Using Date Filters
Outlining and Subtotalling
  1. Manually Outlining Data
  2. Creating an Automatic Outline
  3. Showing and Hiding Outline Symbols
  4. Creating Single Level Subtotals
  5. Creating Multi-Level Subtotals
Introduction to Pivot Tables
  • Pivot Tables and Subtotalling Compared
  • Creating a Pivot Table
  • Grouping Pivot Table Data

.

Write Your Own Review
You're reviewing:Microsoft Excel Intermediate