Purchase any Event and get
20% Off
CODE: TWENTY20
T&C applicable, please referFAQ
Validity : 16th Nov'24 to 26th Nov'24
Excel Essentials - Beginners Guide to Excel Formulas
- Core Concepts of Formulas: A step-by-step introduction to formula structure, helping you write your first formulas with confidence.
- Essential Functions Explained: Explore key functions such as SUM, AVERAGE, MIN, and MAX, with practical examples on how to apply them effectively.
- Cell Reference Techniques: Learn how, why and when to apply different reference styles - relative, absolute, and mixed references.
- Leveraging Names and Tables: Understand how using named ranges and structured tables can make your formulas more intuitive and efficient.
- Applying Formulas to Real Scenarios: Work through practical examples to see how formulas can solve common Excel problems.
Overview of the webinar
This session offers an in-depth introduction to Excel formulas, perfect for beginners. You will explore everything from basic arithmetic functions and calculating percentages to understanding useful Excel functions and the application of dollar signs within cell references.
With practical exercises, this training ensures you can confidently apply what you learn to real-world tasks. By the end, you’ll have the skills to confidently apply formulas to your own data, no matter your experience level.
Who should attend?
- All Excel Users
- Accountants
- Payroll Clerks
- Bookkeepers
- Tax Accountants
- Management Accontants
- Credit Analysts
- Recruitment Consultants
- Auditors
Why should you attend?
For those new to Excel formulas, this session provides a thorough introduction designed to remove the guesswork.
You’ll start with the basics and progressively build your skills. Through straightforward explanations and practical examples, you’ll discover how formulas can simplify your work and save time.
No prior experience is required - just a willingness to learn and a desire to work smarter with Excel.
Faculty - Mr.Alan Murray
Alan Murray is a Microsoft MVP and Excel trainer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making people’s working lives easier.
Alan runs his own blog - Computergaga (https://computergaga.com) and writes for multiple other websites. His YouTube channel has over 600 videos and over 40 million views.
He organizes a free monthly Excel meetup in London where anyone can come learn Excel, chat, and enjoy each other’s company.
Alan is the author of the best-selling ‘Advanced Excel Formulas’ and ‘Advanced Excel Success’ books.