Advanced Functions, including

• Lookup variations
• IF and IFERROR
• SUMIF and SUMIFS
• AND & OR
• String functions LEN, LEFT, MID, RIGHT
• FIND

Charting Options

• Set Axis Titles
• Change data colors
• Dual data axis

Conditional Formatting

• Based on value of cell
• Based on a formula

Cell Styles

• Creating a Style
• Applying the Style
• Editing the Style

Pivot Tables

• Identifying appropriate data
• Setting up the Pivot Table
• Modifying the Pivot Table

And more!

The course will run live on Zoom

• Five class sessions on Thursdays
• January 25, Feburary 1, 8, 15, 22, 2024
• 11:00 am - 12:00pm MST
• for only $347

Now is the chance to Elevate your Excel experience! Take the oppotunity to add to your skills, improve your efficiency, and build your confidence. Seats are limited, so Contact Me and I will make sure your receive notice as soon as registration begins!.

Sign up for Step Up now:

Understanding the spreadsheet

• Structure of the sheet
• Multiple sheets
• Entering information
• Column Widths

Building Formulas

• Formula characters
• Order of Operations
• Basic functions: SUM, AVERAGE, COUNT
• Specialized functions: PMT

Formatting

• Text formats
• Number formats

Editing

• Moving Cells & formula references
• Copying
• Inserting Rows and Columns
• Shifting whole columns
• Formulas across multiple sheets
• Sorting and filtering

Charts and Printing

• Create a basic Chart
• Set Print ranges
• Other Print setup options

The course will run live on Zoom

• Five class sessions on Tuesdays
• January 23, 30, February 6, 13, 20, 2024
• 11:00 am - 12:00pm MST
• for only $347

Now is the chance to grow your Excel experience! Take the oppotunity to create formulas, navigate and format effectively and edit the file. Seats are limited, so Contact Me and I will make sure your receive notice as soon as registration begins!.

Sign up now:

From the beginning of computer spreadsheets with VisiCalc on Apple II people have been finding the value of an electronic file that provides the opportunity to perform "what-if?" analyses, and immediately see the results of those changes, even in the most complicated structure.

As the capabilities and functionality grew, the challenge to using the complexities effectively grew as well.

With solid, clear training, I can provide the skills to make your Excel experience broader and more satisfying and much less frustrating!

I love to see the light in users' eyes when they have the "Wow, I can do this?" moment!

The Finance Director of an international medical device company contacted me with a need to update and process a large and complicated budget model. It had been developed by someone else and that person was no longer around, and budget season was coming soon. I was able to sort out the system (that had little documentation), make substantial changes to both the formulas and the automated VBA programming to accommodate new rules for the current year budget. The final budget models were built and distributed on time. Client X was so satisfied that I continued to update the budget model each year for over 10 years, with new features and improved peformance.

The Sales Manager of a traffic control equipment manufacturer needed a way for the sales force to configure quotes for their customers. The devices they sold came with an ititial configuration, but had substantial customization options for each product, and the client needed to build quotes quickly. I was able to build a simple to use single page for selecting the devices and customized options, while with the customer, and then a page with a complete quote was ready for email or printing. This saved the sales force a substantial number of hours trying to assemble the quotes, and then send to the customer.

A scattered and disconnected set of numbers on a spreadsheet was provided by the CEO of a developing recreational equipment builder. They were having trouble communicating with their outside Business Analyst and nothing was moving along. I was able to sort out and organize the data into a clear model to project sales and expenses. They could then input the current numbers and provide forecasting for the next 3 years. They were pleased with the ease of using the spreadsheet and able to present something the analyst could easily understand.

You can hire me to do your own project like these Excel users did, or you can take this course and learn the techniques and tools that will let you build your own more sophisticated spreadsheets!

I contacted Dan Prendergast because I wanted to brush-up on my advanced Excel skills. Dan provided training specifically tailored to my needs. The training coursework was comprehensive and detailed. Especially helpful was the way in which the training was structured. Dan provided an example of the formula, taught me how to apply the formula, and then required me to practice utilizing the formulas. This teaching method enabled me to learn Excel formulas more easily. Additionally, Dan is a very patient and supportive teacher—traits I highly prize in an instructor.

Dan is a clear and patient teacher. He’s able to break down complex processes into manageable steps than non-IT people can grasp and remember.

Through Dan's course I learned how much is possible within Excel and the ability to use those tools and tricks for my needs. After each session I found myself using the knowledge I learned from the last. The lessons and examples were easy to digest and easy to expand on.

I have used Excel for a number of years, but had fallen into habits of use that I knew were not utilizing Excel to its full capacity. Dan Prendergast's Elevated Excel took my skills up a level. The class was well laid out and clear to follow, teaching some of the deeper functionality that I knew lay below the surface, but that I had not been able to teach myself. I spend a fair amount of time Googling "how-to" in Excel, but the class went beyond this, by showing me functions that I didn't know were a possibility. A great value for the money.