Excel Skills to Make an Impression
Posted 3 years 7 months ago by The Excel Club
Discover Microsoft Excel skills to take your career to the next level
Microsoft Excel is a mainstay of professional roles around the world. From administration, to finance, to data analysis, and beyond, wherever there are numbers, you are likely to find Excel.
This course from The Excel Club is designed to help you take your Excel skills to the next level. Many users never get beyond the program’s most basic functionality, often feeling intimidated.
The course is designed to provide a gentle introduction to intermediate and advanced Excel skills. You will go from creating simple lists to carrying out complex Excel data analysis in no time.
The Excel skills you learn are sure to get you noticed, by both your current and prospective future employers.
Learn how to use Excel pivot tables, IF statements, and more
On this course, you will begin to explore some intermediate and advanced Excel functionality.
Some of the Excel skills covered include using Excel IF statements and comparative operators, simple and complex lookups, pivot tables for data analysis and exploration, calculations using Excel’s new dynamic arrays, and more.
With these advanced Excel skills, you will be able to approach complex tasks with confidence. You will be empowered to advance your career, either in your current role or in a new one.
This course would be suitable for anyone seeking to advance their career by learning more advanced Excel skills.
This includes those working or seeking to work in data analysis, advanced administration, or finance roles, among others.
In this course we use Excel 365. You can download a free 30 day trial directly from Microsoft.
This course would be suitable for anyone seeking to advance their career by learning more advanced Excel skills.
This includes those working or seeking to work in data analysis, advanced administration, or finance roles, among others.
- Solve logical problems using comparative operators and IF statement
- Demonstrate the use of simple to complex Lookups
- Calculate aggregations with conditions attached using SUMIF, SUMIFS and other IFS functions
- Explore and analyze data using Pivot tables
- Discuss and apply how Excel table features can make you more efficient
- Perform calculations using Excel's new Dynamic Arrays