MICROSOFT EXCEL ESSENTIALS FOR BEGINNER TO INTERMEDIATE

Get ready to complete any Excel task with ease and confidence. In this course, you will learn all the common used Excel functions and you will learn how to create dynamic formulas using IF, VLOOKUP, INDEX, MATCH functions, and others. Here are the topics covered in the training: This Fundamentals will enable you to understand: Creating excel spreadsheets Managing and Analyzing Data Mastering popular excel functions (sum, sumif, countif, average, index, find, match…) How to analyze data using Data Validation, Sorting and Conditional Formatting Creating dynamic reports with Pivot tables