MicroSoft Excel Training in Marathahalli

Courses Info

 MicroSoft Excel Training in Marathahalli

Learn how to use MicroSoft – Excel from beginner level to advanced techniques which is taught by experienced working professionals. With our MicroSoft Excel Training in Marathahalli you’ll learn concepts in expert level with practical manner.

What is Excel?

Excel is an application developed by Microsoft® for storing the data in the form of spread sheets, helps to analyse the data using different functions / options in Excel

Why Excel?

Excel is facilitated with high end options to analyse the data, create a presentable dashboards that helps the management in taking the decisions. Data storage is made available with password protections or can allow editing for targeted audience

What do we do at Training Marathahalli for Microsoft Excel?

We train the Associates who have a great passion towards learning of Excel. Training is provided in all the areas of the application that meets the organization standards to perform the tasks. We train the associates with best facilitators available who have real time hands on experience.

Whom do we train?

Any professional who are more hunger towards learning and can able to apply in all verticals in their job roles. Syllabus can be customized according to the requirements of the associates

Job Opportunity for the Excel

Excel opportunities are evergreen in market. Every Industry requires professionals who can analyse the data and helps in the decision making for the management. There is a huge demand for the MIS operations that deals with analysis of data.

Certifications

We provide support in completion of the certification courses offered by Microsoft for every module of MS-Office Suite. There are many certifications available in the market that has its own importance and helps in getting placed in the Top most industries.

TIB Classroom Training
training in marathahalli

MicroSoft Excel Training Syllabus:

  • Introduction to Excel
  • Improvements in Excel from 2003 to latest version
  • What’s new in latest versions
  • Excel Options
  • Commands/Shortcuts in Excel
  • Charts
  • Tables
  • Pivot tables
  • Protection of cells, Sheets, Workbooks
  • Data Import, Export
  • Cell Referencing In Excel
  • Relative Referencing
  • Absolute Referencing
  • Difference Between Relative & Absolute Cell Referencing
  • Dashboards in Excel and many more
  • Lookup Functions
  • Logical Functions
  • Statistical Functions
  • Text Functions
  • Date and Time Functions
  • Flash Fill
  • Spark Lines
  • Hyperlink
  • What if Analysis
  • Nesting of functions
  • Creating add-ins
  • Creating Workbooks, Worksheets, and Data
  • Saving and Printing Data
  • Formatting Cells and Worksheets
  • Formatting Data
  • Presenting Data using Conditional Formatting
  • Performing Calculations Using Functions
  • Data Search, Data Validation
  • Creating and Customizing Visual Elements
  • Customizing Options and Views
  • Manipulating Data
  • Advanced Conditional Formatting
  • Linking In Excel Across Sheets/Workbooks
  • Data Connections to multiple Sources
  • Referencing Working with Options and Macros
  • 3D Reference
  • Working With 2D and 3D Charts
  • Pivot Tables with Advance Features
  • Creating Pivot Table Using Wizard / Layouts
  • Formatting Pivot Table With Auto Formats and
  • Creating Pivot Charts by using Source data
  • Modifying The Pivot Charts
  • Creating a Pivot Table Report
  • Slicers and its usages
  • Sorting with Multi Levels by using Clauses
  • Adding Form Wizards
  • Data Validation with Advance Options
  • Subtotals with Multi level Grouping Levels
  • Filtering by using Auto and Advanced Filters
  • Filtering by using Multiple Criteria Levels
  • Filtering and Sorting by Color Levels
  • Customization of toolbar and Quick Access Tool Bars
  • Auditing Excel Sheet
  • Working and editing with Hyperlinks
Download Syllabus

Places

  • Marathahalli
  • Kundalahalli
  • Varathur
  • ITPL
  • Whitefield
  • Kaadugodi
  • Hoodi
  • Mahadevapura
  • Doddanakundi
  • Karthik Nagar
  • HAL
  • Domlur
  • Kaadubeesnahalli