- Course Details
MITCON e-school’s Advance Microsoft Excel course aims to impart expert training for aspirants to enhance their office productivity skills. After pursuing this course, students will know how to optimize and analyze data using Pivot table, functions, charts and MACRO. Alongside, there’ll learn some of the advance skillsets using logic function, math, statistics, text function and organize data by filtering and sorting. We also shed light on implementation of Pivot tables and MACRO functions for intelligent data projection.
Duration: 20 days
- Course Syllabus
This module briefs you about the various operators used in MS Excel along with revising about the basics of MS Excel.
- Presenting Data Using Charts
This module comprises ways of representing data using charts especially graphically. You learn to create and enhance, explore toolbar, create multiple chart – primary, secondary, trend line charting and dynamic.
- Conditional Formatting
This module covers customising the quick access toolbar along with application of conditional formatting. Furthermore, topics like sort (ascending, descending), font colour, mall filters, conditional formatting, etc., are covered.
- Data Validation and Name Manager
This module consists of Data Validation wherein we cover basic tips while working on data, freezing panes, data sorting, data filtering, charts, tables and viewing options. This is complemented by name range, name constant and name manager.
- Text and Logical Functions
This module comprises of text functions like substitute, concatenate, clean, char, code, search, find, replace, etc., along with logical functions like And, Or, If, Iferror, Not and Nested If.
- Date and Time Functions
This module emphasises on various functions namely day, date, month, year, Edate, Workday, weekday, etc.
- Lookup and Other Useful Functions
Past link, past special, VLookup, HLookup, match, index, offset, column, row, choose, array concept, indirect, etc., are the some the primary functions we cover. Also, we help you write function using VBA editor, call function in other workbook and focus on relative, absolute macros.
- Pivot Tables
This module starts with creating a pivot table, followed by adding data to the table. We also teach you to filter the data of pivot table, change the data, analyse its column, and adjustment of data.
- What If Analysis
While elaborating this module, we teach by creating scenarios followed by scenario management and goal seeking.
In this module we shed light on macros starting with its introduction, definition and use. We teach you to record a macro, assign and run a macro. We also introduce you to VBA program and teach you ways to store a macro.
We give assignments to student which helps them to map their abilities. With this, we also determine their strengths and areas that need improvement.
- Who should attend?
- 10th and 12th pass outs
- Undergraduates, graduates and post graduates
- Job seekers
- Corporate employees
Q: What are the pre-requisites to pursue this course?
A: An aspirant should boast basic computer knowledge along with Microsoft Office.
Q: What are the career opportunities after pursuing this course?
A: You can work as:
- Data Analyst
- Excel Analyst
- Business Analyst
- MIS Executive
- Research Analyst
- Reporting Analyst
Q: How can I get enough practice while pursuing this course?
A: We provide you data to practice and also for creation of dashboard. Most importantly, we have live projects that give you hands-on experience.
Q: What if I have queries post completion of my course?
A: At MITCON e-school, we provide forum support and course-completion support so that our students do not lag behind.
Q: Do I get placement assistance?
A: Yes, we do provide placement assistance by conducting mock interviews to get employed sooner.
- Why Us?
We believe in giving hands-on experience and so we have industry projects that help you work on real-life scenario. Furthermore, MITCON e-school’s course is equipped with assignments, assessments, questionnaire that help for the overall development of the aspirant. We also provide certification after completion of course because boosts employability and experience of the student as well as of corporate. As we have documented our course efficiently – all latest trends are covered, thus keeping it updated. We make sure our students get employed!