Microsoft Excel Level II

(versions: 2003, 2007, 2010, 2016 and 2019)*

Location: Online Format (Zoom, WebEx, Google Meet)

General Overview:

Managing your data is a key to success in any business. Microsoft Excel is the standard spreadsheet application used throughout the world for this purpose.  Excel allows the users to build and calculate formulas quickly, efficiently and accurately. Excel’s database functions also enable users to find, extract, and analyze valuable data in order to make effective business decisions.

Learning Objectives:

In this course, you will create advanced formulas, utilize and maintain database records, and add graphic elements to your worksheets for greater visual impact.

You will Learn: 

• Named Ranges
• Workbook Security
• Templates
• Outlining
• Advanced Formulas
• Linking (External and Internal)
• Work with Multiple Workbooks and Worksheets
• Consolidating Data
• Charting (including Custom Charting
• Styles
• Sparklines

Target:

This course is for individuals who have the basic Excel knowledge provided in an Excel I course who wish to learn additional functions and tools to be able to organize and analyze their data.  In this course you will learn to customize excel and to streamline workflow by building on the basic skills learned in Excel Level I.   is a prerequisite for this course

Course Outline:

Section 1: Worksheet Organization

• Managing Range Name
• Creating and Using Workbook Templates
• Applying Worksheet Security
• Creating and Using Outline
• Revie Exercise

Section 2: Advanced Formulas 

• Using the IF Function
• Linking Formulas
• Modifying and Restoring Links
• Review Exercise

Section 3: Using Multiple Workbooks and Worksheets

• Working with Multiple Workbooks
• Working with Multiple Worksheets
• Consolidating Data
• Review Exercise

Section 4: Working with Charts

• Creating Charts
• Changing Chart Data
• Modifying Chart Elements
• Creating Custom Charts
• Review Exercise

Section 5: Applying Formatting

• Working with Styles
• Annotating Worksheets
• Using Sparklines
• Review Exercise

*All Classes are instructor led.
Class recording will be made available after the class.

LOOKING FOR ALTERNATIVE DATES – CONTACT US HERE