Advanced Excel Training

Spread Sheets are one of the simple and widely used applications where information is gathered, analyzed and exchanged. In our day to day life, we spend a lot of time processing the information in spreadsheets. Microsoft Excel is one of the powerful tools which has various inbuilt Features and Functions which helps in analyzing the data on a real time. The Understanding and usage of these capabilities will help a user to comprehend the information and report information quickly and take advantage of the advanced capabilities provided in the Tool.

Advance Excel Course Details

  1. Shortcut keys (50+)
  2. Importing data from different source like Access, XML, Text, SQL Server
  3. Handling more then 100+ Formula's and their combinations
  4. Advanced Pivot tables
  5. Static and Dynamic Charts
  6. Data Validation techniques
  7. WhatIf Analysis using Scenario Manager, Goal Seek & Data Table
  8. Misc Excel Option like protecting sheet, Track Changes, Page setup for printing etc
  9. Basic of VBA Macros

Advance Excel course can be taken up by:

  • Students & Freshers : For those who wants to start their career and expand and enhance their working knowledge of Excel and utilize the most of its many sophisticated features and functions.

  • Working Professionals : Those who wants to boost their career and seeking proficiency in the use of Microsoft Excel 2013 at an advanced level.

  • Business Owners : A small business owners who want to create their own business dashboards and analyze business performance by themselves.

Advance Excel Course Content

  • Short Keys – around 50 short cut keys
  • Data Importing (From Access, Web and Text)
  • Other Sources (SQL server and XML)
  • ormal Sorting and Filtering
  • Advance Sorting and Filtering
  • UPPER, LOWER, PROPER, LEN, LEFT, RIGHT, MID, FIND, TRIM, CLEAN, CHAR, CODE, CONCATENATE, SUBSTITUTE, EXACT, REPT, REPLACE, SEARCH, VALUE and TEXT.
  • DATEDIF, DATE, TO, NOW, WEEK,
  • ONTH, YEAR, YEARFRAC, NETWORKS, S360, MINUTE, HOUR, SECOND, WEEKNUM, EDATE and EOMONTH.
  • IF, AND, OR, NOT, TRUE, FALSE, IFERROR and Nested Functions.
  • Activities based on the above functions
  • Use the above formula’s in nested formula’s.
  • SUM, SUMIF, SUMIFS, SUMPRODUCT, SUBTOTAL
  • AVERAGE, AVERAGEIF, AVERAGEIFS,
  • COUNT, COUNTIF, COUNTIFS
  • COUNTA, COUNTBLANK,
  • LARGE, SMALL, MAX, MIN, RANK, ROWS, ROW, COLUMN and COLUMNS
  • ABS, ROUND and RAND BETWEEN
  • ISBLANK, ISERROR, ISNUMBER, ISTEXT and ISNA
  • VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, CHOOSE and INDIRECT.
  • VLOOKUP with MATCH, IFERROR, WILDCARD.
  • Nested Vlookup
  • Combination of Formulas
  • Array Formulas VLOOKUP and COLUMN
  • VLOOKUP with IF and VLOOKUP with AND
  • Formatting (Applying Borders, Colors and Font styles)
  • Conversion of Formats
  • Merging and Wrapping the text
  • Conditional Formatting
  • Formulae based Conditional Formatting
  • Format Table
  • Inserting and deletion of Rows, Columns and Sheets
  • Row height and Column width
  • Hide and Unhide of Rows, Columns and Sheet
  • Inserting pictures, Clip art, Text box, Shapes and Smart Art
  • Sparklines
  • Usage of Charts (Column, Pie, Bar, Line)
  • Usage of Dynamic ranges in Charts
  • Text to Columns
  • Removing Duplicates
  • Data Validation – using list, whole number, decimal
  • Data Validation using Custom formula
  • Data Validation - Customization of error alert
  • Data Validations - Input Message, Error Alerts (Stop, Warning and information)
  • Highlighting the Invalid data
  • Data Consolidation
  • Scenario Manager
  • Goal Seek
  • Data Table
  • Group and Ungroup
  • Adding subtotals to the list
  • Tab options in Excel
  • Inserting Hyperlinks
  • Linking sheets, Cells, Workbook, Range and Mail Header-Footer, Word Art and Signature Line Inserting Objects
  • Protect Sheet
  • Protect Workbook
  • Hiding Formulas
  • Sharing Workbook
  • Track Changes (Highlight, Accept and Reject Changes)
  • Inserting and Editing Comments
  • Move or Copy, Rename sheet and Tab Color Filling series of Numbers and Dates Inserting Comments and Spell check
  • Freeze Panes (Rows and Columns)
  • Save workspace, Switch windows and Split window
  • Arranging the window (Vertically and Horizontally)
  • Page Layout, Gridlines and Formula bar
  • Paper margins, Gridlines and Paper size
  • Page breaks, Applying background and Print titles Row repeat at top and Print preview
  • Introduction to Macros
  • Introduction to VBA
  • Importance of Developer Tab and VB window Path to get into VB window
  • Introduction to different windows in VB Enabling the Macros to run the program Macro workbook saving
  • Activities based on Real Time Scenarios Summarizing of Excel

Level
Intermediate
Pre-Requisites
Good Communication skills
Course Duration (Hrs.)
25
Project / Assignment (Hrs)
50
Trainer Experience
3+ years
Batch Size
5-10
Certificate
Yes
.

Reviews

Rajendra K
Hi All, I joined Tutortek for advance excel course . I would recommend this to any one who is looking for course offered by Tutortek. Institute will provide every student with a proper soft copy documents of study materials which will help us in reviewing those documents when we practice and even in future.
Praneeth Kumar

I completed advanced excel training from TUTORTEK. My experience in learning with them was awesome. It is the perfect place for me as the faculty are very friendly n understanding. The tutor Mr Vijay Shanker has ample experience working in corporate world. So he teaches according to practical needs unlike the text book contents.

Gowthaman

Course Content, delivery and instructor Mr Ravi for AWS was very good. Got in-depth knowledge about the different services in AWS.He is too friendly, covers each and every topic very clearly.

Ravi

In Tutortek the training was too good. We can choose our own timings for the class, the infrastructure was good. Our trainer Mr. Ravi helped us to do our best.

Course Content, delivery and instructor Mr Ravi for AWS was very good. Got in-depth knowledge about the different services in AWS.

Upcoming Batches

Courses Training Project Date Time Enroll
Advance Excel Online Training 40 hrs 80 hrs 25 March 9:00AM-11:00AM
Advance Excel Classroom Training 40 hrs 80 hrs 25 March 7:00PM-9:00PM
Advance Excel Online Training 40 hrs 80 hrs 27 March 9:00AM-12:00AM
Advance Excel Classroom Training 40 hrs 80 hrs 27 March 7:00PM-10:00PM

Our Trainers



Get A Free Quote / Need a Help ? Contact Us

Amazon Web Service Training Jayanagar, Bangalore
4.9 stars based on 4 reviews