TypeClassroom Training
DateSep 9, 2017
Time2 Days
REGISTER
M.S. Excel Training

Overview

Prerequisites

Course Outline

Schedule & Fees

Certification

M.S. Excel Training Course & Certification

Microsoft’s Excel is most commonly & powerful used tool which is used worldwide. Innovative technology solutions is having a pool of trainers on Excel who can deliver Microsoft Excel trainings from Basic to Advance level. ITS has delivered more than 1000+ batches on Excel. Delivering training on VBA for Excel is our specialization. ITS is keep on running trainings on Excel in Corporate and for individual as well. Our specially designed course on Microsoft Excel is very easy to learn and it helps to acquire skills to become proficient in excel. ITS do have trainings available on MS- office 2007 / 2010 / 2013 and 2016 as well. We are expert in Excel Online training and can be customize as per participant need. For more enquiry on Excel training, please call @ : +91-9870480053

Prerequisites

Candidates should know basic knowledge of computer.

Course Outline                                                  Duration: 2 Days

  1. Managing and Formatting Workbooks and Worksheets
    • Managing & setting up Sheets & Workbooks
    • Viewing the same excel sheets in multiple tabs
    • Freezing the Top Row or the First Column using Freeze Panes
    • Best time saving techniques of managing Page setup options
    • Various formatting techniques along with Conditional Formatting on the basis of Values, Duplicate records, Data bars, etc
  2. Making Excel reports via various Formulas, Functions and Referencing
    • Text Functions like Len, Concatenate, Upper, Lower, Proper & Trim.
    • Logical Functions like If and Multiple Ifs
    • Mathematical Functions like Sum, Abs, Round, Roundup & Rounddown
    • Statistical Functions such as Count, Counta, Countblank, Countif, Countifs, Sumif, Sumifs, Average, Averageifs, Min, Max, Small and Large
    • Lookup Functions such as Vlookup and Hlookup on exact & approximate match
    • Freezing a cell address in a formula by placing $ sign (Absolute Referencing)
    • Linking multiple sheets and workbooks in formula (3D Referencing)
  3.   Working with Data
    • Creating and Modifying Custom Lists
    • Separating the data using Text to Columns
    • Sorting the data in Alphabetical order on single & multiple fields
    • Sorting the data in Customized order by importing the lists
    • Sorting the data in Left to right order
    • Extracting the data using Filters & Advance Filters (Number Filters, Text Filters, Date & Time Filters, Unique Records, Duplicate records & Colour Filtering)
  4. Analysing the data through Pivot Tables
    • Choosing the best Layouts & adding the fields
    • Applying multiple functions on pivot tables
    • Conversions of blank cells & error values with 0
  5. Representing Data in Graphical Form
    • Choosing the best charts as per the data
    • Using Column Charts, Bar Chart, Line Charts & Pie Charts
    • Formatting Charts, adding Chart Titles & changing Chart Locations
    • Linking Charts with Word and PowerPoint
  6. Working with Advance Excel Functions
    • Performing the lookups on the right field instead of left
    • Performing the lookups on multiple tables with various conditions
    • Performing the lookups on multiple fields
    • Performing the case sensitive lookups
    • Combining the horizontal & vertical lookups via Match & Index Functions
    • Date functions like Today, Now, Day, Month, Year, Workdays & Networkdays
    • Statistical Functions like Median and Mode
  7. Working with Range and Naming Convention
    • Applying a Name to a cell and range of cells
    • Modifying, Deleting Range Names & Automatically creating Names on the basis of Headings
  8. Handling Data
    • Linking Excel Data with Word Documents, PDF Files & external objects through Hyperlinks
    • Importing the Data from External Sources like Text Files, CSV Files, etc
    • Representation of the Data in a better structure using Tables
    • Removing Duplicate records from the Excel data
    • Designing quick dashboards/forms by restricting specific data through Data Validations
    • Protecting the dashboards/forms via Locking & Unlocking specific part of sheets
    • Consolidating the reports from various workbooks via Data Consolidation
  9. Analysing Excel Data
    • Applying Subtotals to analyse the data on single & multiple fields
    • Grouping and Ungrouping the Excel Data in Pivot Tables
    • Adding Calculated Fields in Pivot Tables
  10. Performing What if Analysis Tools
    • Calculating Input Value on the basis of Output Value using Goal Seek
    • Analysing the Data with multiple Scenarios using Scenarios Manager
  11. Automation of Tasks & Graphical Representation(As per the availability of the time)
    • Representing data by combining Column & Line Charts on multiple axis
    • Representing data contributions by Pie of Pie chart or Bar of Pie Charts
    • Improving the tasks through Keyboard Shortcuts
    • Automation of the tasks by Recording Macros
    • Saving workbooks with Macro Compatible options

Please write to us at info@itstechschool.com & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

For more info kindly Contact Us.

Microsoft Excel Training in Gurgaon | Microsoft Excel Training Institute in Gurgaon

Innovative Technology solutions provides and the only training company in Gurgaon who provides class room training on Microsoft Excel as per the customer requirement. Our training programs is specially designed for  professionals or fresher’s to get placements in MNCs. Innovative Technology solutions is delivering major of IT trainings in Gurgaon and Microsoft Excel Training is one of the most demanded training. ITS offers hands on practical knowledge / practical implementation on live projects and will ensure to understand or learn the in-depth knowledge on Microsoft Excel from our Microsoft Excel Training. Our Microsoft Excel Training in Gurgaon is conducted by specialist working certified corporate trainers and professionals having real time implementation experience on Microsoft Excel.

Innovative technology solutions is well-equipped Microsoft Excel Training Center in Gurgaon. Innovative Technnology solutions is the well-known Microsoft Excel Training Center in Gurgaon with appropriate infrastructure and lab facilities. Microsoft Excel labs are online, so candidate can access the labs from home as well. Innovative Technology solutions in Gurgaon mentored more than 50000+ candidates on different IT skills and we have public batches on Microsoft Excel Certification Training in Gurgaon at very reasonable fee. We have in house trainer and course curriculum can be customized as per your requirement.

Our training labs are well equipped with Projector, computers, LAN with high speed internet to work on cloud. We also serve lunch for corporate.

Innovative Technology solutions is one of the best Microsoft Excel Training Institutes in Gurgaon with placement support.

Innovative Technology solution is corporate delivery training company and provide training to organizations like HCL, Colt, Kronos, BCG etc. working with MNC’s makes us capable to place our students in top MNCs across the globe.

Microsoft Excel Training Introduction

Microsoft Excel is one of the finest, economical and widely used Technology. Major of IT or non IT companies are using Microsoft Excel services for their cloud hosting solutions. Major of companies required the employees who are hands on Microsoft Excel. After visualizing the demand of Microsoft Excel, Innovative Technology solutions started offering Microsoft Excel training in Gurgaon for individual and Microsoft Excel training for corporates. Innovative Technology solutions do offers trainings on Microsoft Excel in classroom or online mode. Our trainers goes to Customer location and deliver training.

Why you should join Innovative Technology solutions for Microsoft Excel Training in Gurgaon

Top Reasons which makes us best among all others:

  • Best corporate trainers are delivering training.
  • 100% hands on.
  • Trainer discuss the real time challenges of industry and solutions to them.
  • Corporate trainers for Microsoft Excel training
  • Standard training curriculum as suggested by Principle.
  • Microsoft Excel training in Gurgaon available on weekend or weekday basis
  • Preparation for JOB interview or placement
  • Different payment modes are available like – online, cash, bank transfer or EMI.

Corporate training on Microsoft Excel, Corporate trainer for Microsoft Excel , Bootcamp for Microsoft Excel training. Best Microsoft Excel training in India

Innovative technology solutions is Corporate training delivery company, since 2010 and delivered 5000+ corporate batches. Innovative is one of the best trainers in India on Microsoft Excel training. Our trainers are well versed with online training solutions. Our trainer’s everyday delivers online Microsoft Excel training. Professionals from USA, UK and other countries also enrol themselves for our Online Microsoft Excel training programme.  Taking online or classroom Microsoft Excel training from India is always cost effective.


Reviews



 

Are you looking for Microsoft Excel Certification training in India


✓ Microsoft Excel training in Gurgaon


✓ Microsoft Excel training from India


✓ Microsoft Excel online training


✓ Microsoft Excel training


✓ Microsoft Excel classroom training


✓ Microsoft Excel certification

✓ Microsoft Excel video tutorial


✓ Microsoft Excel training in India


✓ Enterprise training on Microsoft Excel


✓ Use Microsoft Excel efficiently


✓ Microsoft Excel guide


✓ best Microsoft Excel training institutes in delhi ncr


Microsoft Excel Training in Gurgaon | Microsoft Excel Training Institute in Gurgaon

Innovative Technology solutions provides and the only training company in Gurgaon who provides class room training on Microsoft Excel as per the customer requirement. Our training programs is specially designed for  professionals or fresher’s to get placements in MNCs. Innovative Technology solutions is delivering major of IT trainings in Gurgaon and Microsoft Excel Training is one of the most demanded training. ITS offers hands on practical knowledge / practical implementation on live projects and will ensure to understand or learn the in-depth knowledge on Microsoft Excel from our Microsoft Excel Training. Our Microsoft Excel Training in Gurgaon is conducted by specialist working certified corporate trainers and professionals having real time implementation experience on Microsoft Excel.

Innovative technology solutions is well-equipped Microsoft Excel Training Center in Gurgaon. Innovative Technnology solutions is the well-known Microsoft Excel Training Center in Gurgaon with appropriate infrastructure and lab facilities. Microsoft Excel labs are online, so candidate can access the labs from home as well. Innovative Technology solutions in Gurgaon mentored more than 50000+ candidates on different IT skills and we have public batches on Microsoft Excel Certification Training in Gurgaon at very reasonable fee. We have in house trainer and course curriculum can be customized as per your requirement.

Our training labs are well equipped with Projector, computers, LAN with high speed internet to work on cloud. We also serve lunch for corporate.

Innovative Technology solutions is one of the best Microsoft Excel Training Institutes in Gurgaon with placement support.

Innovative Technology solution is corporate delivery training company and provide training to organizations like HCL, Colt, Kronos, BCG etc. working with MNC’s makes us capable to place our students in top MNCs across the globe.

Microsoft Excel Training Introduction

Microsoft Excel is one of the finest, economical and widely used Technology. Major of IT or non IT companies are using Microsoft Excel services for their cloud hosting solutions. Major of companies required the employees who are hands on Microsoft Excel. After visualizing the demand of Microsoft Excel, Innovative Technology solutions started offering Microsoft Excel training in Gurgaon for individual and Microsoft Excel training for corporates. Innovative Technology solutions do offers trainings on Microsoft Excel in classroom or online mode. Our trainers goes to Customer location and deliver training.

Why you should join Innovative Technology solutions for Microsoft Excel Training in Gurgaon

Top Reasons which makes us best among all others:

  • Best corporate trainers are delivering training.
  • 100% hands on.
  • Trainer discuss the real time challenges of industry and solutions to them.
  • Corporate trainers for Microsoft Excel training
  • Standard training curriculum as suggested by Principle.
  • Microsoft Excel training in Gurgaon available on weekend or weekday basis
  • Preparation for JOB interview or placement
  • Different payment modes are available like – online, cash, bank transfer or EMI.

Corporate training on Microsoft Excel, Corporate trainer for Microsoft Excel , Bootcamp for Microsoft Excel training. Best Microsoft Excel training in India

Innovative technology solutions is Corporate training delivery company, since 2010 and delivered 5000+ corporate batches. Innovative is one of the best trainers in India on Microsoft Excel training. Our trainers are well versed with online training solutions. Our trainer’s everyday delivers online Microsoft Excel training. Professionals from USA, UK and other countries also enrol themselves for our Online Microsoft Excel training programme.  Taking online or classroom Microsoft Excel training from India is always cost effective.


Reviews



 

Are you looking for Microsoft Excel Certification training in India


✓ Microsoft Excel training in Gurgaon


✓ Microsoft Excel training from India


✓ Microsoft Excel online training


✓ Microsoft Excel training


✓ Microsoft Excel classroom training


✓ Microsoft Excel certification

✓ Microsoft Excel video tutorial


✓ Microsoft Excel training in India


✓ Enterprise training on Microsoft Excel


✓ Use Microsoft Excel efficiently


✓ Microsoft Excel guide


✓ best Microsoft Excel training institutes in delhi ncr



M.S.Excel Course content is given below