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
Durgesh Khode
Project Manager @ Hitachi EnergyI Passed PMP exam in first attempt. Special thanks to Mr. Mouli Sir for this excellent in depth knowledge & Crystal clear thoughts.
Also extend my thanks to Mr. Prasanth of itechgurus for supporting throughtout the journey.
Murugan K
Manager @ Jai Info TechnologyHi All, I have Passed my PMP exam today. Special Thanks to Mr. Chandramouli Sir. Attended online exam and also thank Mr. Prasanth who properly guide me last few days to clear the exam. Target Achieved. Thanks
Noor Mohammed
Project Manager HVAC @ Almuftah Contracting CompanyHi Prasanth, I Cleared my PMP. Thank you for your support.
Geetha Marisamy
Team Lead @ StraiveHi All, I have passed my PMP exam today. @itechgurus, Chandramouli Sir - thank you so much for your guidance. Majority of the questions were senario based and none of the questions required diagrams or calculations. I took the exam from PearsonVUE center. All the best for everyone who are going to take the exam.
Nitin Khandbhor
Deputy Manager - Purchase @ Mahindra & MahindraPass my PMP exam. Thankyou for your support Mr. Prasanth.
Palas Baral
Senior Project Manager @ Synamedia India Pvt LtdHi All, I have passed PMP exam yesterday.
@Mouli, thanks a ton for your guidance.. @Fellow student, the exam was taken from home very smoothly and there was none of the questions which required diagrams or drawings. May be a different set might have very nominal scriptings or drawings requirements but I am sure you can manage with the white board provided by OnVenue apps. You can definitely opt for giving the exam from home if you have a good uninterrupted net connection and a silent place! All the best!
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...