Excel Formulas Essential training

Top 50 Ultimate Excel formulas + Security & Protection in excel

Ratings: 4.65 / 5.00




Description

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.

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

Who Should Attend!

  • Intermid in MS excel