Select Page

# Excel Intermediate Training on September 28, 2017

• Location: Atlanta and Gwinnett County GA
• Start Time: 8:30 a.m.
• Instructor: Chris Menard

# Excel Intermediate Course Description:

In this course, you will learn how to work with large worksheets in Microsoft Excel 2013 / 2016, and use multiple worksheets and workbooks efficiently. In addition, you will learn more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks.

Also, you will learn how to create outlines and subtotals, and how to create and apply cell names; sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Finally, you will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook.

# Just some of the topics from Excel level 2

## Managing workbooks and worksheets

• Topic A: Viewing large worksheets
• Topic B: Printing large worksheets
• Topic C: Working with multiple worksheets
• Topic D: Linking worksheets with 3-D formulas
• Topic E: Using multiple workbooks

## Keyboard Shortcuts for Excel 2

excel_keyboard_shortcuts from Chris Menard – 1 page of my favorite shortcuts (pdf)

excel keyboard shortcuts – full list from Microsoft’s website  – Excel keyboard shortcuts for Mac

• Topic A: Using special number formats
• Topic B: Other advanced formatting

## Outlining and subtotals

• Topic A: Outlining and consolidating data
• Topic B: Creating subtotals

## Data structure and tables

• Topic A: Sorting and filtering data
• Topic B: Working with tables

## Documenting and auditing

• Topic A: Auditing features
• Topic B: Comments in cells and workbooks
• Topic C: Protection
• Topic D: Workgroup collaboration

## Functions

• Topic A: Sum, Average, Max, Min, Large, Small, Median
• Topic B: Countif, Sumif, If Statements, and other functions

## Survey for Excel 2

Survey for Excel 1 & 2 on 9/28/2017

# Videos of topics covered in class

## Text to Values or Numbers

T function is used

# Several videos from Excel Intermediate

Below are videos from some of the topics from Excel level 2.

• Video 1 is how to create a 3D reference in Excel.
• Video 2 shows how to use Conditional Formatting with the Countif Function.
• Video 3 is how to transpose or switch data.
• Video 4 shows page breaks, printing titles, and using Subtotals to automatically create page breaks.

As of July 1, 2018

# Extra stuff

Below is a website to check your password security, and a website to see if your email was involved in a data breach.