- Online Courses
- >
- Spreadsheets Level 2 Formulas - Online Course
Spreadsheets Level 2 Formulas - Online Course
Suitable for Office 2010, 2016, 2019 and 365.
This course is suitable for people who are already confident in producing spreadsheets using basic editing and formulas and would like to produce a more professional and high-quality document.
Using formulas in your Excel worksheets makes it easy to calculate results from the data stored in the worksheet. When data changes, the formulas calculate updated results with no extra effort on your part. Imagine if your formula is able to do more complex calculations and present you with further information about your data saving you time and helping you to work more efficiently!
Our online courses are accessed through our member's area on our website and provide a video tutorial for each unit, downloadable worksheets, a final online assessment and access to tutor support online. On completion of your assessment, you will be awarded an Academy digital certificate.
Course Content
COUNT, COUNTA, COUNTBLANK
IF and Absolute
COUNTIF
AND/OR function
Conditional Formating
ROUND function
SUMIF function
Pulling it together
Assessment
Once purchased, you will receive an invite link to your course within two working days.