Course description
Microsoft Excel® in Depth (In-Person)
This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner’s course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.
The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
A solid working knowledge of Excel and a desire to become more knowledgeable about its features and benefits
Who Should Attend
This course is for anyone with a basic working knowledge of Excel who wishes to enhance their understanding of the myriad features of Excel and to know when, how and where to use them.
Outcome / Qualification etc.
What you will Learn
You’ll learn how to:
- Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more
- Create meaningful charts
- Use pivot tables
- Use Conditional Formatting, Data Validation
- Take advantage of using Named ranges, do sorting, filtering, tables
Why choose IIL Europe
2,000,000+ people trained by IIL
50,000 annual online conference visitors
2,000+ companies have chosen to partner with IIL as their Learning Partner
Request info
IIL Global
At IIL, our fundamental values of Intelligence, Integrity, and Innovation guide our actions and achievements with each customer, partner, and colleague. Our deepest purpose is to foster the growth and success of individuals, teams, and organizations through enduring relationships and...