Level 2 – 2 Days
Simple spreadsheets are fine for basic applications but in a real-world business environment things are not usually that simple.
This course will take you through several techniques and situations for handling more realistic situations and will give you the understanding and the tools to create more complex spreadsheets on your own.
As you can imagine, the lifeblood of Excel is the world of Functions. We will delve into the world of Functions and look at some of the go-to functions of most spreadsheets. We will focus on how to understand Functions and how to choose and use them in various situations. This course is a must for anyone who uses Excel beyond just viewing data on spreadsheets.
What We Will Cover:
FUNCTIONS
- What really is a function?
- The syntax of functions
- Different kind of helps available in within Excel
- Nested and Compounded Functions
- How to read and understand functions
BASIC CONCEPT
- Review of Cell References
- The two types of Cell Reference: Relative and Absolute
- Creation of Named Ranges
BASIC FUNCTIONS
- Review of basic functions
- Review of AutoSum
POWER FUNCTIONS
- Adding conditions to the basic functions
DATE FUNCTIONS
- What is a date for Excel?
- Manipulation of dates
- Date calculations for different systems
- Tracking important deadlines with dates
TEXT FUNCTIONS
- How to use text in Excel?
- Extraction of sections of text
- Formatting text in different way using functions
- Text To Columns
LOGICAL FUNCTIONS
- The logic of IF
- Creation of efficient tests
- Logical operators
- Implementation of logical structures
LOOKUP FUNCTIONS
- Extracting information using VLOOKUP
- How to use VLOOKUP with numbers and text
- Approximate vs Exact match
ERROR HANDLING FUNCTIONS
- Understanding error codes
- Hiding error codes using functions
HELPING THE END USER
- Data Validations
- Protecting the worksheet