Professional Ms Excel Master

From Basic To Advanced

By: Mrs. Dalia Murad

New

Duration: 20h / 8 lessons

level

Level: General

Course Language: Arabic

30-Days Money Back Guarantee

Get access to all lessons only for

1800 EGP 3000 EGP

By the end of this course, you will be able to:

Understanding the basics layout and terminology used MS Excel.

Creating formatting spreadsheets easily in excel.

Entering data and formulas easily in cells.

Mastering the techniques of designing interactive Dashboard and Reporting using Power BI and Excel.

Understanding and using the functions smoothly.

Use Outlines, Range Names, Database, and data Validations.

Use auto filter & Advanced Sort and Filters.

Use basics and advanced Functions.

Using visualizations, illustrations and hyper-links

Create and modify Charts and Visuals.

Create and revise Reports with Pivot table professionally.

Create and design Dynamic Dashboards with Pivot Charts and Slicers.

Prerequisites:

  • A laptop running Windows 10 or higher.
  • Basic familiarity with computers. [Optional but recommended].
  • The required version of Office programs is version 2016 or higher, and the highest version is Office 365. [You can download the latest version of Office with the help of the trainer].

Syllabus:

  • Module 1: Basics Tools and Functions.
  • Module 2:- Advanced calculations and formatting tools on data.
  • Module 3:- Analysis Tools.
  • Module 4:- Reporting Tools.

Support