Fundamental Excel Skills for Accountants and Finance Staff

Learn the core fundamental Excel skills every Accountant or Finance Professional should have

4.55 (342 reviews)
Udemy
platform
English
language
Other Finance & Economic
category
6,054
students
2 hours
content
Oct 2020
last update
$49.99
regular price

What you will learn

You will learn the most essential Excel Skills for Accounting and Financial Professionals - Skills that will enhance you career

Logical tests and IF statements

VLOOKUP, INDEX & MATCH and XLOOKUP

Sum with conditions (SUMIF SUMIFS)

Tables for efficiency

Pivot tables

Dynamic Arrays

Description

Are you an Accountant or an aspiring Accountant?  Do you work in Finance?  Do you want to ensure you are equipped with the core fundamental Excel skills that every accountant or financial professional should have? well if so this course has been designed for you.

Excel is the tool of choice for most accountants, and having great Excel Skills can make a massive difference in your career prospects.  However many are lacking the core fundamental skills Excel required to use the tool efficiently. 

This course has been designed and developed by an accountant and focuses on the core Excel skills needed in the industry.  Some of these skills are at a basic level, however, some of them are at an advanced level. Each of the topics covered in this course is a core skill for the job and knowing some of the newer features of Excel 365 will put you ahead of the curve.

This course is a short course and a basic knowledge of Excel is required.  In this course, you will find workbooks to download so you can practice along and you will also find some activities to complete.


The topics covered in this course are

  1. Logical tests and IF statements.

  2. Lookup Formulas

  3. Summing with criteria

  4. Working with tables

  5. Pivot tables

  6. Dynamic arrays


Content

Introduction

Introduction
Logical tests
IF Statements
VLOOKUP
INDEX and MATCH
S is for Super Power (summing with conditions attached)
Efficiency with Tables
Explaining Pivot tables in 10 minuites
Introducing Dynamic Arrays
Pivot table alternative using Dynamic Arrays (UNIQUE SORT AND TRANSPOSE)
The FILTER function
XLOOKUP
Conclusion

Screenshots

Fundamental Excel Skills for Accountants and Finance Staff - Screenshot_01Fundamental Excel Skills for Accountants and Finance Staff - Screenshot_02Fundamental Excel Skills for Accountants and Finance Staff - Screenshot_03Fundamental Excel Skills for Accountants and Finance Staff - Screenshot_04

Reviews

Lucas
April 10, 2022
Good to finally get an explanation of the function and its arguments because Excel is very cryptic explaining the arguments. Besides the examples it is nice to know the situations that won't work and the ones that will work that get you down using Excel and not knowing what happened. It would have nice to see the functions working with accounting examples to get an idea how far the functions can go. Also, when explaining her voice sometimes gets too low and hard to hear more so with the accent, and the captions don't pickup what is said so you have to go back and try to figure out.
Pratham
August 8, 2021
This course upgraded my excel skills and gave great knowledge about it. Thankyou for giving us such course
Arjun
July 15, 2021
The course was absolutely useful and the way the narration was done by the faculty had been so understandable.
Mohit
June 20, 2021
The course was amazing in it's own. I learn new thing through this course and enjoy learning course. Thanking you.
Kanan
June 12, 2021
It was good but not for everyone some features are associated to office 365 which is not accessible for everyone
John
April 7, 2021
This is a good course, learning so much and she makes it so simple and clear of what to do and why too do it. recommend this course.
Rita
March 28, 2021
very good course, highly recommended. What should I do if my 2019 home edition does not support dynamic arrays and the topics after that? Thanks
Carmelina
February 21, 2021
Really easy to understand! I needed to refresh my knowledge since I'm starting a new job after my maternity leave. 100% recommended.

Charts

Price

Fundamental Excel Skills for Accountants and Finance Staff - Price chart

Rating

Fundamental Excel Skills for Accountants and Finance Staff - Ratings chart

Enrollment distribution

Fundamental Excel Skills for Accountants and Finance Staff - Distribution chart

Related Topics

3602542
udemy ID
10/29/2020
course created date
11/3/2020
course indexed date
Bot
course submited by