Outlines:

Lesson 1: Getting Started with Microsoft Office Excel 2016

 Navigate the Excel User Interface

 Use Excel Commands
 Create and Save a Basic Workbook
Course Name  Enter Cell Data
 Use Excel Help
Introduction to MS Excel
Lesson 2: Modifying a Worksheet
Duration
 Insert, Delete, and Adjust Cells, Columns, and Rows
8 HRs  Search for and Replace Data
 Use Proofing and Research Tools

Lesson 3: Formatting a Worksheet

 Apply Text Formats

 Apply Number Formats
 Align Cell Contents
 Apply Styles and Themes
 Create and Use Templates

Lesson 4: Printing Workbooks

 Preview and Print a Workbook

 Set Up the Page Layout
 Configure Headers and Footers

Lesson 5: Managing Workbooks

 Manage Worksheets
 Manage Workbook and Worksheet Views
 Manage Workbook Properties

Integrated Training Solutions of Egypt and Programming | INTRAST

431 El-Horrya Rd., Roshdy, Alexandria, Egypt. Phone: +20 3 54 26 479 / 54 30 820
1 Syria ST., El Deeb Mall 10th floor, Roshdy, Alexandria, Egypt. Phone: +20 3 522 42 21 / 52 22 425
Web: www.newhorizons.com Local Web: alexandria.newhorizons.com Email: [email protected]
 Outlines:

Introduction:
 Introduction to classic Data Analysis
 Introduction to Data Visualization
Course Name  Introduction to Business Intelligence

Lesson1: Managing Data:

Classic Data Analysis Using Excel  Create & Managing Tables
 Range Names
Duration  Sorting & Filtering Data
 Filtering data using slicer
16 HRs  Apply Conditional Formatting

Lesson 2: Using Formulas & Functions

Prerequisites  Basic Formula
 Using Functions
Introduction to Excel
 Functions Types
 Functions Syntax
 Functions Errors Types & Examples

Lesson 3: Using Formulas & Functions

 Math & Trig Functions
 Text Functions
 Date & Time Functions
 Logical Functions
 Lookup Functions
 Statistical Functions
 Nesting Functions
 Practicing with real cases studies.

Lesson 4: Working with Charts

 Create charts
 Modify & Format Charts
 Advanced Charts options
 Sparklines

Lesson 5: Automating Workbook Functionality:

 Apply Data validation
 Working with controls
 Practicing with real cases studies.

Integrated Training Solutions of Egypt and Programming | INTRAST

431 El-Horrya Rd., Roshdy, Alexandria, Egypt. Phone: +20 3 54 26 479 / 54 30 820
1 Syria ST., El Deeb Mall 10th floor, Roshdy, Alexandria, Egypt. Phone: +20 3 522 42 21 / 52 22 425
Web: www.newhorizons.com Local Web: alexandria.newhorizons.com Email: [email protected]
 Outlines:
Module 1: Data Analysis in Excel
 Classic Data Analysis with Excel
 Excel Pivot Tables
 Limitations of Classic Data Analysis

Module 2: The Excel Data Model

Course Name
 Using an Excel Data Model
20779 Data analysis Using Excel  DAX

Duration Module 3: Importing Data from Files

 Importing Data into Excel
24 HRs  Shaping and Transforming Data
 Loading Data
Prerequisites
Module 4: Importing Data from Databases
1. Introduction to Excel  Available Data Sources
2. Classic Data Analysis Using
 Previewing, Shaping, and Transforming Data
Excel
 Table Relationships and Hierarchies
 Loading Data

Module 5: Importing Data from Excel Reports

 Importing Data from Excel Reports
 Transforming Excel report Data

Module 6: Creating and Formatting Measures

 DAX
 Measures
 Advanced DAX Functions

Module 7: Visualizing Data in Excel

 Pivot Charts
 Cube Functions
 Charts for Cube Functions

Module 8: Using Excel with Power BI

 Power BI
 Uploading Excel Data to Power BI
 Power BI Mobile App

Integrated Training Solutions of Egypt and Programming | INTRAST

431 El-Horrya Rd., Roshdy, Alexandria, Egypt. Phone: +20 3 54 26 479 / 54 30 820
1 Syria ST., El Deeb Mall 10th floor, Roshdy, Alexandria, Egypt. Phone: +20 3 522 42 21 / 52 22 425
Web: www.newhorizons.com Local Web: alexandria.newhorizons.com Email: [email protected]