Description About the course
The goal of this live interactive practical webinar is to consolidate existing knowledge of Microsoft Excel and to add to it with technical and useful functions and procedures.
Course Objectives
Refresh and consolidate existing knowledge Understand use of IFs, Nested IFs and SUMIF Apply Conditional Formatting What you will learn Course Content
Existing Knowledge Refresh Calculations and Percentages Advanced Absolute Referencing Conditional Formatting / Sparklines The IF Function Using Nested IFs The SUMIF function for Analysis and Reconciliation VLOOKUP in Detail for Range and Non-Range Lookups External Cell Referencing and Linked Documents Paste Special Questions, Answers and Requests Schedule
Session One – 45 min Practical Exercises and break – 15 min Session Two – 45 min Practical Exercises and break – 15 min Session Three – 45 min Practical Exercises and break – 15 min Q&A – 30 min Further information Provider: London Market Training Duration: 3.5 Hours
Contact Information London Market Training
Southcourt Farmhouse
Glyn was very engaging and explained all the relevant tools in detail. He made the content feel less daunting and answered any queries i had straight away. Would definitely recommend.
Steph S 21 Oct 24
Response : Thank you for your feedback Steph. We are glad you enjoyed the session.
Excellent course. It was presented in a way that was very easy to follow. I thought the format of the instructor performing tasks and explaining them and then giving the attendees a chance to replicate the tasks and ask questions was very effective. I also enjoyed how it progressed from basic tasks that were used as a foundation to build upon with more complex skills later on. I really took away a lot that I will be able to use in the future.
Calvin G 18 Oct 24
Response : We are glad you enjoyed the session and the practical aspect of the webinar. Thank you for your feedback Clavin.
Pivot Tables was my main learning objective from the session, and this was suitably covered.
Gregory H 10 May 24
Response : Thank you for your feedback Gregory.
I felt the course was good but i wanted to learn more around short cuts, things that would make my job faster, the trainer was good and engaging, the material for what i do felt basic, personally think it needs a review as this could be added to a beginner course
Sandy P 14 Mar 24
Response : Thank you for your feedback Sandy.
Glyn was great and explained everything very well, thank you Glyn!
Rebecca K 13 Apr 23
Response : Thank you for your feedback. We are glad you enjoyed the webinar.
Read more reviews >
01525 850086
Email