Request Call Back
Please Contact Us
  • +91-80-42188793
  • enquiry.itas@gmail.com

JUMBO DASARA OFFER | Flat 10,000rs off on all the Packages | Offer valid till 31st October 2018 on single installement only.

>

advanced excel

Fees : Rs 5,000 Only

Duration : 24 Hours

We offer Excel training course on the latest version of Excel, i.e. MS Excel 2016. As Excel 2016 is the latest version, we have created a new Excel Upgrade Training Course, which will only show you new and enhanced Excel 2016 features.

Prerequisites:

Basic Knowledge of Computers.

Course Objectives:

After the course, you will be able to:

  • Create and maintain spreadsheets
  • Create and edit formulae
  • Format and print worksheets
  • Perform basic list management tasks

Course Contents

  • Spreadsheet Principles
  • Understanding Screen Layout
  • Creating Auto List & Custom List
  • Entering, Selecting and Editing Data
  • Understanding References (Relative, Absolute & Mixed)
  • Common Basic Functions
  • Logical Functions
  • Text Functions
  • Date & Time Functions
  • Lookup & Reference Functions
  • Mathematical Functions
  • Conditional Functions
  • Array Formulas
  • Referring Data from Different Worksheet & Workbook
  • Using all commands in Formula Auditing group in Formulas tab.
  • Trace Precedents
  • Trace Dependents
  • Show Formulas
  • Evaluate Formula
  • Error Checking
  • Trace Error
  • Watch Window
  • Naming Cell Ranges
  • Creating Static and Dynamic Ranges
  • Using Name Manager to Add and Edit cell ranges.
  • Sorting Top to Bottom
  • Sorting Left to Right
  • Sorting with Custom Order
  • Filtering Various types of Data
  • Text Filters
  • Number Filters
  • Date Filters
  • Using Advanced Filters with Example
  • (Cells, Range, Sheets)
  • Conditional Formatting
  • Number Formatting
  • Table Formatting
  • Applying validation using predefined set of datatypes
  • Applying validation using Custom Formulas
  • Data Consolidation
  • Group and Outline
  • Text to Columns
  • Flash Fill
  • Whatif Analysis
  • Goal Seek
  • Data Table
  • Forecast Sheet
  • Creating Data Forms for Data Range and Tables
  • Basic Charts
  • Advanced Charting Techniques
  • Dynamic Charting Techniques
  • Understanding Sparklines
  • (Line, Column, Win/Loss)
  • Understanding Tables and Ranges
  • Pivot Techniques
  • Advanced Pivot Tables & Pivot Charts
  • Working on Slicers & Timelines
  • Power Pivot
  • Power Query
  • Power Map
  • Power View
  • Protecting Sheets & Files
  • Share Workbook
  • Understanding Various Excel Window Techniques
  • Viewing Excel Spreadsheet in various Layouts
  • Advanced Printing Techniques
  • Templates Themes
  • Tips & Tricks

iTAS (iTech Analytic Solutions) is a complete Analytics Solution provider with. unparalleled value-optimizing Information Insight to client organizations through the use of cutting-edge, customized reporting systems, analytical models, and database applications

iTAS (iTech Analytic Solutions) provides data driven business decisions with quantitative modeling expertise & deep understanding of business needs and state-of-the-art technologies to solve complex problems.

Contact Us

  • +91-80-42188793
  • enquiry.itas@gmail.com
  • Branch 1:No. 9, 1st Floor, 8th Main, 9th Cross, SBM Colony, Brindavan Nagar,Mathikere, Bengaluru, Karnataka, India - 560054
  • Branch 2:#403, 11th Cross,19th Main, 1st Block, Rajajinagar, Bengaluru - 560 010

Copyright ©2018 iTAS. All Rights Reserved

Brochure download