Advanced Concepts in MS Excel (With Practical Examples)
Advanced Concepts in MS Excel (With Practical Examples), available at Free, has an average rating of 4.25, with 7 lectures, based on 100 reviews, and has 4496 subscribers.
You will learn about They will learn advanced concepts in MS Excel that will help them free up time for data analysis rather than data making. This course is ideal for individuals who are Professionals in Finance / Accounting / Business Analysis / Financial Analysis It is particularly useful for Professionals in Finance / Accounting / Business Analysis / Financial Analysis.
Enroll now: Advanced Concepts in MS Excel (With Practical Examples)
Summary
Title: Advanced Concepts in MS Excel (With Practical Examples)
Price: Free
Average Rating: 4.25
Number of Lectures: 7
Number of Published Lectures: 7
Number of Curriculum Items: 7
Number of Published Curriculum Objects: 7
Original Price: Free
Quality Status: approved
Status: Live
What You Will Learn
- They will learn advanced concepts in MS Excel that will help them free up time for data analysis rather than data making.
Who Should Attend
- Professionals in Finance / Accounting / Business Analysis / Financial Analysis
Target Audiences
- Professionals in Finance / Accounting / Business Analysis / Financial Analysis
It gives me immense pleasure to welcome you to the course!
Upon joining this course, you will learn about the following:
-
Benford’s Law for anomaly detection using Excel: Benford’s law is widely used to detect fraud in forensic science and audit. Learn how to do the same is Excel and detect fraud using number patterns
-
Convert numbers formatted as text to numbers :Save time by quickly converting text to numbers
-
Picture Lookup : Create dynamic leaderboards using picture lookup
-
SUMIF with wildcard : Create dynamic SUMIF statements using wildcard character (*,?)
-
Application of True in Vlookup :Dynamic Vlookup for use with ranges
-
Multi Variate Distinct Count in 1 minute :A glimpse of PowerPivot
-
Dependent Drop Down and Auto Named Range in MS Excel :Create cascading / dependent dropdowns in Excel!
This course will give you techniques to save a lot of time on cleanup of data. It will enable additional time being available to you for analysis and hence do the real value addition to business by providing valuable insights.
The videos are bite sized to enable quick view and with practical examples. You will find the downloadable files which were used to create the video. This way you can practice and strengthen the conceptual understanding.
I suggest implementing the concepts in your work life. This will solidify the concepts as well as ensure you never forget the same.
Wish you all the very best and keep excelling in excel! Make the most of it!
Course Curriculum
Lecture 1: Picture Lookup
Chapter 1: Advanced Concepts in MS Excel
Lecture 1: Benford's Law for anomaly detection using Excel!
Lecture 2: Convert numbers formatted as text to numbers for performing operations
Lecture 3: Application of True in VLOOKUP
Lecture 4: Multi Variate Distinct Count in 1 minute
Lecture 5: Dynamic SUMIF with Wildcard Character
Lecture 6: Dependent Drop Down and Auto Named Range in MS Excel
Instructors
-
Saurav Kumar Agrawal
Chartered Accountant, Company Secretary with 8.5 Years PQE
Rating Distribution
- 1 stars: 3 votes
- 2 stars: 1 votes
- 3 stars: 14 votes
- 4 stars: 36 votes
- 5 stars: 46 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024