80% of the workforce uses Excel. Our Excel training will bring your skills to the top of the pack

Are you proficient in Excel? Maintaining and creating spreadsheets is a requirement for almost every office job. This short hands-on workshop teaches the most essential skills needed to maintain workbooks. Topics include:

• Spreadsheet Basics
• Creating worksheets from scratch
• Formatting Features and Tricks
• Creating Formulas 
• Using Functions
• Page Layout Options
• Shortcuts and Tricks

This workshop is designed to familiarize users with some of Excel’s logical, lookup, and financial functions. The course also explains how to prevent formula errors by using absolute references and named ranges, and how to perform what if analysis using the Goal Seek tool. Other tasks covered in this course include protecting and sharing workbooks with other users. 

•  Working with Ranges
•  The IF Function
• Lookup Functions
• Financial Functions & Goal Seek
• Protecting Workbooks
• Sharing Workbooks

Users will learn how to work with data tables to filter, total, and manage lists.  The class will also discuss how to use the Pivot table tool to create cross-tabulated Excel reports that summarize and analyze data. Finally, users will learn how to combine data using the consolidated tool and create what if scenarios. Topics include:

• Working with Tables
• Generating Pivot Table Reports and Charts
• Creating Scenarios
• Consolidating Data

This workshop is designed to demonstrate the Excel graphing tools, and how to create formatting and data consistency with templates. Users will also learn how manage, share, and link data across both worksheets and workbooks.  Topics include:

• Quick Analysis Tools
•  Creating Charts
•  Managing Multiple Worksheets
• Creating 3D Formulas
• Creating Templates
• Data Validation Tools

80% of the workforce uses Excel. Are you getting the most out of this tool? There are so many different shortcuts and features that can help you to analyze and track data. Designed for the intermediate Excel user, our Excel Productivity Tips class demonstrates hands-on some of the best features Excel has to offer. Topics include:

· Conditional Formatting

· The Quick Analysis Tool

· Charts

· Pivot Tables and the Get Pivot Function

· Index/Match Function

Managers can use Excel for much more than basic Accounting tasks. Excel contains features designed to track and summarize large lists of data. This training focuses on not only teaching data analyzation tools, but it also introduces shortcuts and best practices to help leaders perform tasks productively. Tools introduced in this training include; data tables, pivot tables, logical and lookup functions, charting, and the Goal Seek feature.