Excel for Accountants: Mapping Tables
Automate reporting tasks with a mapping table
4.37 (8444 reviews)
113 133
students
31 mins
content
Sep 2017
last update
FREE
regular price
What you will learn
Store data in tables so that new rows are automatically included in related formulas
Perform conditional summing with the SUMIFS function
Create an intermediate mapping table so that Excel has the information needed to translate labels and aggregate data rows
Course Gallery
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
Comidoc Review
Our Verdict
Excel for Accountants: Mapping Tables offers practical accounting skills, integrating conditional summing techniques alongside mapping tables to automate repetitive tasks. With flexible, bite-sized video lessons and applicability beyond accounting roles, the course caters well to busy professionals. However, some users may find prerequisite knowledge necessary, requiring them to search for additional resources or seek prior Excel and accounting experience. Additionally, potential improvements in exercise templates and file downloads will contribute to a smoother learning journey.
What We Liked
- Covers practical accounting concepts like conditional summing with SUMIFS function
- Teaches mapping tables technique, a timesaver for accountants' daily tasks
- Segmented and short videos allow flexible learning integration into busy schedules
- Imparts knowledge applicable to various departments such as supply chain
Potential Drawbacks
- Some students may benefit from prerequisite Excel and accounting proficiency
- A few reviewers mention the course could slow down for better understanding
- Lack of practice exercises and certification might leave some learners wanting more
- Issues with downloading or viewing exercise files requiring workarounds
Related Topics
331738
udemy ID
30/10/2014
course created date
02/11/2019
course indexed date
Bot
course submited by