Master the basics and advanced features of MS Excel to effectively apply them in your daily tasks.This Microsoft Excel Training will give you an overview of working with the powerful spreadsheet application Excel. This includes creating dashboards, interactive components, data consolidation and debugging. This Training is useful for working on financial, mathematical and statistical data processing.
Anybody wishing to be an expert in MS Excel can take up this Training Course.
Microsoft Excel is being used by almost all companies today. By taking this Training Course you will be able to work effortlessly with data, be it financial, accounting, statistical or other data related to sales and marketing. You will be able to process data and gain valuable insights using various formulae, functions, graphs and charts. This will help you get a good job in a company of your choice for a competitive pay scale.
Topics: Understanding the concepts of Entering data, Fill A Series, Custom Fill List and its creation, Editing a Custom Fill List, Deletion of Custom Fill List
Topics: Concept of Absolute and Relative Referencing, Relative Formulas, Identifying Issuesi n Relative Formulas, How to create Absolute References?, How to create Mixed References?, Learning Other formulas
Topics: Generating Names for a range, Names usage in New Formulas, Using the Name Box, Names for Selecting Ranges, Names Pasting in Formulas, Names from a Selection, Working with Name Manager
Topics: Introduction to Logical Functions, IF to Display Text, IF to Calculate Values, IF Nested Functions, IFERROR, AND, OR, VLOOKUP, Multiple VLOOKUPs
Topics: Valued Cell Formatting, Removing Conditional Formatting, More Options for Formatting Cells, Ten Items – Top and Bottom, Performing operations with Data Bars, Icon Sets and Color Scales, Sparklines Creation, Modifying Sparklines
Topics: Cell Drop Down, Value Restriction from List Only, Error Messages, Creating dependent
Topics: Sum, SumIF & SumIFs, Count, CountA, CountIF and CountBlank, Networkdays, Networkdays International, Today & Now function, Trim (Eliminating undesirable spaces), Concatenate (Consolidating columns)
Topics: Data Conversion into Table, Understanding automation calculation in Table, Table Conversion in Normal Range, Tables for Charts and VLOOKUP
Topics: Overview of Lists, Alphabetical Sorting, Numerical Sorting, Multiple Column Sorting, Row Sorting, Using Subtotal, Concept of Paste Special, Applying Hyperlink
Topics: Concept of Filtering, How to implement and use a Filter, Removing a filter, Concept of Compound Filters and their creation, What are Multiple Value Filters?, Custom Filters, Use of Wildcards
Topics: Electing the chart type, Creating a New Chart, Performing operations on an Embedded chart, Chart Resizing, Chart Dragging, Modifying the type of a chart
Topics: Chart Title, Axes Titles, Legend Positioning, Introduction to Data Labels, Displaying Data Table, Axes Modification, Displaying Gridlines, Inserting a Trendline, Inserting a textbox in a chart, Combination Chart and its creation, Constructing a 2-Axis chart
Topics: What are Pivot Tables?, Shell Creation, Filed drop in Pivot table, Report filtering, Report Filter Clearance, Performing calculations in Pivot, Report formatting, Assigning dynamic range, What are Slicers?, Creation of slicers
Topics: Modifying the file password, Protecting sheet, Safeguarding file from getting deleted, Cell, Row and Column Protection, Preserving data from copying
Topics: Execute and Record Macros, How to create button to execute the macro, Shortcuts for macro, Delete Macros, What is relative reference in Macros?
Topics: Understanding Excel VBA Editor, Insert and Remove Modules, What are Sub and End Sub?
Topics: Protection of Macro Codes, Concept of Workbooks and Worksheets, What is Ranges coding?, Variable declaration, What are Arrays?, VBA Pivot Tables, User Forms, Working with Databases
Topics: Applying IF condition, Multiple IFs in Macro
Topics: Looping, Using loops in VBA Macros
Topics: Module Backup, Debug Code and marking break points, Code Commenting
Topics: Creating a Message Box, Types of Message boxes, IF Condition
Topics: Report formatting, Auto filter and Data separation, Merging multiple sheets into one, Merging multiple files into one
Topics: What are Excel Dashboards?, Points to consider during Dashboard designing, How to build Excel Dashboards?
Topics: Different types of Charts, Update and Format charts, Create and Personalize Excel Charts, Special Charts for Excel Dashboards, Selecting the appropriate Charts according to data
Topics: Pivot Tables and their Creation, Change in Pivot table layout, Generate Reports, How to group and ungroup data?
Topics: Dos and Don’ts in a Dashboard, How to create Dynamic Dashboards and understand data layout, Thermometer Chart and its creation, Use of Alerts in dashboards
Topics: How to insert a Scroll bar to a data window?, Concept of Option buttons in a chart, Use of combo box drop-down, List box control Usage, How to use Checkbox Control?
Topics: What are Data Quality issues?, Data linking in Excel, How to consolidate and mergedata, Use of Dashboards for Excel Pivot Tables
Project – if Function
Data – Employee
Problem Statement – It describes about if function and how to implement this if function. It includes following actions:
Topics: Calculates Bonus for all employee at 10% of their salary using if Function, Rate the salesman based on the sales and the rating scale., Find the number of times “3” is repeated in the table and find the number of values greater than 5 using Count Function, Uses of Operators and nested if function
In Intellipaat self-paced training program you will receive recorded sessions, course material, Quiz,related software’s and assignments.The courses are designed such that you will get real world exposure and focused on clearing relevant certification exam. After completion of training you can take quiz which enable you to check your knowledge and enables you to clear relevant certification at higher marks/grade also you will be able to work on the technology independently.
In Self-paced courses trainer is not available whereas in Online training trainer will be available for answering queries at the same time. In self-paced course we provide email support for doubt clearance or any query related to training also if you face some unexpected challenges we will arrange live class with trainer.
All Courses are highly interactive to provide good exposure. You can learn at your own place and at your leisure time. Prices of self-paced is training is 75% cheaper than online training. You will have lifetime access hence you can refer it anytime during your project work or job.
Yes, at the top of the page of course details you can see sample videos.
As soon as you enroll to the course, your LMS (The Learning Management System) Access will be Functional. You will immediately get access to our course content in the form of a complete set of previous class recordings, PPTs, PDFs, assignments and access to our 24×7 support team. You can start learning right away.
24/7 access to video tutorials and Email Support along with online interactive session support with trainer for issue resolving.
Yes, You can pay difference amount between Online training and Self-paced course and you can be enrolled in next online training batch.
Yes, we will provide you the links of the software to download which are open source and for proprietary tools we will provide you trail version if available.
Please send an email . You can also chat with us to get an instant solution.
Intellipaat verified certificates will be awarded based on successful completion of course projects. There are set of quizzes after each couse module that you need to go through . After successful submission, official Intellipaat verified certificate will be given to you.
Towards the end of the Course, you will have to work on a Training project. This will help you understand how the different components of course are related to each other.
Classes are conducted via LIVE Video Streaming, where you get a chance to meet the instructor by speaking, chatting and sharing your screen. You will always have the access to videos and PPT. This would give you a clear insight about how the classes are conducted, quality of instructors and the level of Interaction in the Class.
Yes, We do keep launching multiple offers, please see offer page.
We will help you with the issue and doubts regarding the course. You can attempt the quiz again.
At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate. Become in demand with Intellipaat certifications
No Reviews found for this course.
You will get Lifetime access to high quality interactive tutorials along with life time access to complete Course Material .There will be 24/7 access to video tutorials with email support. If you stuck in any unexpected problem we will provide online interactive sessions with trainer for issue resolving.
We provide 24X7 support by email for issues or doubts clearance for Self-paced training.
In online Instructor led training, trainer will be available to help you out with your queries regarding the course. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.
At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org