Skip to content Skip to site navigation Skip to service navigation

Excel: Shortcuts, Functions, and Charts

Class Sessions

Date Cost
  • Thu Feb 15, 9:00 am to 4:00 pm
$395

Class Code

ITS-1272

Class Description

Learn Excel functions such as VLOOKUP, SUMIFS, SUMIF, IF, and SUBTOTAL, as well as improved charting and charting templates to help maximize your speed and efficiency to streamline your work.

This one-day seminar will cover some of the classic Excel functions that have caused havoc for years: VLOOKUP, SUMIFS, SUMIF, IF, and SUBTOTAL, among others. 

It will also help maximize your speed and efficiency by capitalizing on all the new features that help streamline your work. Excel offers amazing functionality, including more built-in functions, improved charting and charting templates, and improved ribbon customization. This is an opportunity to upgrade your skills.

Objectives

In this course you will learn to:
- Setup and navigate a worksheet
- Use Autofill to rapidly duplicate formulas and patterns
- Copy, paste, and link data between worksheets and workbooks
- Setup and understand print options
- Format worksheets including borders, number formats and cell behaviors
- Use the SUM, AVERAGE, VLOOKUP, IF, SUMIF, and other functions
- Understand the difference between a relative and absolute cell reference
- Use styles and autoformats to quickly format a worksheet
- Create and edit a chart
- Customize the ribbons/toolbars
- Create a basic macro to automate tedious tasks