Download
App
Brochure download
Fill in your details
  • +91-80-42188793
  • enquiry@itasinc.in

Mega Package : Essential Skills for Data Science, Data Analytics, Business Analytics, MIS Reporting --> 26 Courses, 350+ Videos, 150+ Hours Video Contents, Downloadable Practice Files, 300+ Downloadable E-Books, 150 MS Excel Editable, Reusable templates, 300+ Excel, CSV Data Sets, 100000+ Infographics, Graphics & Images Library, 1000+ Sample Editable Resumes, 70000+ Designer Fonts, Instagram, YouTube Thumbnails & Stories

>

advanced excel

Fees : Rs 5,000 Only

Duration : 24 Hours

Enroll Now

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.

Useful Links

Support

Contact Us

  • +91-80-42188793
  • 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

Enquiry

  • M: +91 9066068793, 9066078793, 9902058793
  • E: enquiry@itasinc.in

Placements

  • M: +91 7619483672
  • E: jobs@itasinc.in

Copyright ©2018 iTAS. All Rights Reserved