Microsoft Excel Functions For Business 2021
Microsoft Excel Formulas and Functions
What you’ll learn
-
How to use Excel Functions to speed up activities
-
How to use Excel Formulas to automate calculations
-
How to use Pivot Tables to sort and filter big data
-
How to Impress your boss with the use of advanced SUMIFS,COUNTIFS,VLOOKUP,HLOOKUP,LOOKUP,INDEX and MATCH and lots more
-
How to create reports
-
How to validate excel data and trace formulars
-
How to nest the Right, Mid and Left functions to subset text strings in excel
-
How to automate excel functions and formulas
-
How to dynamically use cell locking
-
How to create awesome charts and graphs in Excel
-
How to create dashboards in Excel
-
How to secure your dashboard in Excel
-
How to clean dataset in excel
-
Life-time access to professional trainer from prolearnit
-
How to analyze and make optimal decisions among competing projects.
Requirements
-
This Course was created with Excel 2016 version, but it will work perfectly fine in Excel 2013, 2010 and 2007
-
You need a Computer
Who this course is for:
- People who want to learn about Microsoft excel
- people who want to learn how to create dashboards
- Data Science Enthusiast
