Excel - A Beginner\'s Guide to Formulas and Functions
Scope of the webinar :
Are you new to Excel and struggling to understand formulas? Look no further! This online training session is the perfect solution for you.
Think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.
Functions are built-in formulas that have been programmed to perform a specific calculation. They can often be used to shorten and simplify what would otherwise be a long-winded manually-entered formula.
Topic Covered :
- Creating basic formulas: addition, subtraction, division, multiplication
- Using parentheses in formulas - the what and why
- Copying a formula - the gotchas you need to know about
- Make formulas logical and understandable by assigning names to your important cells
- Speed up your work by using the SUM, AVERAGE and COUNT functions
Who should attend :
This training is perfect for beginners who are new to Excel or have limited experience with formulas. Whether you are a student, professional, or simply looking to improve your Excel skills, this training is for you.
About The Speaker
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI. Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries including healthcare.