• The Excel Club logo
New

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.

2,304 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

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.

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

Join this course

Start this couse for free, upgrade for extra benefits, or buy Unlimited to access this course and hundreds of other short courses for a year.

Free

$0

Join free and you will get:

  • Access to this course for 6 weeks

Upgrade

$64

Upgrade this course and you will get:

  • Access to this course for as long as it’s on FutureLearn
  • A print and digital Certificate of Achievement once you’re eligible

Unlimited

$279.99 for one year

Buy Unlimited and you will get:

  • Access to this course, and hundreds of other FutureLearn short courses and tests for a year
  • A printable digital Certificate of Achievement on all short courses once you’re eligible
  • The freedom to keep access to any course you've achieved a digital Certificate of Achievement on, for as long as the course exists on FutureLearn
  • The flexibility to complete your choice of short courses in your own time within the year

Find out more about upgrades or Unlimited.

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.