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
Pattan Anshar
Project Lead @ TCSFinished my PMP. Thank you for your support Mr. Prasanth.
Seema S R
Project Manager @ Robert BoschHi Prasanth, I have cleared my PMP Exam. Questions are hybrid. Exam difficulty level is moderate. Thank you for your support.
Govind Mane
Senior Network Engineer @ Avaya India Pvt LtdHi iTechgurus, I have Cleared PMP exam yesterday and got a certificate, Thank you very much.
Shankar Raja S
Business Analyst @ Wipro TechnologiesHi Prashant, Cleared my PMP. Thank you so much, It's all due to Ramanan sir's mentorship.
Bhaskar Raja Sundaram
Global-TLS Business Partner and Program ManagerHi Ramanan, Mouli and Prashant. Without your help and guidance I would have not able to clear this exam. Thanks for all the support and help.
Sridharan Shanmugam
Senior Professional Service Delivery Coordinator @ DXC TechnologyI have cleared my PMP exam today - 3AT's. Thank your for your guidance Mr. Prasanth & Mr. Ramanan Karthikeyan (RK).
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...