+91 80 2355 2222
info@tremplinsolutions.com

About the course

Advanced Excel 2013 course is designed for students/professionals who want to learn advanced features of excel for generating smart reports with lots of time saving which they can use it for other tasks. In addition ADVANCED EXCEL 2013 course is also useful to people who want to clear the Microsoft certification for MS Excel (MOS) 2013. We offer the best advanced excel training workshop in Bangalore and training with us would give you an edge over others at office or in interviews..

Course Outline

  • INTRODUCTION TO EXCEL USER INTERFACE
    • Application
    • Workbook
    • Worksheets & its Components
    • Named Ranges
  • DATA GROUPING
    • Grouping Rows
    • Grouping Columns
  • FORMATTING
    • Cell Color, Font Color, Indents, Alignments
    • Text Orientation
    • Number Formats
    • Custom Formats
    • Editing commands
  • DATA SORTING
    • Built-in Sort
    • Sorting Levels
    • Custom Sort
    • Custom Formats
    • Editing commands
  • DATA TABLES(LIST OBJECTS)
  • CONDITIONAL FORMATTING
    • Formatting based on Cell values
    • Formatting based on Formulas
    • Icon Sets (bars, scales, icons)
  • FREEZING PANES
  • TEXT-TO-COLUMNS
    • Delimited
    • Fixed Length
  • DATA FILTERING
    • Auto Filter- Filter by color, Filter by Icon sets
    • Advanced filter
    • Remove duplicates
  • DATA SUBTOTAL
    • Built-In Subtotal (Nested Subtotal)
  • DATA VALIDATION
    • Based on cell (text length, whole no, dates)
    • Based on formulas
    • List dropdown
    • Circle Invalid data
    • Input & Error Message
  • Charts
    • Chart types
    • Chart Components
    • Primary Vs Secondary Axis
    • Chart formtting
  • FORMULAS
    • Text functions
    • IF
    • Error Functions
    • Logical Functions
    • VLOOKUP
    • HLOOKUP
    • COUNTIF
    • SUMIF
    • SUM Product
    • Date & Time functions
  • PIVOT TABLES
    • Introduction & creation slicer
    • Pivot charts
    • Calculated fields
    • Calculated Items
    • Formatting – Number / Conditional
  • DATA TABLES(LIST OBJECTS)
  • CONDITIONAL FORMATTING
    • Formatting based on Cell values
    • Formatting based on Formulas
    • Icon Sets (bars, scales, icons)
  • FREEZING PANES
  • TEXT-TO-COLUMNS
    • Delimited
    • Fixed Length
  • DATA FILTERING
    • Auto Filter- Filter by color, Filter by Icon sets
    • Advanced filter
    • Remove duplicates
  • DATA SUBTOTAL
    • Built-In Subtotal (Nested Subtotal)
  • DATA VALIDATION
    • Based on cell (text length, whole no, dates)
    • Based on formulas
    • List dropdown
    • Circle Invalid data
    • Input & Error Message
  • Charts
    • Chart types
    • Chart Components
    • Primary Vs Secondary Axis
    • Chart formtting
  • FORMULAS
    • Text functions
    • IF
    • Error Functions
    • Logical Functions
    • VLOOKUP
    • HLOOKUP
    • COUNTIF
    • SUMIF
    • SUM Product
    • Date & Time functions
  • PIVOT TABLES
    • Introduction & creation slicer
    • Pivot charts
    • Calculated fields
    • Calculated Items
    • Formatting – Number / Conditional

WHAT ARE THE LEARNING OBJECTIVES OF EXCEL 2013 COURSE DESIGNED BY

At the end of the training the participants would learn/uselacquire the following techniques/knowledge

  • Data Management
  • Data Analysis
  • Data Validation
  • Summarize the Reports
  • Dashboard Report
  • MIS Report
  • Charts reports

SCOPE OF LEARNING:

  • User able to manage data independently
  • User able to do reports (eg: Financial, Banking, Insurance, Pharmaceutical, Retail, Educational, small shops etc)
  • User will become data analyst
  • User will able to do MIS reports
  • Maximum organization will use the excel
  • It requires day to day activities to manage & analyse the data