• 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.

18,363 enrolled on this course

hand pointing to cells on a spreadsheet

Excel Skills to Make an Impression

18,363 enrolled on this course

  • 4 weeks

  • 2 hours per week

  • Accreditation available

  • Digital certificate when eligible

  • Introductory level

Find out more about how to join this course

The CPD Certification Service

This course has been certified by the CPD Certification Service as conforming to continuing professional development principles. Find out more.

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]

Who is this accredited by?

The CPD Certification Service
The CPD Certification Service:

The CPD Certification Service was established in 1996 and is the leading independent CPD accreditation institution operating across industry sectors to complement the CPD policies of professional and academic bodies.

When would you like to start?

Start straight away and join a global classroom of learners. If the course hasn’t started yet you’ll see the future date listed below.

  • Available now

Learning on this course

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.

Ways to learn

Buy this course

Subscribe & save

Limited access

Choose the best way to learn for you!

$79/one-off payment

$39.99

For your first month. Automatically renews

Free

Fulfill your current learning needDevelop skills to further your careerSample the course materials
Access to this courseticktick

Access expires 2 Jan 2025

Access to 1,000+ coursescrosstickcross
Learn at your own paceticktickcross
Discuss your learning in commentstickticktick
Certificate when you're eligiblePrinted and digitalDigital onlycross
Continue & Upgrade

Cancel for free anytime

Ways to learn

Choose the best way to learn for you!

Subscribe & save

$39.99

For your first month. Automatically renews

Develop skills to further your career

  • Access to this course
  • Access to 1,000+ courses
  • Learn at your own pace
  • Discuss your learning in comments
  • Digital certificate when you're eligible

Cancel for free anytime

Buy this course

$79/one-off payment

Fulfill your current learning need

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

Limited access

Free

Sample the course materials

  • Access expires 2 Jan 2025

Find out more about certificates, Unlimited or buying a course (Upgrades)

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

Find out more about certificates, Unlimited or buying a course (Upgrades)

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

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps to help you keep track of your learning
  • 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.