Essential Excel Formulas and Tools

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

Who is the target audience?

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

Course Completion Certificate

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

Curriculum:

• Introduction
• Module 1 - Using Large Worksheets
• Module 3 - Linking
• Module 4 - Paste Special
• Module 5 - Range Names and VLookup/HLookup
• Module 6 - IFs and Logic
• Module 7 - Conditional Formatting
• Module 8 - Date and Text Functions

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.