When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Advanced Excel Formulas and Pivot Tables - 2023
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
This Course Includes
skillshare
0 (0 reviews )
3 hours 16 minutes 
english
Online - Self Paced
course
SkillShare
About Advanced Excel Formulas and Pivot Tables - 2023
Course Introduction
Introduction to Excel Environment
Entering Data into Excel for the First Time English
Sorting and Filtering in Excel
Basic Excel Formula and Sum Function
Average and Count and CountA
Max and Min Formula
IF Formula
Left Right and Mid Formulas
Upper Lower and Proper
Concat and TextJoin
Sum IF
SumIf with Wild Cards
Average IF and CountIF Formulas
IFS and SUMIFS
SumIFS with Wildcards
AverageIFS and Average IFS with Wild Cards
MaxIFS with Wild Cards and Operators
MinIFS
Pivot Table Section Introduction
Understanding Pivot Tables
How Pivot Tables work and our First Pivot Table
Changing Values in Pivot Tables
Pivot Tables Changing Calculations to Max and Min
Using Rows and Columns for Optimal Analytical View
Course Conclusion
What You Will Learn?
- This course is all about Learning to use Microsoft Excel Formulas and the basics of Pivot tables at some of the best/complex/business situations. One can Learn the below Items through this course..