Excel Skills to Make an Impression
Learn intermediate and advanced Excel skills, such as pivot tables, IF statements, and dynamic arrays, to advance your career.
Who is the course for?
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.
What will you achieve?
By the end of the course, you‘ll be able to…
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
