Spreadsheet Training banner

The courses we offer , will be of great values to all professionals in business, finance and many other areas that need to analyse data in accounts, or keep records of stock or schedules, and to anyone trying to keep track of their personal finances at home.

Excel for Experts

For those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use MS Excel at an advanced level.To get the most out of this course, you will need to have completed our entry-level Microsoft Excel course or have the equivalent experience of this extremely popular software. You ’ll possess the top skills being sought by employers.
Course Duration : 45 Days
Course Fees : Rs. 7,500/-
Info
Enrol

Excel for Pro

This course enables the professionals to gain proficiency in handling basic formulas and tools. This training helps the users to enhance their understanding of the basic tools for organizing, visualizing, calculating and managing data in MS Excel. It is ideal for those who are looking to improve their job prospects by adopting Excel fundamental skills and knowledge.
Course Duration : 45 Days
Course Fees : Rs. 7,500/-
Info
Enrol

Excel for All

This training is designed with the absolute beginner in mind. The tutorials include step by step examples and will show you how to use Excel to create a basic spreadsheet. You will Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and Pivot Tables
Course Duration : 45 Days
Course Fees : Rs. 7,500/-
Info
Enrol

Excel for Pro

  • Overview
  • Course Objectives
  • Topics Outline
  • Trainer Info
  • Who Should Attend
  • Career Opportunities

This course is suitable for beginners with Microsoft Excel but also for those who wish to cover the advanced topics in Excel. Through the course content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment.

 

· Identify the different components of the Excel worksheet.
· Differentiate between an Excel workbook & worksheet.
· Use the Office Assistant
· Open an existing workbook and create a new workbook
· Enter text and formulas in to an Excel spreadsheet
· Enhance alpha and numeric date in an Excel Worksheet
· Move & Copy alpha and numeric data
· Construct formulas to manipulate numeric data in an Excel Worksheet
· Create a spreadsheet to tabulate and record numeric values
· Change the appearance of an Excel spreadsheet
· Use the print function to create a printable copy of data stored on an Excel
· Set up the chart function of Excel to represent numeric data in multiple formats.
· Differentiate between formulas and functions in Excel.
· Use at least four functions that are stored in Excel.
· Access and manipulate data using the database functions of Excel.
· Create simple & complex macros in Excel.

Section 1: Design and Risk

  • Unit 1.1 - Templates
  • Unit 1.2 - Efficiency and Risk
  • Unit 1.3 - Data Validation

Section 2: Advanced Techniques

  • Unit 2.1 - Functions and Superpowers
  • Unit 2.2 - Array Formulae
  • Unit 2.3 - Tables
  • Unit 2.4 - Advanced Range Names
  • Unit 2.5 - What If?
  • Unit 2.6 - Problem Solving

 Section 3: Excel Interactivity

  • Unit 3.1 - Form Controls
  • Unit 3.2 - Visual Basic and Macros

 Section 4: Spreadsheet Impact

  • Unit 4.1 - Practical Interactivity with VBA
  • Unit 4.2 - Conditional Formatting
  • Unit 4.3 - Charts that Inspire
  • Unit 4.4 - Sparklines
  • Unit 4.5 - Graphics Tricks and Techniques
  • Unit 4.6 - Working with External Data

 Section 5: Turning Data into Decisions

  • Unit 5.1 - Advanced Uses of PivotTables
  • Unit 5.2 - PowerPivot
  • Unit 5.3 - Reporting with PowerPivot
  • Trainer Information
  • Our trainers are highly experienced and skilled.
  • All our Sharepoint trainers are employed with top level IT companies.
  • All our Sharepoint trainers are Microsoft certified professionals.
  • Our trainers have 5+ years’ experience in sharepoint with through knowledge on sharepoint 2008 and sharepoint 2010
  • Many of our Sharepoint online trainers are working on the relevant platform and have 3+ years of real time experience on sharepoint 2010
  • Sharepoint Online Training techniques of us are specially designed for the global learners and are globally proven.
  • Our trainers are excellent Online Training experts
  • Our Trainers aims at quality teaching, which earned them multitudes of learners and also trains in corporate companies

 

  • This training program is ideal for-
    • Candidates who are interested in extending their knowledge and understanding of Microsoft excel.
    • Professionals who use Microsoft Excel to perform daily activities.
    • Professionals working in marketing, accounting and is also best suited for pricing analysts and business analysts.

Today, Microsoft Excel may very well be the most used business software on the market. It has broad applications, from simple data entry to complex problem solving, that are used to make important business decisions. Thus the trademark green “X” for Excel is synonymous with money, and in fact most of the data being shuffled around an Excel spreadsheet really just boils down to dollars and cents in profit.

Microsoft estimates that 5 – 10% of Excel users are using the more complex features of the application to create business insights, and these formula and function gurus can be considered programmers of sorts. It’s no surprise these “Excel programmers” are earning more than their colleagues. So if you like problem solving, data analysis, and the idea of making some big bucks, you may want to study up and become an Excel power user.

In short, if you understand how to use Excel and create valuable insights for your company, you will be a valued employee, and can expect to be compensated accordingly. While it would be pretty hard to become an Excel power user overnight, you can learn our online Excel courses. If you are looking to learn the more advanced features we also have online Excel courses available, so don’t wait. Pick a course and start getting skilled up!

Colors