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
As usual, the webinar will be live on YouTube and the recording made available instantly after the webinar.
You can join in:
Time: 3:00pm (GMT +1)
Date: 28 March 2018
Venue: YouTube Live (https://www.youtube.com/watch?v=3KxWVqqV6ZA)
See you!
To be in loop of all our future webinars, then sign up to our Webinar Directory (http://eepurl.com/bKwoaT)
0 comments:
Post a Comment
You can be sure of a response, a very relevant one too!
Click on Subscribe by Email just down below the comment box so you'll be notified of my response.
Thanks!