Excel Workshop Content

Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Use Templates

Dates formats

  • Extracting Day, Month or Year from a date value
  • Extracting Day, Month or Year from a date value using TEXT Formula
  • Extracting end month from a date value

Sorting & Advance Filtering data

  • Sort data as per value, colour, icons
  • Filter based on Font/Cell colour
  • Turning Auto Filter off
  • Use subtotal features
  • Using Table style

Formulas & Combinations

  • SUM, COUNT, COUNTA, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, RANK
  • CONCATENATE, FIND, SEARCH, LEFT, RIGHT, MID, UPPER, PROPER, LOWER, TTRIM, LEN
  • IF, AND, OR, IFERROR
  • Formula Auditing

Understanding Cell References

  • Relative, Absolute & Mixed reference
  • Referencing different workbooks & Merging
  • Consolidating data, linking cells in different work books
  • Utilizing Dynamic Named Ranges for writing formulas and functions

Data Analysis Report with Pivot Tables & Pivot Charts

  • Analyzing and generating reports of large data using PivotTables.
  • Creating PivotTables, editing and updating changes in PivotTable.
  • Using Slicers in Pivot Table
  • Creating Pivot Chart

Duration:5 Hrs.

Fess:300/-