Microsoft Advanced Excel Course
Excel 2016: Core Data Analysis, Manipulation, and Presentation

(5) days Training – 3 Hours / Day From 4:00PM to 7:00PM

Starting Date: 28/7/2019 – 1/8/2019  - Course price is 250,000 IQ

  • Manage Worksheets and Workbooks
  • Create Worksheets and Workbooks
  • Navigate in Worksheets and Workbooks
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks
  • Manage Worksheets and Workbooks
  • Configure Worksheets and Workbooks for Distribution
  • Data Cells and Ranges
  • Insert Data in Cells and Ranges
  • Format Cells and Ranges
  • Summarize and Organize Data
  • Create Tables
  • Create and Manage Tables
  • Manage Table Styles and Options
  • Filter and Sort a Table
  • Perform Operations with Formulas and Functions
  • Summarize Data by using Functions
  • Insert references
  • Perform calculations by using the SUM function
  • Perform calculations by using MIN and MAX functions
  • Perform calculations by using the COUNT function
  • Perform calculations by using the AVERAGE function
  • Finding duplicate values by using VLOOKUP function  
  • Perform Operations with Formulas and Functions
  • Perform Conditional Operations by using Functions
  • Perform logical operations by using the IF function
  • Perform logical operations by using the SUMIF function
  • Perform logical operations by using the AVERAGEIF function
  • Perform statistical operations by using the COUNTIF function
  • Format and Modify Text by using Functions
  • Format text by using RIGHT, LEFT, and MID functions
  • Format text by using UPPER, LOWER, and PROPER functions
  • Format text by using the CONCATENATE function
  • Create Charts and Objects
  • Create a new chart
  • Add additional data series
  • Switch between rows and columns in source data
  • Analyze data by using Quick Analysis
  • Format Charts
  • Resize charts
  • Add and modify chart elements
  • Apply chart layouts and styles
  • Move charts to a chart sheet
  • Insert and Format Objects
  • Insert text boxes and shapes
  • Insert images
  • Modify object properties

For Registration Please send e-mail to: courses@startservices.iq

Or Call our Office: + 964 750 453 96 68

Image