Professional Data Analysis using
Excel 2013

Date of Training

December
12 & 13

Download Brochure

Improve your reporting proficiency with Advanced Techniques, Pivot Tables and Macros.
This course covers the following;
  • Working more efficiently with workbooks and worksheets.
  • Enhancing the presentation of data and worksheets.
  • Performing analysis using functions and using sorting and filtering options.

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond simple workbooks.

Learning Outcomes:

Upon successful completion of this course, participants will be able to:

  • use the fill operations to fill a data series
  • understand and use formula cell referencing to create complex formulas
  • use a range of logical functions
  • apply conditional formatting to ranges in a worksheet
  • create and use labels in a workbook
  • work with various elements of a worksheet
  • use a range of techniques to work with worksheets
  • use a range of find and replace techniques
  • apply a variety of page setup techniques
  • sort data in a list in a worksheet
  • filter data in a table
  • create effective charts
  • use a range of techniques to enhance charts
  • apply formatting techniques to text in charts

Filling Data

  • Conditional Formatting
  • Understanding filling
  • Filling a series
  • Creating a custom fill list
  • Modifying a custom fill list
  • Deleting a custom fill list

Formula Referencing

  • Absolute and relative referencing
  • Relative formulas
  • Problems with relative formulas
  • Creating mixed references
  • Other basic formulas

Creating Name Range

  • Creating names for the range
  • Using names in new formulas
  • Creating names using the name box
  • Using names to select ranges
  • Pasting names into formulas
  • Creating names from a selection
  • using the name manager

Logical Functions

  • Understanding logical functions
  • Using IF to display text
  • Using IF to calculate values
  • Nesting IF functions
  • Using IFERROR
  • Using AND
  • Using OR
  • Vlookup function
  • Multiple Vlookup

Conditional Formatting

  • Formatting cells containing values
  • Creating conditional formatting
  • More cell formatting options
  • Top & bottom ten items
  • Working with data bars
  • Working with color scales
  • Working with icon sets
  • Sparkline (New Feature)
  • Creating sparklines
  • Editing sparklines

Formulas

  • Count, CountA, CountIF & CountBlank
  • Sum, SumIF & SumIFs
  • Networkdays
  • Networkdays international (for ver 2010)
  • Today & Now function
  • Trim (removing unwanted spaces)
  • Concatenate (combining columns)

Advance Validation

  • Creating drop down in cells
  • Restricting values from list only
  • Creating error message
  • Creating dependent list

Dynamic Table

  • Converting data into table
  • Automating calculation in table
  • Converting table to normal range

Regular Fee

AED 1800
  • per participant

Gold Package

AED 1530

15% discount for 2 participants from the same organization

  • per participant

Platinum Package

FREE for

4th participant from the same organization

  • 1800 AED per participant

How to Register?

Call us: +971 6 5612230

Send Email: registration@mindsuae.com

Call on mobile: +971 56 5019585

Download the Brochure

<