Thursday, May 10, 2018

March 2018 Webinar: My Most Important Excel Formulas; Would Recommend You Master Them



As a full-time Microsoft Excel consultant, of all the over 450 formulas in Excel there are just a handful I focus on in my training classes because they provide the most value in practical day-to-day use of Excel. If you examine any reports or templates (even the most complex one you've ever come across), you will see that the these formulas are the ones powering those reports.

In this webinar, I will be taking you through those formulas in my usual very practical way and provide you with the practice file for your own use later on.

The formulas are:
1. VLOOKUP
2. HLOOKUP
3. LOOKUP
4. INDEX & MATCH
5. IF
6. SUM
7. COUNTIF
8. SUMIF
9. SUMPRODUCT
10. ROUND
11. CEILING
12. CONCATENATE
13. LEFT
14. RIGHT
15. MID
16. TODAY
17. DAY
18. MONTH
19. YEAR
20. UPPER
21. LOWER
22. PROPER
23. RAND
24. RANDBETWEEN
25. INDIRECT

The webinar was live on YouTube and the recording is made available at https://www.youtube.com/watch?v=3KxWVqqV6ZA

Time: 3:00pm (GMT +1)
Date: 28 March 2018
VenueYouTube Live (https://www.youtube.com/watch?v=3KxWVqqV6ZA)


To be in loop of all our future webinars, then sign up to our Webinar Directory (http://eepurl.com/bKwoaT)

No comments:

Post a Comment