Learn the power of Excel. Turn stress into efficiency by using Excel formulae to simplify tasks. Expand your knowledge and gain new skills for using more of Excel’s wide range of functions.
Learn the power of Excel. Turn stress into efficiency by using Excel formulae to simplify tasks. Expand your knowledge and gain new skills for using more of Excel’s wide range of functions.
Learn how to combine functions in formulae and transform your worksheet functionality at work. For example, learn how to use time and date functions to calculate forward dates, work days in between dates, and much more.
Skills Taught:
Understanding what functions and formulae are
How to build the parts of functions and formulae
How to enter formulae into worksheet cells and across worksheets
Checking and fixing errors in formulae
Finding the functions you need in your formula
Using different types of functions in formulae: count/sum, time/date, financial, text, lookup, logical, information, and olatile functions
Using array formulae
Cleaning imported data
We have been delivering training programmes to leading Nelson businesses since 2010. Your business and your people will grow and succeed with training.
This course is suitable for users of Microsoft Visio Plan 2, 2021, 2019, 2016, 2013 Standard or Professional editions. If you're attending at a QA location, the course will be delivered on Microsoft Visio 2016 Professional.
The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.
All of our word processing courses can be customised and targeted without needing to sit the full course or NZQA Unit Standard.
All those tricky extras – not so tricky when someone shows you how. Our tutors can provide step-by-step Training in Microsoft PowerPoint.
This course is intended for new users of Microsoft Office Excel for Windows who are already familiar with a personal computer, Microsoft Excel and a mouse.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy