MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.33 GB | Duration: 2h 9m
Master 24+ Advanced Excel Formulas and Functions like Conditional Functions and etc to increase your productivity.
What you’ll learn
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 Formulas and Functions Like Name Ranges, Vlookup, Hlookup and many more.
Write advanced conditional, text, date and lookup functions.
Master unique tips & techniques that you won’t find in ANY other course, guaranteed.
Get LIFETIME access to project files, quizzes, and 1-on-1 expert support
You must have basic Microsoft Excel Knowledge.
You are able to write basic formulas and are familiar with the Excel spreadsheet environment.
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:Conditional FunctionsLookup FunctionsText-Based FunctionsFormula AuditingProtecting Excel Worksheet and WorkbookWhat-if Analysis ToolsWorking With Color CellsAs the founder of Nikkyani 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!Nikk ( Founder, Nikkyani 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.
Section 1: Introduction
Lecture 1 Introduction
Section 2: Working With Large Set Of Excel Data
Lecture 2 Freeze Panes Tool In Excel
Lecture 3 Grouping (Outline) Data In Excel
Lecture 4 Linking Worksheet In Excel
Lecture 5 Linking Worksheet With Consolidate Tool In Excel
Lecture 6 Print Options For Large Set Of Data In Excel
Section 3: Working With Excel Conditional Function
Lecture 7 Working With Name Ranges In Excel
Lecture 8 Editing Name Ranges In Excel
Lecture 9 Using If Function In Excel
Lecture 10 Nesting or Multiple Functions In Excel
Lecture 11 Using And Function With If Function Together
Lecture 12 Using CountIf Function In Excel
Lecture 13 Using SumIf Function In Excel
Lecture 14 Using IfError Function In Excel
Section 4: Working With Lookup Function In Excel
Lecture 15 Using Vlookup Function in Excel
Lecture 16 Using Hlookup Function in Excel
Lecture 17 Using Index Function In Excel
Lecture 18 Using Match Function In Excel
Lecture 19 Using Hlookup+Match Function In Excel
Section 5: Working With Excel Text Based Functions
Lecture 20 Using left, Right & Mid Function In Excel
Lecture 21 Using Len Function In Excel
Lecture 22 Using Concatenate Function In Excel
Section 6: Working With Formula Auditing In Excel Worksheet
Lecture 23 Using Trace Precedent In Excel
Lecture 24 Using Trace Dependents Function In Excel
Lecture 25 Using Show Formula Function In Excel
Lecture 26 Using Watch Window Function In Excel
Section 7: Protecting Excel Worksheets And Workbooks
Lecture 27 Protecting Complete Or Specific Cell In A Worksheet
Lecture 28 Protecting The Structure Of A Workbook In Excel
Lecture 29 Protecting Workbook With Password In Excel
Section 8: Using “What-If Analysis” Tools In Excel
Lecture 30 Using Goal Seek Tool In Excel
Lecture 31 Using Data Table Tool In Excel
Lecture 32 Using Scenario Manager Tool In Excel
Section 9: Working With Color Cells
Lecture 33 How to Count Color Cells
Excel users looking to build powerful analytical thinking and business intelligence skills.,Those who want to expand their skill set and want to take their career in excel to a new level.,Those who want to make there job in excel more dynamic.,Excel users who want to learn how to write advanced formulas from scratch.