Location

Community Services & Continuing Education - Cairo

Objectives

• Use business solutions provided by Microsoft Excel

Outcomes

Being able to take advantage of the "Microsoft Excel" program to analyze the problems facing businesses and help provide solutions to them. This enables the transformation of data into information that helps in making the right decision that gives the business a competitive value.

Course Contents

Practical and practical examplesRelative, absolute and mixed references to cellsMixed references for cellsAnalytics using pivot tablesShow the value as a percentage in the pivot excel tables- Pivot tables for calculations of the annual percentage change1 -Tableau Desktop:- Connect to your Excel data using Drag-and-Drop- Basic Bar, Column, Line and Pie Charts- Color Coding and Text Labels- One Click Calculations: Running Total, Moving Average and More- Building your first dashboard in seconds- Basic Formatting and Print to PDF/Image2 -Tableau Desktop: Beginner- Simple Charts: Pie, Bars, Area and Lines- How to Filter your data with a few clicks- Basic Arithmetic: Learn to add number fields together