Complete your Purchase Now 50% off

Microsoft Excel Intermediate [ARABIC]

Microsoft® Office Excel® 2016: Part 2

Course Description

Overview:

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

Course Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

You will:

  • Work with functions.

  • Work with lists.

  • Analyze data.

  • Visualize data with charts.

  • Use PivotTables and Pivot Charts.

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Prerequisites:

To ensure success, students should have completed Logical Operations’ Microsoft® Office Excel® 2016: Part 1 or have the equivalent knowledge and experience.

This course includes

  • 62 lectures

  • 10.5 Total Hours on-demand Video

  • 64 Downloadable Resources

  • Full Lifetime Access

  • Access on Mobile and TV

  • Certificate of Completion

Course Instructor

CEO, ICTGate Training Manager

Eng. Mohamed Hussein Ali

IT Instructor from 2010 Till Now --- Teaching [ ICDL - IC3 - Microsoft Office "All Versions" - IT Fundamentals - CompTIA A + - CompTIA N + - CompTIA Security + - CCNA Routing & Switching - CCNP Routing & Switching - CCNA Security - MCSA 2016, 2012 & 2008 - CEH ] - Total Teaching Experiences [ More Than 10,000 hrs. ]

Course Content

  • 1

    00 I Introduction To Microsoft Excel Intermediate

  • 2

    Chapter 1 I Working with Functions

    • 1.1 I Work with Ranges

      FREE PREVIEW

    • 1.2 I Function Syntax

      FREE PREVIEW

    • 1.3 I IF Function

    • 1.4 I Nested IF Function

    • 1.5 I SUMIF Function

    • 1.6 I SUMIFS Function

    • 1.7 I AVERAGEIF Function

    • 1.8 I AVERAGEIFS Function

    • 1.9 I COUNTIF Function

    • 1.10 I COUNTIFS Function

    • 1.11 I And Function

    • 1.12 I OR Function

    • 1.13 I NOT Function

    • 1.14 I IF AND Function

    • 1.15 I IF OR Function

    • 1.16 I IF NOT Function

    • 1.17 I Today & Now Functions

    • 1.18 I Day Month Year Functions

    • 1.19 I Date Function

    • 1.20 I Hour Minute Second Functions

    • 1.21 I Time Functions

    • 1.22 I DATEDIF Function

    • 1.23 I NETWORKDAYS Function

    • 1.24 I NETWORKDAYS.INTL Function

    • 1.25 I WORKDAY Function

    • 1.26 I WORKDAY.INTL Function

    • 1.27 I ISOWEEKNUM Function

    • 1.28 I WEEKDAY Function

    • 1.29 I LEFT & MID & RIGHT Functions

    • 1.30 I Find Function

    • 1.31 I Ampersand Formula

    • 1.32 I Concatenate Function

    • 1.33 I UPPER & LOWER & PROPER Functions

    • 1.34 I Get External Data
  • 3

    Chapter 2 I Working with Lists

    • 2.1 I Data Sorting

    • 2.2 I Data Filtering

    • 2.3 I DSUM Function

    • 2.4 I DAVERAGE Function

    • 2.5 I DMAX Function

    • 2.6 I DMIN Function

    • 2.7 I DCOUNT Function

    • 2.8 I DCOUNTA Function

    • 2.9 I DGET Function

    • 2.10 I DPRODUCT Function

    • 2.11 I DSTDEV Function

    • 2.12 I DSTDEVP Function

    • 2.13 I DVAR Function

    • 2.14 I DVARP Function

    • 2.15 I Outlines Data

    • 2.16 I SUBTOTAL Function
  • 4

    Chapter 3 I Analyzing Data

    • 3.1 I Format as Table

    • 3.2 I Create and Modify New Table

    • 3.3 I Intermediate Conditional Formatting

    • 3.4 I Advanced Conditional Formatting
  • 5

    Chapter 4 I Visualizing Data with Charts

    • 4.1 I Create Charts

    • 4.2 I Modify and Format Charts

    • 4.3 I Advanced Chart Features
  • 6

    Final Chapter 5 I PivotTables and Pivot Charts

    • 5.1 I Create a PivotTable

    • 5.2 I Analyze PivotTable Data

    • 5.3 I Present Data with PivotCharts

    • 5.4 I Filter Data Using Timelines and Slicers