Advanced Accounting Excel
Functions, Constraints, and Advanced Reports
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
1Advanced 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
2Add-ons
2 attachments
- Downloading Applications Used in the Lectures
- Downloading the Practical Application for the Integrated Accounting Course
Instructor
Mohamed Rami
5,298 students3 courses
This course is part of the following diplomas
