24+ Best Advanced Excel Formulas And Functions

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

Requirements
You must have basic Microsoft Excel Knowledge.
You are able to write basic formulas and are familiar with the Excel spreadsheet environment.

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: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.

Overview
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.