To use Excel effectively and efficiently, you need to know how to apply correct structure and syntax to your formulas and functions—you can’t afford to guess!
Working with formulas and functions in Excel is absolutely critical to building powerful financial and analytical worksheets and is probably the most important skill set for many Excel users. Excel, with its 450 built-in functions, is a potent power-tool set which simplifies certain types of formulas, giving you a large chunk of computational possibilities. Extended analytical capabilities can be achieved by various Excel functions, and they are known to open doors to more efficient Excel use, but with so many functions, it's not easy to know which functions are available and which ones you might have overlooked.
Join this webinar presented by our expert speaker who gives you perspective on what functions are available and explains (with extensive examples) how to use many of these functions and formulas, such as The IF function (with AND and OR), the powerful VLOOKUP function, selected Statistical, Date, Financial, and Mathematical functions, the Text functions which are frequently overlooked but are critical if you need to clean up problems with downloaded data; and the powerful COUNTIF/SUMIF family of functions and newer functions that were introduced in Excel 2010 and 2013.
This session will cover specific functions and formulas, and provide you with the perspective you require to understand the depth and scope of these Excel features. The speaker will cover all these with examples within the context of Excel worksheets, coupling them both with real-life examples that he has encountered in his vast consulting experience. After attending the webinar, you will be able to use a lot of productivity tips, accelerator tools and shortcuts that you understand from our expert speaker.
Webinar Agenda
Who Should Attend
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
GRCTrainer is an online training platform that provides most affordable and updated information, knowledge, updates, regulations to professionals across industries. The training sessions are designed and developed by leading subject matter experts and industry veterans, helping learners to upgrade their knowledge and brush up their skills. Trainings include the latest regulatory changes, compliances to existing regulations, day-to-day business, operational, software, technology and creative skills to achieve personal, professional and organizational goals.
With our webinars and online training modules, you can have an incredible learning experience right at your…
Read MoreDate | Conferences | Duration | Price | |
---|---|---|---|---|
Jun 19, 2023 | Pick-3 Power Bundle (50% Off) | Mins | $349.00 | |
Apr 18, 2023 | Top 5 Claim Denial Management & Their Appeal Drafting Sessions | 300 Mins | $599.00 | |
Sep 13, 2022 | Toxic Employees & Difficult Conversations - How To Tackle Them Both? | 120 Mins | $349.00 | |
Jul 13, 2022 | Stop Avoiding Difficult Conversations & Manage Your Well-Being | 120 Mins | $349.00 | |
Jun 08, 2021 | Pack of Two - Outlook Inbox management and One Note usage to improve Productivity | 120 Mins | $349.00 | |
Apr 01, 2021 | Vince Lombardi's Second Effort | Mins | $349.00 | |
Feb 16, 2021 | Customer Service & Sales Training Bundle | Mins | $599.00 |