Excel spreadsheets, when set up correctly, can be a tremendous asset and time-saver to an individual or organization. However, the reverse is also true – when not set up correctly they can be cumbersome and provide no value other than a page of data. In these sessions, we’ll show you how to set up a spreadsheet for maximum benefit, tricks and tools to working with your spreadsheet easier, and powerful tools available when the spreadsheet is set up correctly.
Learning Options
- Live format: Sessions listed here can be delivered live, either in-person or virtually. Contact us for more information.
- eLearning: Sessions listed with a Go To Session button have been recorded and are available for immediate access. Each eLearning session is $29 and approximately 1 hour in length.
- Certificates: Each eLearning session provides a certificate upon successful completion. Certificates provided upon request for live events.
- Tax Exempt Organizations: Contact us for billing options.
Sessions
Getting Started
Excel: Getting Started
This session is designed to be a crash course in Excel. We highly recommend taking the respective Fundamentals course for comprehensive training. However, if you are short on time and need to get up to speed on a topic quickly, these will do just that. The sessions below will be applicable regardless of the version of Microsoft Office that you use.
Fundamentals
Excel Elements
If you have ever opened the Excel window only to close it again frustrated or intimidated, this session will bring much needed clarity to what you are seeing and why. This session also includes some great Microsoft Office tips often overlooked or unknown by the frequent user.
Creating a Spreadsheet
We’ll walk through the process of creating and saving a spreadsheet, including some great data entry tools that will make entering your data super easy!
Formatting a Spreadsheet
With Excel’s formatting tools, it is really simple to get consistent formatting that looks sharp. We’ll explore the various formatting tools available including number formats and learn how to quickly apply them everywhere you want.
Setting Page Layout
Unlike Microsoft Word, what you see on the screen is not necessarily what you will see in printed format. In this session, we’ll learn how to set up your page so it looks as great printed as it does on the screen. Topics include: Print Preview, Print Settings, Margins, Orientation, Paper Size, Gridline
Excel Formulas
Let formulas do the calculating in your spreadsheet! Even better, when written well, they automatically update. In this session, we’ll cover all aspects of formulas: deciphering them, writing them, and using built-in functions to do the work for you.
Excel Fundamentals BUNDLE
The 5 sessions listed above make up our Excel Fundamentals workshop, designed to give you the knowledge you need to become proficient in Excel. This workshop can be delivered as 2, half-day, hands-on workshops or purchased as an eLearning bundle. When purchasing the eLearning bundle, get all 5 sessions for the price of 4! Bundle Cost: $116
A Better Way To
Creating an Effective Spreadsheet
We’ll walk through the process of creating an effective spreadsheet, including some great data entry tools that will make entering your data super easy! These guidelines and tools will apply to any version of Microsoft Office that you are using.
Page Setup Tools
It is difficult to create an effective spreadsheet if you don’t know how to apply some valuable formatting such as printing column labels on every page or freezing your display. These elements will apply to any version of Microsoft Office that you are using!
Sorting & Subtotals
I’ll show you how to sort quickly and safely, how to do some advanced sorts, and how to have Excel automatically group and summarize your data with Subtotals. These elements will apply to any version of Microsoft Office that you are using!
Filtering & Finding
When you are working with large amounts of data, it can be difficult to find exactly what you’re looking for. Additionally, sometimes you would just like to see a subset of your data without changing the sort order. I’ll show you how to do all of that plus get quick answers from your data. These elements will apply to any version of Microsoft Office that you are using!
PivotTables & PivotCharts
In this session we’ll discuss the critical first step to creating a PivotTable, how to get started, and the many options available for seeing your data. These elements will apply to any version of Microsoft Office that you are using! If they’re located in a different version, I try my best to point you in the right direction.
A Better Way to Use Excel BUNDLE
The 5 sessions listed above make up our A Better Way to Use Excel workshop, part of our A Better Way to signature series. This workshop can be delivered as a half-day workshop or purchased as an eLearning bundle. When purchasing the eLearning bundle, get all 5 sessions for the price of 4! Bundle Cost: $116
Advanced Topics
Advanced Formatting
In this session, we’ll explore some lesser-known features that are super helpful! Topics include using the Font Formats, Number Format Options, Alignment Options, Themes, and Cell Styles. These elements will apply to any version of Microsoft Office that you are using!
Advanced Formulas
If Statements, Absolute Cell References, Text Formulas and more! If you would like to know more about working with formulas, this session is for you! These formulas will apply to any version of Microsoft Office that you are using!
Advanced Tools
Perhaps a better session title would be “The Junk Drawer of Excel”. Not that these tools are junk! They are very helpful tools but I have never managed to fit them into a defined collection. Like those tools in a junk drawer at home, these Excel tools must be handy when you need them! We’ll talk about comments, notes, hyperlinks (for purposes other than websites and email addresses), hiding/unhiding (for purposes other than rows and columns), and…drum roll please…macros!
Conditional Formatting
Conditional Formatting is formatting that is automatically applied based on whether or not certain conditions are met – conditions that you determine. For example, you could ask Excel to use a different format to identify largest values, duplicate values, or cells containing certain text. You can also tell Excel to create a jazzy little visual within your data to help you quickly see trends. In this session, I’ll show you how to set up conditional formatting, some of my go-to conditional formats, their results, and how to manage them once they’re created.
Restricting & Protecting Data
Scared someone will mess things up in your beloved spreadsheet? In this session, we’ll discuss various options for protecting your information and restricting what others can see and do in a spreadsheet. Topics include file level passwords and protection, locking cells, protecting a spreadsheet, and data validation. These settings will apply to any version of Microsoft Office that you are using!
Worksheet Options
When one sheet just won’t do, we’ll explore how you can set up and use multiple sheets in the same workbook file. Topics include: Inserting, Moving, Copying and Deleting worksheets, Changing sheet properties, and Linking worksheets. These topics will apply to any version of Microsoft Office that you are using!
Workplace Solutions
Forms & Templates using Microsoft Excel
Tired of filling out forms, paper or electronic, that just really aren’t set up efficiently? This session will be one-part learning the necessary tools and settings for creating a form in Excel and one-part using them! We’ll spend part of this session actually creating a form from scratch so you’ll see the process, and tools needed, from beginning to end!
”You’re an Excel savant. It’s like you unlock the secrets. The things I’ve learned from you have made my life so much easier. Plus, we have a better understanding of what’s going on in our business!”
Subscription pricing available!
Let’s Grow Together
We call it our Let’s Grow Together program, giving participants unlimited access to eLearning sessions & Express Training registration for one year from date of purchase.
