og-5-tips-for-reporting-1- - Copy

$100.00

Category:

Product Description

Date: 01, 02, 03 November 2017

Time: 6 pm to 9 pm

Location Jdeideh  Location map

 

This course is about:
Creating charts & stunning reports
Analyzing and modeling business data

Creating a data entry model practicing many formulas and shortcuts

 

Who will benefit: 
Reporting staff
Freelancers & entrepreneurs
Accountants of small business
Project managers

 

Data analysis is the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making.

 

Why use excel:
Simple and easy to use
Very customizable and flexible
Free of charge
Shareable
Modeling ability

 

List of skills you will master
* Create and name a professional database for data entry
* Create relationships between tables
* Create reports with functions (date functions, logical functions, lookup and nested functions)
* Generate reports using pivot tables & queries
* Create & format charts (spark-lines, pie chart, break even chart, line chart, bar char, bubble chart…)

* Create the final DASHBOARD for data visualization

* Modeling data with WHAT IF ANALYSIS AND SCENARIO MANAGER
* Printing rules & page formatting (headers & footers, add background & watermarks, print titles…)

 

Price: 100$

Payment at the door, but reservation is mandatory. Class capacity 12 students

Call 01893347 to secure your seat.

You should bring your own P.C. with excel 2013 downloaded.

Trainer profile on LinkedIn: https://www.linkedin.com/in/dialaalachkar/