Excel Formulas Essential training
Top 50 Ultimate Excel formulas + Security & Protection in excel
What you will learn
Text Formulas
Lookup & Reference Formulas
Logical Formulas
Date & Time Formulas
Top 7 Formulas recently used in Excel
Max-Min-Avg -Forecasting-Database Formulas
Security & Protection in excel
Why take this course?
The myriad formulas and functions in Excel are, in large part, what makes it such a uniquely powerful program. But for many users, figuring out how to apply these formulas and functions to solve everyday problems can seem overwhelming. In this course, staff instructor Mohamed Rashad demystifies these powerful features, sharing bite-sized tips designed to help you work faster and more efficiently in Excel.Rashad begins by covering the fundamental concepts you need to get started with functions and formulas, such as how to programmatically reference cells located in other worksheets and combine cell data with other characters. She then digs into a variety of useful Excel functions. Learn how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT, use INDEX and MATCH to retrieve a value, and much more.
Rashad begins by covering the fundamental concepts you need to get started with functions and formulas, such as how to programmatically reference cells located in other worksheets and combine cell data with other characters. She then digs into a variety of useful Excel functions. Learn how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT, use INDEX and MATCH to retrieve a value, and much more.