Both Classroom and Live online training is available.
Duration
5 Day
Fees
Overview
This course aims to provide skills and knowledge which will allow the attendee to Learn MS Excel tools, Techniques and create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and Solver, and create and use macros.
Microsoft Excel is a spreadsheet developed by Microsoft and it can be using in different Operating systems like Microsoft Windows, iOS, Android and etc... Excel tool is used for calculation, graphing tools, pivot tables, and a macro programming and data visualization. Microsoft excel is a familiar and most recommended tool for all industries from technical to management level.
Microsoft Excel helps companies maximise the value of their data, helping to control costs more effectively and obtain business information.
ITechGurus Trainers are Microsoft certified holders and with an average work experience of 15+ years. Through a proper (Train - the - Trainer) programs with adult learning skills and techniques of ITechGurus, Trainers presenting a classes very interesting, enjoyable and enriching. An average our faculties have more than 15 years of Experience in Teaching. No compromise in delivering high quality and fun classes – and this reflect the results in consistently high pass rates and high quality student experience
Advantages
Easy data entry and operations: One of the main advantages of MS excel is that it facilitates smooth and easy data entry. Compared to any other data entry and analyzing tools, MS Excel offers features like Ribbon interface, a set of commands used to perform certain operations. Ribbon consist of many tabs, which again consist of many command groups and their buttons. You can select the commands by clicking the related button and perform operations very easily.
Accurate comparisons and analysis options: MS Excel provides many analytical tools for the accurate analysis and comparison of large amounts of data. The advanced sorting and filtering techniques allows you to sort out large amount of data so that it will be easier for you to find out the required information. Also, filtering removes unwanted or repeated data and helps to save time and effort.
Allows graphical representation of data: MS Excel allows you to create the visual representation of data and information. The data can be visually displayed in the form of bar charts, column charts and graphs. It automatically revises the charts and graphs, once the data gets modified. Tables help to classify different entities according to their characteristics and features.
Compatible with other business applications: Since the recent versions of MS Excel is compatible with many other business applications like MS office, other web applications etc., it allows you to import excel data to other applications. Also, the cloud computing facility helps to update and upload your excel document from all locations, which can be accessed later through various devices like smartphones, tablets, laptops etc.
Ready to use formulas: MS Excel performs all mathematical and logical functions like addition, subtraction, multiplication, division, average, sum, mod, product etc. Excel provides many formulas that helps you to solve both simple and complex calculations.
Course Outcomes and Benefits
- use a range of lookup and reference functions
- modify Excel options
- customise the formatting of charts in Excel
- create and use labels and names in a workbook
- protect data in worksheets and workbooks
- create summaries in your spreadsheets using subtotals
- use data linking to create more efficient workbooks
- use the Data Consolidation feature to combine data from several workbooks into one
- understand and create simple PivotTable reports
- construct and operate PivotTables using some of the more advanced techniques
- create and edit a PivotChart
- use goal seeking to determine the values required to reach a desired result
- group cells and use outlines to manipulate the worksheet
- use Solver to solve more complex and intricate problems
- create recorded macros in Excel
- use the macro recorder to create a variety of macros
Testimonials
Aparna S
Project Management | Program Management | Service Delivery | Telecom | Cloud Tech | CSM | ITIL V3 | SIX SIGMA | PROJECT MANAGER @ NOKIAAt last I completed PMP exam Today. Almost took 4 weeks in completing PMP. My sincere thanks to Mr. Chandramouli sir and Mr. Prasanth, for all the mentoring, tips and tricks.
Few suggestions based on my PMP experience for whoever preparing the exam,
1. 100% questions are scenario based but be aware of process .
2. Refer PMP PMBOK guide
3.Go through itechgurus recording for more insights,roles of PM
4.Use his strategy to read the questions
5.Strongly advice to take 2 breaks
6.Flag for doubtful questions and clear in the end
7.Stay calm and focused
Let me know for any support
Thanks
Rajkumar K
Project Manager @ Avant-Garde Systems & Control Pvt LtdDear PMP Aspirants & Itechgurus,
Glad to inform that I have passed the PMP Exam today , taken my exam at Pearson Vue
Special thanks to Mr Chandramouli sir, My co aspirants and Itechguru team to make it possible on my journey towards PMP certification
Thank u all 🙏
Sai Nishitha Guthi Rajendran
Deputy Manager-Projects @ VA Tech WABAG LtdSuccessfully completed my PMP certification. Thanks for your support and wishes.
Satheeshkumar Vijayakumar
Technical / Solution Architect @ Disney ParksI am so lucky to be part of Dr. Mouli sir training sessions. He explained every concept in much detailed way with simple examples. He has come up with very good cross industrial experience. Cleared all the doubts through out the sessions of all trainees. Thanks to Prashant sir for well collaboration with all members.
Sumitha Shabarish
Senior Financial Analyst @ HP IncSuccessfully completed my PMP. Thank you for your support Mr. Prasanth and Special thanks to my mentor Dr. Mouli
Srimathi Manoj Kumar
AVP-HR Operations @ Standard Chartered BankHappy to inform, I have just cleared the exam sir, thankyou for all the coaching and support. I was part of the PMP training at itechgurus. It was a great learning experience. Our trainer Mr Vasu Rao was simply superb. He has an in depth knowledge on the topic and his doubt clearing skills were excellent. Thank you ItechGurus and thank you Mr Vasu Rao for such an exhaustive training.
Trainers and Consultants
Manickavel Arumugam
Project Management Consultant
Highlights: ✪ About 23 years of experience in construction, with emphasis on Project Management & Site Control...
Venkatramvasi
Chief Knowledge Officer
Experienced in AS/400 (RPG III, RPG IV,CL), Synon/2E Training Experienced in ISO audits PMI Volunteer...
Chandramouli S
Digital Leader
My vast experience includes Program management, corporate and Project governance, customer relationship management,...
Shriram Kumar
Sr.Delivery Mgr
Experienced Project Manager with a demonstrated history of working in the information technology and services...
Mohamed Noordeen
Lead Data Scientist
I am an aspiring candidate with ardent desire to excel in my position where ever and whatever I am...
Shriram Venkat Peddhibhotla
Executive Manager
Executive Manager (Process Excellence & PMO) at Deloitte US India Offices
Sanjay kumar
SixSigma & Agile Coach
Having 13+ years of work experience in Software & Multidisciplinary Global R&D projects, and Industrial work experience...
Karthick D
AIML & Excel Coach
An accomplished, results driven professional with almost 16 years of experience in professional services...