Purchase any WEBINAR and get
$10 Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 20th Sep'26 to 30th Sep'26
Key Essentials of Formulas Functions & Automatic Calculation in Excel
Duration
90 Mins
Webinar ID
IQW23G0730
Level
Basic & Intermediate
Speaker
- Outline of the 450+ functions in Excel
- Essential functions review
- Setting automatic calculations
- Absolute and relative references
- Insert Function-to simplify creating complex functions
- Count functions
- IF function-incorporate nesting
- UPPER, lower and Proper – to control text case
Overview of the webinar
To work efficiently with formulas and functions you must start with a clear understanding, good habits, and application of correct structure and syntax.
Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at an introductory level.
This course effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you need to understand the depth and scope of these Excel features.
Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government, and business administration.
NOTE: To maximize knowledge retention, this webinar includes a professional step-by-step Learner Guide, exercise files, demonstrations, and practice exercises.
Who should attend?
- A diverse range of professions including accounting, banking, financial planning, business analysis, economics, investment advice, bookkeeping, education, small/medium business, statistics, consulting, strategic planning, tourism, and hospitality, etc;
- Private, public, and academic sector staff, managers & executives, or anyone seeking to maximize their investment in MS Office to confidently use each relevant MS Office application to:
- Accurately manage and present data, financial statements, charts, and business-critical information;
- Effectively use and manage email, appointments, and meetings;
- Produce engaging presentations for sales, marketing, staff updates, training, etc;
- Create professional, fully referenced, clear, and concise documents, reports, and publications;
- Plan, manage, track, and finalize projects efficiently;
- Design, update and manage database tables, forms, queries, and reports.
Why should you attend?
A diverse range of professions including accounting, banking, financial planning, business analysis, economics, investment advice, bookkeeping, education, small/medium business, statistics, consulting, strategic planning, tourism and hospitality, etc;
Private, public, and academic sector staff, managers & executives, or anyone seeking to maximize their investment in MS Office to confidently use each relevant MS Office application.
Faculty - Mr.Ray Evans
Ray blends a professional, easy-going style with a strong grasp of adult learning—demonstrated across classroom, seminar, workshop, and live-online delivery, supported by practical, high-retention instructional materials.
Backed by Microsoft certifications, Ray teaches more than 2,500 topics spanning Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher—and is one of very few presenters delivering expert-level webinars across all six leading AI cognitive engines: Claude, ChatGPT, Copilot, Grok, Gemini and DeepSeek.
He holds qualifications in Frontline Management, Accounting, Training and Assessment and is certified in Six Sigma business-improvement methodology.
Since 1990, Ray has trained over 40,000 students, business owners, and executives, and authored extensive training documentation, complex reports, and engaging web content—consistently demonstrating exceptional communication and knowledge transfer.
Ray's webinars replicate the in-person classroom experience and include:
- A comprehensive step-by-step Learning Guide
- Demonstrations and practical exercises
- Exercise files
- Productivity techniques, tips and shortcuts