Study Learn Grow
Essential Excel Formulas and Tools

Essential Excel Formulas and Tools


This course is ideal for those who already use Excel at Introduction level and want to build on the knowledge you know.

Overview

About this Course
This course is ideal for those who already use Excel at Introduction level and want to build on the knowledge you know. You will be introduced to a whole range of useful tools, shortcuts and functions. From managing large amounts of data to advanced functions such as VLookup, HLookup and IF Statements. Whatever you use Excel for in your work life, this course will give you the essential skills to take your Excel knowledge to the level expected in the working environment.

Basic knowledge
You should have a basic knowledge of Microsoft Excel. From creating SUM formulas and using AutoSum, to data entry
Microsoft Excel installed (course is compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016)

Course Information

You should have a basic knowledge of Microsoft Excel. From creating SUM formulas and using AutoSum, to data entry
Microsoft Excel installed (course is compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016)

What you will learn
Create Advanced Formulas such as VLookup/HLookup
Apply Conditional Formatting to change cell colour based on High/Low Value
Use IF Statements to perform tests based on a condition
Manipulate Large Worksheets to make viewing large amounts of data easier
Link data between different spreadsheets
Use Date and Text formulas and functions for formatting and calculating dates and text
Use Paste Special to adjust how and what you paste. Including how to compare 2 sets of data together

Anyone who wants to enhance their knowledge of Excel
Users who want to learn more advanced formulas, tools and shortcuts

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs