Advance Microsoft Excel Formulas And Functions
Master Class of Microsoft Excel - Advanced Excel Formulas And Functions
Excel Formulas and Functions,Excel,Excel Analytics
Lectures -76
Resources -2
Quizzes -12
Duration -3.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
It's time to learn Advanced Excel Formulas and Functions.
Whether you're starting from scratch or aspiring to become an absolute Excel power user, you've come to the right place.
This course will give you understanding of the Advanced Excel Formulas and Functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.
This Microsoft Excel - Advanced Excel Formulas & Functions Course will tell you simply what each formula does, how they can be applied in a number of ways.
I have divided this course in different sections including:
Working With Excel List
List Functions
Data Validation
Working With Large Set Of Excel Data
Excel Conditional Functions
Excel Lookup Functions
Excel Text Based Functions
Auditing An Excel Worksheet
Protecting Excel Worksheet and Workbook
Working with Excel What If? Tools And So On.
As the founder of RK Academy. My teaching style is conversational, authentic, easy and to the point, and I will always communicate complex/ difficult concepts in a framework that is clear and easy to understand.
If you're looking for the course where you can learn Microsoft Excel - Advanced Excel Formulas & Functions that you need to know to become an absolute Excel Hero, you've found it.
See you in the course!
Devyani & Nikk ( Founder, RK Academy)
* NOTE: Full course includes downloadable resources, course quizzes and lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021 & Office 365.
Goals
Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch.
Automate, streamline, and completely revolutionize your workflow with Excel Advance formula and function like Name Ranges, Vlookup, Hlookup and many more.
Learn How we can work with large set of Excel data.
Learn How we can Audit our Excel Worksheet.
Learn How we can protect our Worksheet and Workbook through Password.
Learn How we can Master in "What If?" Tools.
Prerequisites
You must have basic Microsoft Excel knowledge.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
2 Lectures
- Course Introduction 01:14 01:14
- Course Exercise File 00:26 00:26
Working With An Excel List
10 Lectures
Excel List Function
6 Lectures
Excel Data Validation
4 Lectures
Working With Large Sets Of Excel Data
6 Lectures
Working With Excel Conditional Functions
9 Lectures
Working With Excel Lookup Functions
6 Lectures
Working With Excel Text Based Functions
4 Lectures
Auditing An Excel Worksheet
5 Lectures
Protecting Excel Worksheets And Workbooks
4 Lectures
Mastering Excel "What If?" Tools
4 Lectures
Excel PivotTables
11 Lectures
Excel PowerPivot
5 Lectures
Instructor Details
Devyani Lakhyani
Hi, Myself Devyani, along with my Co- Founder Nikk.
Our online institution name is RK Academy.
We have over ten years of experience in teaching various subjects.
Now We are continuing our teaching passion in Tutorialspoint.
Our talent is taking complex subjects and making them simple to learn.
We understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why we make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.
Are you ready to take your skills to the next level? It all starts with knowledge, and our courses make that part easy.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now