Excel Formulas & Functions Bootcamp
In this 90-minute training, discover essential Excel formulas and functions to solve your Excel problems and finish your daily checklist faster.
- Must know formulas: SUM, AVERAGE, COUNT, SUMIF, COUNTIF, IF, Nested Ifs & more
- Using the power of statistical & financial functions: Make daily tasks easier
- Formatting tricks in a few clicks: Showcase your data & highlight the vital info
- New formulas that will help you solve tough problems: Prevent annoying errors
Timesaving Excel Power Functions, Faster Formulas & Helper Cells
- Vital functions & formulas: New tricks to help ease your day
- Autosum tricks to analyze data quickly
- How to write "IF statements" that save hours of manual typing
- VLOOKUP - quickly find info in current and other worksheets
Math, Financial & Statistical Formulas Made Easy
- Pivot Table & Array Formulas that everyone should know
- Be more efficient with these functions: INDEX & MATCH
- Quickly identify trends with powerful statistical functions
- Tricks to easily summarize your data & converting Formulas to Values
About The Speaker
Mitzi Gibson Katz has trained thousands of end users and developed curriculum for over twenty-five years.
- As a consultant, she specializes in the Microsoft Office suite including Excel, Access, PowerPoint, Word, Outlook and much more.
- After teaching a variety of special education classes in Kansas, Montana, and Alaska for the early part of her career, Mitzi became interested in technology as the first personal computers were introduced to the market. She made the change in careers from public school education to private computer training and has been teaching students how to use software applications ever since.
- Mitzi helps students understand Excel by her passion: "It's the people part of the business that keeps me involved."
Learn powerful formulas and formatting techniques in Excel, saving you time and avoiding frustration.