3-Hour Virtual Seminar on Mastering Excel Formulas and Functions (Recorded)

Course Description:

An Excel formula is an equation or calculation that is stored in a worksheet cell. A formula enables you to perform simple or complex calculations on numbers. So 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 range from simple such as SUM and AVERAGE (used to calculate the total and average of numbers in a range of cells) to the powerful IF and VLOOKUP.Functions aren't limited to calculating numeric data. They can save you a ton of time when working with text and dates too.

• Need to calculate someone's age from their date of birth?
• Need to combine text items from several cells into a single cell?
• Need to convert a list of lowercase text items to capital letters?
• Need to compare items in two lists?

All of the above (and much more!) can be done by using Excel functions.

Why Should You Attend?

Although it is perfectly possible to use Excel without ever creating a formula if you don't, you're missing out on a huge part of the application's power.Learning how to create formulas will automate your calculations and save you a ton of time. No more using your fingers. No more mental arithmetic. No more using the calculator app on your Smartphone! Let Excel do the work for you!Excel has over 450 built-in Worksheet Functions (pre-defined formulas). Nobody needs to know them all however, no matter what your job role is, no matter what industry you work in, there are some key Functions that everyone should know how to use. This training will address those Functions.

Area Covered In The Webinar

• Creating formulas to perform mathematical calculations
• Copying a formula - the Gotchas you need to know about
• Cell Names - how to make formulas logical and understandable
• Combining text strings from multiple cells
• Converting text from lowercase to uppercase and vice versa
• Performing calculations on dates and times
• Logical functions (IF, COUNTIF, SUMIF, and more)
• VLOOKUP, HLOOKUP, INDEX, and MATCH
• GETPIVOTDATA
• Trapping Errors - Using functions to bullet-proof your worksheets
• Creating complex functions the easy way

Who Will Benefit:

• Any Excel user who needs to go beyond the basics of using formulas or simply wants to become more comfortable and productive in using Excel formulas and functions
• Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar

Instructor Profile:

In a career spanning over 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 on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.

Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.

In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

FAQ: How can I access the recorded Webinar?

Upon purchasing the webinar, if you have opted for the "Recorded Session: Online Link" ticket, you will receive an email containing the ticket details upon completion of payment. This email will include the online link and password required to access the webinar.

Register Now!

Refund and Cancellation Policy

At GRC Training Online, we strive to provide the best possible experience for our attendees. This Refund and Cancellation Policy outlines the guidelines for refunds, cancellations, and other related matters. By registering for our Live Webinars and On-Demand Recordings, you agree to adhere to the following terms:

1. Refunds for Live Webinars:

• Attendees may cancel their registration up to two working days prior to the course start date to be eligible for a full refund.
• If GRC Training Online cancels a Live Webinar, a full refund will be processed within two working days.

2. Non-Refundable Situations:

• Refunds will not be given to participants who do not attend the webinar or cancel within 24 hours before the webinar start time.
• On-Demand Recordings are non-refundable. However, participants may request access to alternative webinars in exchange.

3. Webinar Cancellation:

• GRC Training Online reserves the right to cancel a Live Webinar due to insufficient enrolment or unavoidable circumstances.
• Attendees will be notified at least 24 hours in advance if a webinar cancellation occurs, and a full refund will be provided.

4. Substitution Policy:

• Substitutions of registered participants can be made at any time before the webinar starts. Please inform us of any substitution requests to ensure smooth registration.

5. Feedback and Concerns:

We value the feedback and opinions of our customers. If you have any concerns about the content or delivery of the webinar and are not satisfied with your experience, please contact us at marketing@grctrainingonline.com or by phone at +1-302-433-6276 Mention your feedback for a prompt resolution of the matter.

We appreciate your valuable input, as it helps us continuously improve our products and services to meet your expectations.

Note:

• Refunds will be issued using the same payment method used for registration.
• GRC Training Online reserves the right to modify this Refund and Cancellation Policy at any time without prior notice. Any changes will be effective immediately upon posting on our website.

For any questions or clarifications regarding this policy, please contact us at marketing@grctrainingonline.com or +1-302-433-6276.

Thank you for choosing GRC Training Online for your training needs. We look forward to providing you with valuable learning experiences.