By the Basic to Advanced Microsoft Excel and Data Analytics Course, We can learn more Excel that helps to increase our working capacity to save our time. Today, we cannot think of any data-relevant work without Excel. If we create a valuable position in accounting, finance, inventory and HRM field, we must be experts in Microsoft Excel, excel tools, functions, formulas and dashboards etc.

COURSE KEY OUTLINES:

• How to use Microsoft Excel and its basic functions
• How to create worksheets
• Everything about using and formatting cells
• How to use autofill
• The principles and use of formulas
• How to manipulate data through different functions
• How to use and master Excel’s most famous functions: AVERAGE, SUM, PRODUCT, COUNT, COUNTA, IF, COUNTIF
• Simple graphs and charts
• How to create a budgetary system
• All the new functions in Excel
• How to customize your charts
• How to use dashboards
• How to use Pivot Tables, Power Pivot, and Dynamic Array Formulas to analyze large datasets efficiently