Excel Intermediate Workshop

Getting Started

1. Welcome to G Com Solutions Microsoft Excel Intermediate

2. Downloading the Course Files

1. 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

2. Conditional Functions

1. The IF Function

2. The IFERROR Function

3. Nested IF Statements

4. The OR Function

5. The AND Function

3. Conditional Number Crunching Functions

1. The COUNTIF Function

2. The SUMIF Function

4. Lookup Functions

1. VLOOKUP Exact Match

2. VLOOKUP Approximate Match

3. Using INDEX and MATCH

5. Date and Time Functions

1. The Today and Now Functions

2. Inserting Dates using AutoFill

3. The NETWORKDAYS Function

6. Advanced Formatting

1. Text Alignment

2. Text Wrap

3. Using the Format Painter

4. Conditional Formatting

5. Creating Cell Styles

7. Managing Multiple Workbooks and Worksheets

1. Setting the Number of Sheets in a New Workbook

2. Working in Group Mode

3. Viewing Multiple Workbooks

4. Moving and Duplicating Sheets

8. 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

9. Sparklines and Graphics

1. Creating Sparklines

2. Using Formulas with Graphics

10. 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

6. Creating Dynamic Charts from a Table

10-6-creating-Dynamic-Charts-From-Table-Data

11. 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

12. Filtering Data

1. Filtering Specific Values

2. Using the Search Box

3. Using Text Filters

4. Using Number Filters

5. Using Date Filters

13. 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

14. Introduction to Pivot Tables

1. Pivot Tables and Subtotalling Compared

2. Creating a Pivot Table (Part 1)

2. Creating a Pivot Table (Part 2)

3. Grouping Pivot Table Data