Advanced Accounting Excel

Functions, Constraints, and Advanced Reports

4.4(87)4h 3m24 lectures2 sections

What you'll learn

Understand advanced accounting functions
Learn to create pivot tables
Use decision analysis tools effectively
Build a comprehensive accounting system
Apply advanced budgeting techniques
Manage data efficiently

About this course

This advanced course aims to teach you how to use Excel for advanced accounting. You will learn to apply accounting functions and formulas, create pivot tables, analyze data, and use tools like Solver and Goal Seek to enhance financial decisions. By the end of the course, you will have the practical skills to develop a comprehensive accounting system using Excel.

Expected outcomes

Ability to apply advanced accounting tools in Excel.
Create accurate and effective accounting tables and reports.
Analyze financial data to make informed decisions.
Design a comprehensive accounting system tailored to business needs.

Course content

Advanced Accounting Excel

22 lectures

Introduction and Course Topics5:25
Advanced Sumif/Sumifs Functions13:12
Calculating Average with One or More Conditions Averageif/Averageifs6:29
Advanced Countif/Countifs Functions6:20
Logical IF Function (Simple and Compound)10:42
Vlookup/Hlookup Functions11:04
Aggregate Function That Can Bypass Errors7:48
INDEX/MATCH Functions and How to Combine Them11:07
Types of Cell References12:16
Pivot Table & Slicer15:12
Database Functions11:33
Macros6:42
Using the Scenario Analysis Tool for Forecasting and Deriving Potential Outcomes8:46
Goal Seek6:05
Printing8:36
Advanced Conditional Formatting Using Formulas8:49
Advanced Filter9:03
Custom List7:28
Solver7:04
Breakeven Point10:48
Integrated Accounting System from A to Z (Part One)29:51
Integrated Accounting System from A to Z (Part Two)28:59

Add-ons

2 attachments

Downloading Applications Used in the Lectures
Downloading the Practical Application for the Integrated Accounting Course

Instructor

Mohamed Rami

Lecturer and trainer in accounting subjects in Arabic and English, author of books in this field.

1,815 students3 courses

This course is part of the diploma

4.6(73)|7
Diploma in Accounting and Financial Analysis
7 courses
$59.99
Build your future now

Related courses

5.0(65)|574|2h 18m
Principles of Economics and Political Economy
Economics and Concepts Related to Entrepreneurship
Dr. Tamer Al-Batrawi
$19.99
Start your journey now
4.8(84)|657|2h 22m
Business Administration
New Project Ideas and Management Skills
Dr. Tamer Al-Batrawi
$19.99
Start your journey now
4.6(71)|623|1h 57m
Risk Management
Assessing and Managing Risks Effectively
Eng. Ayman Shaaban
$19.99
Start your journey now
4.4(66)|582|3h 11m
Safety Management
Global Measurement Methods and Risk Control Tools
Eng. Ayman Shaaban
$19.99
Start your journey now