Microsoft Excel Advance Formulas and Functions Training Course - 1 day (Instructor-led lessons) for employers and staff
Title: Microsoft Excel Advance Formulas and Functions Training Course
Version: Designed for Microsoft Excel 365, 2019, 2016, 2013 & 2010
Who is this training for?
Our Microsoft Excel Advanced Formulas and Function course is suitable for those users who have a good working knowledge Excel spreadsheets and want to acquire further knowledge to consolidate their skills and have a greater understanding of utilising the more complex features and functions within Microsoft Excel.
Prerequisites Competent in using and creating IF, VLOOKUP and HLOOKUP functions.
Benefits
At the end of this lesson, you will acquire knowledge and you will have a greater understanding of utilising complex formulas and functions within Excel spreadsheet.
You will have the ability to use it's more sophisticated tools, which will allow you to complete your tasks and analyse your data more quickly.
It will also allow you to keep team members up to date on data, which can streamline your workflow process.
- Businesses Worldwide Use Excel
- Excel will be around for a long time.
What will you learn on this Excel Advance Formulas and Functions Training Course?
1. Building complex formulas
2. Advanced functions in formulas
3. Data & Text Functions
4. Introduction to Array formulas
5. Auditing formulas
Subject areas covered are listed in detailed in the the Curriculum tab above.
Course Level: Level 3
Teaching Method: Online tutoring using Cisco Webex or Zoom as our online tutoring platform.
Hours: 6 hours (Instructor-led lessons)
Classroom Size: 6 students
Teaching Hours
Monday to Friday - 9:30am to 5pm
Saturday and Sunday - 10:30am to 6pm
- We will tailor our courses to suit your availability.
- Further options on course schedule and availability are listed in the Select Option tab above.
- We will provide you with a structured lesson plan, course exercises, tutor notes and helpful tips.
Price: £180.00 per person (To provide a quality service, we've limited the classroom size to 6 candidates).
Ordering services from our website and how it works?
Once you have discussed your learning requirements and your availability with you teacher and you are ready to start learning, you will need to book your training session(s) here.
In the Select Option... tab above, you will find our course schedule list, choose your course schedule by clicking on it, enter the numbers of candidates enrolled for example 6 in the Hrs text box, you will then need to click on ADD TO BASKET button on the right-hand side.
You will now need to complete your billing detail(s), all the boxes with asterisk * will need to be completed or your booking form will not be processed and once you have completed your billing detail(s) you will need to tick the box to accept our terms and conditions else your checkout will not be processed. The other box is optional (mailing list, latest news and offers).
Once you have click CHECKOUT NOW! :
Our payment gateway "WORLDPAY" will then process your transaction and if successful you will receive an email of the confirmation of the transaction and invoice of service(s) purchased.
If you face any issues, call us on 020 8907 5522 and we will walk you through it.
We are available from 9am to 9pm (Monday to Friday).
Payment Methods:
- Credit or Debit Card
- Email PayByLink (Invoiced Payment)
If you have a question or a query, call us today. We're here to help.
Additional Information:
We only recruit educators who have a teaching qualification and a degree in their subject specialism and who have the necessary skills and experience in delivering lessons to learners on regular basis.
We have stringent recruitment policy in place for our teachers' vacancies. We check and verify each teacher's credentials and interview them personally in stages before they can join our teaching team. Our teachers are fully qualified, highly experienced and specialised in helping people of all ages to reach their full potential.
Customers may request details of our educators prior to engaging our services.
Services: Remote Learning, Online Classes, On-site Group Training.
Course Syllabus
Subject areas covered:
1. Building complex formulas
2. Advanced functions in formulas
3. Data & Text Functions
4. Introduction to Array formulas
5. Auditing formulas
Module: Building complex formulas
- Using nested IF statements
- Creating compound logical tests using AND, OR, NOT functions with IF statements
- Nesting LOOKUP functions
- Source table structure information using CHOOSE function
- Using MATCH function to locate data
- The INDEX function for retrieving information by location
- Using a nested formula containing INDEX, MATCH and MATCH (two-way lookup)
Module: Advanced functions in formulas
Using COUNTIFS,SUMIFS, & AVERAGEIFS for tabulating data based on single/multiple criteria
Statistical functions; MEDIAN, MODE, RANK, LARGE, SMALL, ROUND, MOD
AGGREGATE function to sum data in ranges with errors
Use a variety of Financial functions such PMT, FV, IRR
Module: Data & Text Functions
Smarter ways to calculate date & time; TODAY
NETWORKDAYS, WORKDAY, DATEDIF
Use TYPE to identify data type of existing cell contents
Text functions; UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LEN
TRIM excess space in cells
Module: Introduction to Array formulas
Using embedded Excel Array formulas
Create an Array formula
Module: Auditing formulas
Tracing formula precedents, dependents, and errors
Correcting errors in formulas
Combining IF with VLOOKUP to suppress error messages
Using the IS information function
Error checking functions; ISERR, ISERROR, IFERROR
Services: Online classes, On-site group training, Home tuition.
Course Delivery Location: Our online tutorial services are delivered using Cisco or Zoom as our virtual training platform and you can start learning in the comfort of your home without the need to travel.
If you have a question or a query, don't hesitate to get in touch. We're here to help.