Call Us Today! +91 99907 48956 | info@analyticstraininghub.com
Microsoft Excel Certification Training in Faridabad
Microsoft Excel is a spreadsheet application and a powerful organizing platform made to minimize the clutter and maximize the value of data. With multinational giants & small to midsize businesses (SMB)’s generating large volumes of data more than ever before, organizations are aggressively looking to hire individuals who are highly skilled in MS Excel. Due to its availability and simplicity, MS Excel has become an essential tool & skill to master. It is the simplest analytics data tool in the market which can be used to host a large volume of data effectively & efficiently.
MS Excel has transformed from a skill to a necessity due to its features of systematic data management. It has untapped potential in many administrative & data management fields which has become the current necessity of almost every firm.
After completing the Advanced MS Excel course your chances of landing a better paying job increase by many folds. The majority of the firms are looking for people with advanced MS Excel skills who can effectively manage the company’s data whether it is business-related or consumer-related.
With the basic schooling of MS Excel gaining knowledge of other analytic data, tools become a lot simpler as the working experience of MS Excel is often considered as the stepping stone for learning & understanding the basics of other data analytics tools like VBA/MACROS, Power BI & Tableau.
Instructor-Led Microsoft Excel Online Training
| Batch Start Date | Class Type | Upcoming Slots | Timings | Location |
|---|---|---|---|---|
| 26th Dec 2020 | Online | Sold Out SAT & SUN (3 WEEKS) | 11:00 PM to 6:30 PM | Faridabad / Online |
| 16th Jan 2021 | Online | Filling Fast⚡ SAT & SUN (3 WEEKS) weekend batch | 10:30 AM to 12:30 PM | Online |
| 6th Feb 2021 | Online | SAT & SUN (3 WEEKS) weekend batch | TBD | Online |
Course Price At
INR 7,080/-
INR 4,720/- incl. of GST
33% off expires in
Can’t find a batch you were looking for?
COURSE DETAILS
Microsoft Excel
- Introduction to Excel 2013/2016/2019/Office 365
- Application Interface and Key Components of Excel
- Navigating Through Excel Ribbon Tabs
- Exploring Important Excel Options*
- Live Session Exercise
- Splitting data of Single Column into multiple
- 10 Examples to use Auto-fill and Flash Fill
- Magics of Go-To Special
- Merge/Unmerge Cells & Wrap Text
- Extracting Unique Values & Important Ribbon, General and Data Entry Keyboard Shortcuts
- Formatting Essentials Introduction
- Custom Cell Number Formats
- Custom Date/Time Formats
- Working with Comments / Notes
- Format Painter – A Quick way to copy ‘Formatting Attribute’
- Paste Special
- Table, Table Styles & Formatting
- Freeze Panes
- Introduction to Excel Functions and Formulas
- Basics of Functions & Formulas
- Working with Cell References Types
- Most Used Basics & Advanced Functions & Formulas
- Working with Array Formulas
- Creating Customize Formulas Step-by-Step with Live examples
- Creating and Working with Dynamic Ranges using Function and Excel Table features
- Formulas Debugging / Formulas Auditing
- Types of Formula Errors / Error Handling Tricks
- Text Functions: – CLEAN, CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, and TEXT etc.
- Date & Time Functions: – DATE, DAYS, TIME, NOW, WEEKNUM, WORKDAY, and WORKDAY.INTL etc.
- Math & Trig Functions: – INT, MOD, ROUND, ROUNDDOWN, SUMIF, SUMIFS, SUMPRODUCT etc.
- Statistical Functions: – AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN, LARGE etc.
- Logical Functions: – IF, IFS, AND, OR, and IFERROR.
- Lookup & Reference Functions: – FORMULATEXT, VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT, and OFFSET
- Newly Introduced Functions in Recent Version of Excel*: – CONCAT, TEXTJOIN, IFS, SWITCH, DGET, UNIQUE, FILTER etc.
- Nested Conditions/Customize Formulas*
- Data Sorting
- Data Filtering
- Named Ranges
- 10 different ways to use Conditional Formatting
- 10 different use of Data Validation
- What-If Analysis
- Introduction to Excel Charts
- Exploring most commonly used Charts and Templates
- Basics of Charts
- Selecting Requirement based Charts
- Working with Basic Charts:
- Creating Customized / Advanced Charts
- Creating Dynamic Chart
- Working with Dynamic Interactive Charts in Excel using Drop Down
- Working with Chart Elements, Formatting, Chart Styles, Properties etc.
- Introduction to Pivot Table
- Creating a Pivot Table
- Use of Calculated Fields/Items
- Pivot Table Formatting
- Grouping Items & Summarizing data in Pivot Tables
- Grouping and Bucketing data in Pivot Table
- Changing/Modifying Data Sources
- Working with Pivot Table Designs & Layouts
- Exploring Important Pivot Table Options & Field Settings
- Pivot Table Filters
- Changing Pivot Table Summary Calculation
- Use of Slicers in Pivot Table
- Using Source Data to Convert into Infographic Summary
- Introduction to Pivot Charts
Features
Instructor-led Sessions
12 Hours / 6 Sessions / 3 Weeks
Per Session for 2 Hours
30 Hours for Assignments
Real-life Case Studies
We have included unlimited real life examples and case studies in our course
Assignments
After completing every session you will get assignments, study material & real life based case studies
100% Job Assistance
You will get 100% Job Assistance from us
Expert Support
We have support team to resolve all your technical queries
Certification
After completing your course, we will provide you certificate of completion.
Student Reviews
FAQ's
ATH is a credible MS-Excel institute that offers the best MS-Excel training to students by covering a range of topics, including Introduction to Excel and Advanced Excel, Freezing Pane, Sorting, Totals, and Subtotals Total, Data Forms, Filtering Data, What if’ analysis, Grouping and outlining data & Many more.
Our faculty members are MNC professionals who have hands-on and real-world experience of working with Excel. Each of our professionals has more than 5 years of teaching experience to ensure students must rest assured that they are getting the best of the best quality education at the right price.
No, you don’t because we offer MS Excel training from beginner to advance level.
As part of the course, learners will get weekly assignments and module-wise case studies. Once they successfully complete all their assignments, we’d evaluate them, and then the certificate shall be awarded.
We provide 100% job assistance with you in the driving seat!
Recommended Courses
Need help? Call our support team 7:00 am to 10:00 pm (IST) at (+91 999-074-8956 | 9650-308-956)