1 Full Day Workshop In Mumbai For Excel Training

Excel Course, Level 1 (2016,2013, 2010, 2007)

The Excel Course Level 1 program introduces participants to working with Microsoft Excel, covering the basics such as creating and editing worksheets, formatting them for a professional look, working with formulas to manage routine tasks, etc.

Audience
Executives and managers from various functions (such as Finance, Sales, HR, etc.) who need to work with lots of calculations and analyze data for their day-to-day operations.

This introductory Excel training course will provide you with a working understanding of the basic features of MS Excel as follows:

  1. Creating and editing worksheets.
  2. Formatting and printing of worksheets.
  3. Commands for managing data such as sorting, filters, subtotals, pivot tables.
  4. Working with charts.
  5. Working with in-built functions of Excel.

Microsoft Excel Training Module 1: Getting Started

  • Understanding the Excel screen
  • Navigating in a spreadsheet
  • Understanding worksheets, columns, rows and cells
  • Saving, opening, and closing workbooks

 

Microsoft Excel Training Module 2: Formatting a Spreadsheet

  •   Changing column widths and row heights
  • Changing alignment of cells
  • Undoing and redoing actions
  • Formatting numbers
  • Clearing formats
  • Applying borders to cells
  • Merging cells

 

Microsoft Excel Training Module 3: Formulas and Functions

  • Entering formulas
  • Copying data and formulas
  • Using AutoSum
  • Understanding functions
  • Using simple aggregate functions (Sum, Count, Average, Min, Max)
  • Copying formulas
  • Types of cell referencing: relative and absolute
  • Applying conditions in a formula (The IF function)
  • Working with ranges

 

Microsoft Excel Training Module 4: Editing Features

  • Using cut , copy, and paste operations
  • Using paste special with values
  • Selection techniques
  • Navigation techniques

 

Microsoft Excel Training Module 5: Working with Large Worksheets

  • Freezing and unfreezing panes
  • Splitting windows
  • Inserting page breaks for printing

 

Microsoft Excel Training Module 6: Working with Charts

  • Creating charts using Chart Wizard
  • Creating different types of charts
  • Including titles and values in charts
  • Formatting of charts

 

Microsoft Excel Training Module 7: Previewing and Printing

  • Previewing worksheets
  • Page setup
  • Printing of worksheets in multiple pages
  • Repeating rows and columns for multiple pages
  • Printing multiple worksheets

 

Microsoft Excel Training Module 8: Simple Database Operations

  • Sorting tables
  • Filtering data with auto filter
  • Generating subtotal reports
  • Creating pivot tables
  • Referring data from other worksheets

Talk to the Trainer or Enquire about the Program


A great learning experience!!! Teaching was in depth and explained very well. Mr. Faiyaz Khairaz covered all important aspects of Microsoft Excel and Outlook. Would definitely recommend to all those who want to learn about the various aspects of using Microsoft Office Package.
Paras Bhalla
Paras Bhalla
14:19 16 Jun 17
This was an amazing experience. The entire session was really a great learning experience. I would recommend this to all corporates.
ABHINAV CHAUDHRY-DM
ABHINAV CHAUDHRY-DM
04:03 19 Jun 17
The training by Mr Faiyaz was sublime.. I got to know many new things and revision of known things.. Overall it was splendid expereince of Excel training.. Thanks for imparting such good knowledge
SWATI MISHRA
SWATI MISHRA
05:28 01 Jun 17
We had a very nice training of advance excel. Mr. Faiyaz was very interactive and helpful in solving the real time issues. The output of training was very good and helpful in my daily work
swapnil deshpande
swapnil deshpande
06:26 01 Jun 17
A great workshop just ended for us at Mahindra buses and trucks...fayaz was very helpful and indeed persuasive in getting us ingrained in excel and outlook ... Would recommend ... Cheers
Bharat Raghavan
Bharat Raghavan
03:05 18 Jun 17
It was an excellent training session. Mr. Faiyaz has given us perfect guidance. The Excel Program was truly beneficial.
MIS India Private
MIS India Private
14:06 20 Jul 17
It was a great corporate experience of learning advanced excel in a good ..smooth..faster way with hardwork and determination lead by Faiyaz...Very Good Keep It up ...Sterlite Tech Employee
Kalpesh Sambhria
Kalpesh Sambhria
13:58 20 Jul 17
Good Teaching Skills. Opened the completely new area of EXCEL. Would definitely suggest to my colleagues.
Samir Maner
Samir Maner
11:10 17 Aug 17
We had a two-day intensive workshop on Microsoft Excel in our corporate office and to sum up the experience let's just say beginner to pro in two days. Great learning session from the certified tutor, Mr. Faiyaz Khairaz.
Gilbert Khakhlari
Gilbert Khakhlari
11:45 21 Aug 17
Hii. Excellent & very nice trainer and thanks for sharing your knowledge and experience with us.thanksJitendra Kumar
Excise Mumbai
Excise Mumbai
06:42 22 Aug 17
it was too good..the way he teach us the MS Excel, we never thought there are so much we can do in excel. Now we can do more things in Excel i.e. presentation of Data. Teaching skill was amazing, Excellent Trainer. will definitely suggest my friends.
Sumit Navre
Sumit Navre
10:31 22 Aug 17
Faiyaz sir teach awesome excel it's very easy to understand our excel ... teaching skills are very good I will surely get in touch with him .. soon ...
Nikhil Patel
Nikhil Patel
13:20 30 Aug 17
Faiyaz was very much supporting & made us understand in detail. Thks! all the best.
asgarali shaikh
asgarali shaikh
13:21 30 Aug 17
Was very helpful in understanding the functions in Excel and how to use it. Very logical explanations for everything
Pranidhi Trivedi
Pranidhi Trivedi
13:19 30 Aug 17
On the first note I want to thank you from the bottom of my heart for sharing a brilliant workshop. The way how that all the topic have been covered up in a short span of time is very systematic. I personally appreciate the effort that Faiyaz sir has put. Most importantly the style of teaching, the way of interaction, and all the PRACTICE SHEETS were perfect to catch the topic.Two days well spent with proper LEARNINGS after a long time.THNX
Riddhi Bora
Riddhi Bora
10:54 12 Oct 17
Good teaching skills. Well structured course on Excel and Outlook. Highly recommend to new entrants in the corporate world
Sarvesh Bavadekar
Sarvesh Bavadekar
10:48 12 Oct 17
We had a training with Mr. Faiyaz Khairaz for a coupe of days in Pune. A very dynamic trainer who very well knows how to keep the flow for such sessions and keep the participants involved. Great learning experience.
Shubham Agarwal
Shubham Agarwal
10:45 12 Oct 17
Overall it was a good experience. Got to learn excel from basic.Thanks to Faiyaz Sir.
Anshul Srivastava
Anshul Srivastava
10:56 12 Oct 17
Excellent trainer (Faiyaz). The training was really helpful. Great experience.
karan kapoor
karan kapoor
10:46 12 Oct 17
It's a great experience. Excellent trainer. Good teaching skills.
Shreya Ambetkar
Shreya Ambetkar
15:54 05 Nov 17
Thanks, Faiyaz sir, for conducting such a brilliant workshop on Advance Excel....at CENTURY RAYON CO. for the first time. Hoping this relationship will go even further. You made the workshop so lively that even the topic like Excel had not only get understood but entertaining as well.Superb Workshop...
Arun Sharma
Arun Sharma
11:33 07 Nov 17
Very good faculty with in depth knowledge of ms Excel. Our training session held by Mr. Faiyaz Khairaz was excellent at Ms Century rayon.
mahendra singh
mahendra singh
18:07 13 Nov 17
A very great experience in learning many useful things in Excel..The trainer,Mr.Faiyaz is a bank of knowledge n specially to mention, loved his teaching style n techniques, right into our brains...good going..keep it up...
Sudha Murthy
Sudha Murthy
05:47 23 Nov 17
Very organized step by step approach of learning Excel.I like the interactive style, and having the sample worksheets available is helpful to practice. over all it was good.
shamilee konka
shamilee konka
12:00 23 Nov 17
" Excellent Training and trainer is full of energetic. But little bit faster. Overall it was full of knowledge.
Kalyani Dodkade
Kalyani Dodkade
12:06 27 Nov 17
It was really a great learning experience. Trainer had good teaching skills and cleared every doubt that we raised.
Avinash Pathare
Avinash Pathare
12:10 27 Nov 17