Excel Formulas and Functions 101
Summary
Microsoft Excel has hundreds of formulas and functions. Therefore, experienced users still find themselves asking if they could be working more efficiently in Microsoft Excel.
Don’t waste any more time clicking around in Excel, trying to find the right tools needed to get your work done professionally and on time.
Join us for this 90-minute interactive instructor-led training to get more done in less time and build foundational Excel skills.
You’ll learn:
- Steps to create formulas to automate calculations (add, subtract, multiply and divide)
- Popular aggregate functions to analyze your data like a pro
- Easy solutions for simplifying long-winded formulas
- How to avoid common “copying formula pitfalls”
- Expert methods to verify formula accuracy
- BONUS - All attendees will receive the following Quick Reference e-Guides:
- Excel Shortcut Favorites
- A Quick Guide to Formulas
- A Quick Guide to Functions
- A Guide to Absolute Cell References
Topics Covered
- How to create formulas quickly and easily from scratch
- Formulas v Functions – what is the difference?
- Auditing tools that verify accuracy of results
- The role that absolute and relative values play in formulas (one mix-up could make your whole sheet inaccurate)
- Auto Calculate feature (it does exactly what it sounds like!)
- Real-life scenarios where IF Functions will save you time
- SUM, AVERAGE and COUNT functions to speed up your work (total game-changer when working with large data)
- CONCATENATE – combine text from multiple cells
- SORT and UNIQUE – Manipulating Lists
- And more!
Additional tools:
- 90-minutes of assisted exercises to boost your performance right away - work with the expert while you learn
- Get instant, real-time answers to all your questions during the webinar!
About the Speaker
Melissa Esquibel stands at the forefront of the technological revolution as a distinguished technology consultant, esteemed coach, dynamic trainer, and captivating speaker.
- Since embarking on her journey in 1991, Melissa has been an instrumental force in transforming the operational efficiencies of numerous companies across a spectrum of industries through her mastery of Microsoft Office Suite—including Excel, Word, PowerPoint, Access, and Outlook.
- Her profound insights are not just limited to technology; they are deeply rooted in a robust foundation of finance and accounting, honed through years of dedicated service in the banking and accounting sectors. This unique blend of skills allows Melissa to approach technology not merely as a tool, but as a strategic asset that can be leveraged to achieve unparalleled efficiency and productivity.
- Her sessions are not just lessons; they are transformative experiences that empower business professionals with the knowledge and skills to navigate the ever-evolving technological landscape confidently.
Program Benefits
It’s perfectly possible to use Excel without ever creating a formula or using a function - but if you don’t - you’re missing out on a HUGE part of the application’s power.
Without them, you waste much time doing manual work and correcting worksheets filled with errors (IF you’re lucky enough to catch them).
This interactive training will not only save you time, but push you forward in your career to be able to make informed, strategic decisions every day.