Excel - Advanced Level

To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel . Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts

The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to automate work with spreadsheets.

Excel Advanced

• Data Entry Restriction Functions - Data Validation
• Advanced Functions such as SUMIF, AVERAGEIF, date related functions
• Using Formulas such as VLOOKUP, HLOOKUP and XLOOKUP
• Power Query (import, transform, shape and load data in excel )
• Power Pivot(import, data model, relations between tables )
• Advanced PivotTables
• Advanced Pivot Charts
• Applying and using Slicers
• Using Power Map visialization
• Building a BI Dashboard