• The Excel Club logo

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.

10,017 enrolled on this course

Excel Skills to Make an Impression

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.

Skip to 0 minutes and 6 seconds Are you looking to improve your Excel skills? Do you want to learn the core fundamental skills that are practical, that you can use every day that will both impressed and put you ahead of the curve. If so, then this course is for you. Welcome to Core Excel Skills to make an impression. My name is Paula and I am a CPA. I’m also a Microsoft Excel MVP and I’ve been training in Excel for over 10 years. No matter what your job is these days if it’s Office-based or if it has any admin work, then you will be working with Excel.

Skip to 0 minutes and 41 seconds Yet many seem to lack the core of the fundamental skills required to get the job done efficiently, and these skills are in high demand by employers. This course is aimed at equipping you with the fundamental Excel skills used everyday, We will explore Logical tests and if statements we’re going to delve into look up options such as VLOOKUP, INDEX and MATCH XLOOKUP. We will learn to sum data based on criteria and carry out other conditional calculations. You will learn how and why you should work with tables. You’ll be introduced to analyzing data with Pivot Tables, and you be introduced to the New Dynamic Arrays. This course is a Hands-On course with a Community Focus.

Skip to 1 minute and 26 seconds There are workbooks to download so you can practice along and exercises for you to complete. There’s some of the content in this course is of a basic level. Yet some of us is considered Advanced. Either way, everything you learn in this course is a Core skill, many of which will impress. It is important to note. You need a basic level of excel before you can start this course. It’s also advisable that you get a copy of excel 365 to work with you can sign up for a 30-day free trial with Microsoft, If you don’t yet have this version of excel, so if you think this course is for you. Why don’t you enroll now and let’s get started.

Skip to 2 minutes and 16 seconds [END]

When would you like to start?

Start straight away and learn at your own pace. If the course hasn’t started yet you’ll see the future date listed below.

  • Available now

Learning on this course

You can take this self-guided course and learn at your own pace. On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

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

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 software or tools do you need?

In this course we use Excel 365. You can download a free 30 day trial directly from Microsoft.

Who will you learn with?

Paula Guilfoyle is a CPA accountant with a passion for Excel. Teaching Excel for over ten years now, Paula also blogs and makes Youtube videos on all things Excel and Power BI.

Who developed the course?

The Excel Club

The Excel Club is a global leader in Excel and Power BI training. With over 100K students from across 186 different countries, The Excel Club has grown from strength to strength.

The force behind The Excel Club is by Paula Guilfoyle. Paula is a Certified Public Accountant and Microsoft Excel MVP who has worked across a broad range of industries as an Accountant, Internal Auditor and Financial Controller.

Recommended

Ways to learn

Upgrade this course

Unlimited

Choose the best way to learn for you!

$59

$15.83/month

Billed at $189.99 for a year

Learners who upgrade are 5x as likely to complete the course!*Endless possibilities!
Access to this courseticktick
Access to ALL eligible short courses with additional benefits, for a yearcrosstick
Discuss your learning in commentsticktick
Certificate when you're eligiblePrinted and digitalDigital only
Join and Upgrade

Ways to learn

Upgrade this course for extra benefits, or buy Unlimited to access this course and hundreds of other short courses for a year. Or, join this course with free basic access, limited to 6 weeks (excludes certificates).

Upgrade this course

$59

Learners who upgrade are 5x as likely to complete the course!*

  • Access to this course
  • Discuss your learning in comments
  • Printed and digital certificate when you’re eligible

Unlimited

$15.83/month

Billed at $189.99 for a year

Endless possibilities!

  • Access to this course
  • Access to ALL eligible short courses with additional benefits, for a year
  • Discuss your learning in comments
  • Digital certificate when you're eligible

Basic access

Free

Try before you buy

  • Limited access to course content for 6 weeks

Find out more about certificates, Upgrades or Unlimited.

Sale price available until 6 December 2021 at 23:59 (UTC). T&Cs apply.

Join this course for free with basic access. Access to this course only limited to 6 weeks. Excludes certificates.

*FutureLearn considers a short course complete when a learner has engaged with 90% of the content. For enrolments to short courses with the possibility of Upgrade in the year of 2020, enrolments with an Upgrade are completed 5.31 times as often as enrolments with basic access

*FutureLearn considers a short course complete when a learner has engaged with 90% of the content. For enrolments to short courses with the possibility of Upgrade in the year of 2020, enrolments with an Upgrade are completed 5.31 times as often as enrolments with basic access

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps, but you can complete them as quickly or slowly as you like
  • Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
  • Stay motivated by using the Progress page to keep track of your step completion and assessment scores

Join a global classroom

  • Experience the power of social learning, and get inspired by an international network of learners
  • Share ideas with your peers and course educators on every step of the course
  • Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others

Map your progress

  • As you work through the course, use notifications and the Progress page to guide your learning
  • Whenever you’re ready, mark each step as complete, you’re in control
  • Complete 90% of course steps and all of the assessments to earn your certificate

Want to know more about learning on FutureLearn? Using FutureLearn

Learner reviews

Learner reviews cannot be loaded due to your cookie settings. Please and refresh the page to view this content.

Get a taste of this course

Find out what this course is like by previewing some of the course steps before you join:

Do you know someone who'd love this course? Tell them about it...

You can use the hashtag #excelskills to talk about this course on social media.