Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

FutureLearn

Excel Skills to Make an Impression

Excel Club via FutureLearn

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

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.

Syllabus

  • Oh Excel, IF Only!!!
    • Can you make this more efficient?
    • Meet Paula
    • Comparative Operators, Logical Tests and IF statements
    • Weekly wrap up
  • A Table or a Pivot Table?
    • What insights can you uncover?
    • Tables in Excel
    • Pivot Tables
    • Weekly wrap up
  • Is it a bird, is it a plane? No its the new Dynamic Arrays
    • Who is the fastest runner?
    • Introducing Dynamic Arrays
    • New Dynamic Array functions
    • Weekly wrap up
  • Don't forget to Look up
    • Don't forget to look up
    • Introducing Lookup Functions
    • INDEX and MATCH
    • XLOOKUP
    • Weekly wrap up

Taught by

Paula Guilfoyle

Reviews

Start your review of Excel Skills to Make an Impression

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.