Excel Logo.webp

Microsoft Excel is the most popular spreadsheet program you will encounter. Used almost universally throughout business and the government, Excel handles everything from adding and subtracting to manipulating large sets of data and so much more. So vast is its feature list that even experienced users often find there is still much to learn. It’s a very sandbox-like environment where you can do almost anything and the more features you know about, the more options you have.

Often the biggest hurdle is thinking creatively enough to determine how various features can be combined to solve a problem. That is why we believe it is vital for Excel training to teach you to apply what you are learning in the real world.

Our Microsoft Excel courses will help you:

  • Work faster and more accurately by getting Excel to do your calculations for you

  • Make your reports more useful by converting plain-looking data into visually striking charts

  • Find what you are looking for in large sets of data through sorting, filtering and other features

  • Get Excel to retrieve appropriate data or make decisions for you using advanced functions

  • Roll up multi-dimensional data into useful 2-dimensional reports through Pivot Tables

  • ...and more

To discuss Excel training for yourself or your team, please contact us at craig@prioritymanagement.com 

Getting Started with Microsoft Office 365 - Excel 2019

Workshop Goal:
This one-day hands-on workshop will help participants become efficient in the basic use of the Microsoft Excel 2019/365 program. By gaining a solid understanding of spreadsheet concepts participants will increase their productivity. This workshop introduces the methods of data entry, formatting, using basic formulas, printing, and being comfortable with the terminology in Excel.

Unit 1: Getting Started with Microsoft Office 365 - Excel 2019
✓ Navigate the Excel User Interface
✓ Use Excel Commands
✓ Create and Save a Basic Workbook
✓ Enter Cell Data
✓ Use Excel Help

Unit 4: Formatting a Worksheet
✓ Apply Text and Number Formats
✓ Align Cell Contents
✓ Apply Styles and Themes
✓ Apply Basic Conditional Formatting
✓ Create and Use Templates

Unit 2: Performing Calculations
✓ Create Worksheet Formulas
✓ Insert Functions
✓ Reuse Formulas and Functions

Unit 5: Printing Workbooks
✓ Preview and Print a Workbook
✓ Set Up the Page Layout
✓ Configure Headers and Footers

Unit 3: Modifying a Worksheet
✓ Insert, Delete, and Adjust Cells, Columns, and Rows
✓ Search for and Replace Data
✓ Use Proofing and Research Tools

Unit 6: Managing Workbooks
✓ Manage Worksheets
✓ Manage Workbook and Worksheet Views
✓ Manage Workbook Properties

MS Excel 2019/Office 365 Level 2 

Workshop Goal:
This one-day hands-on workshop will help participants become efficient in the basic use of the Microsoft Excel 2019/365 program. By gaining a solid understanding of spreadsheet concepts participants will increase their productivity. This workshop introduces the methods of data entry, formatting, using basic formulas, printing, and being comfortable with the terminology in Excel.

 

Recommended Prior Learning: Completion of the Excel Level 1 workshop or equivalent knowledge.

Unit 1: Calculating Data with Advanced Formulas
✓ Apply Cell and Range Names
✓ Calculate Data Across Worksheets
✓ Use Specialized Functions and Array formulas

Unit 4: Presenting Data Using Charts
✓ Create a Chart
✓ Modify Charts
✓ Format Charts
✓ Use Advanced Chart Features

Unit 2: Analyzing Data with Functions and Conditional Formatting
✓ Using text and logical functions
✓ Use Specialized Functions
✓ Work with Logical Functions
✓ Work with Date & Time Functions
✓ Apply intermediate and advanced conditional formatting

Unit 5: Analyzing Data Using PivotTables, Slicers, and PivotCharts
✓ Create a PivotTable
✓ Analyze PivotTable data
✓ Filter Data Using Slicers
✓ Analyze Data Using PivotCharts

Unit 3: Organizing Worksheet and Table Data
✓ Create and Modify Tables
✓ Format Tables
✓ Sort or Filter Data
✓ Use Subtotal and Database Functions to Calculate Data

Extras:

Financial Functions

✓ Working with Graphical Objects

✓ Using Array Formulas

MS Excel 2019/365 Level 3 

Workshop Goal:

Upon completion of this one day hands-on workshop, participants will be able to enhance productivity and efficiency by streamlining workflow, collaborate/share with other workbook users, audit worksheets, analyze data, work with multiple workbooks, import and export data and use macros.

Recommended Prior Learning: Completion of the Excel Level 2 workshop.

Unit 1: Working with Multiple Workbooks
✓ Consolidate Data
✓ Link Cells in Different Workbooks
✓ Use Links and External 3-D References

Unit 4: Collaborating with Other Users
✓ Protect Files
✓ Share a Workbook
✓ Track Revisions
✓ Merge Workbooks
✓ Restrict Document Access

Unit 2: Applying Conditional Logic
✓ Use Lookup Functions
✓ Combine Functions
✓  Use Formulas and Functions to Apply Formatting

Unit 5: Automating Workbook Functionality
✓ Update Workbook Properties
✓ Create a Macro
✓ Edit a Macro
✓ Apply Conditional Formatting

Unit 3: Auditing Worksheets
✓ Add Data Validation Criteria
✓ Trace Cells

✓ Search for Invalid Data and Formulas with Errors
✓ Watch and Evaluate Formulas

Unit 6: Forecasting Data

✓ Create Trendlines

✓ Create Sparklines

✓Create Scenarios

✓ Perform a What-If Analysis

✓  Perform a Statistical Analysis with the Analysis Tool Pak