Microsoft Excel Learning Course by Simbi Labs India

  Why to Learn MS Excel

Learning MS Excel is an excellent skill to have for getting a job because it is one of the most widely used software applications in the business world. The ability to use Excel to organize, analyze, and present data is essential in many industries, including finance, accounting, marketing, and data analysis. Here are some reasons why learning MS Excel can be beneficial in getting a job:

1. Increased Productivity: Learning Excel can help you automate repetitive tasks, saving you time and increasing your productivity.

2. Better Data Analysis: Excel provides powerful tools for data analysis, such as pivot tables and charts, which can help you identify trends and patterns in data.

3. Improved Decision Making: By organizing and analyzing data, Excel helps you make informed decisions based on accurate and up-to-date information.

4. Competitive Advantage: Having strong Excel skills can give you a competitive advantage over other job candidates, as many employers require proficiency in Excel for various job roles.

5. Versatility: Excel can be used in a wide range of industries and job roles, making it a valuable skill to have regardless of your career path.

In conclusion, learning MS Excel can be an excellent way to improve your job prospects and increase your value to potential employers. It is a versatile tool that can help you become more productive, make better decisions, and provide you with a competitive edge in the job market.

 

Why Simbi Labs  

We are a Productivity amplification research company focuses on increasing efficiency of an individual & Organization. Our Key Strengths are as Follows.

 Quality Instruction: We have high-quality instruction and well-designed courses. The Courses are taught by experts in their field with up-to-date relevant materials and resources.

Engaging Learning Experience: We provide an engaging learning experience that keeps students motivated and interested. Our courses are interactive, incorporating activities, quizzes, and assessments to ensure that students are learning and retaining the material.

Reliable Technology: We use reliable technology that is easy to use and accessible to students. The learning platform is user-friendly, with clear instructions and technical support available when needed.

Flexibility: Our Online learning programs provide flexibility in terms of course scheduling and completion

Supportive Community: We foster a supportive community of students and instructors. Students should be able to communicate with instructors and peers to ask questions, get feedback, and collaborate on projects.

 

Syllabus – MS Office Excel Foundation

Introduction to Excel: Understanding the Excel interface, workbook, worksheet, and cell basics.

Data Entry and Formatting: Entering data and formatting cells, including font, borders, and alignment.

Mathematical Functions: Using basic mathematical functions such as addition, subtraction, multiplication, and division.

Cell Referencing: Understanding the different types of cells referencing, including absolute referencing and relative referencing.

Functions and Formulas: Learning about Excel functions and formulas, including SUM, AVERAGE, COUNT, and IF.

Tables and Charts: Creating tables and charts to analyze data and present it visually.

Conditional Formatting: Using conditional formatting to highlight specific cells that meet certain criteria.

 

Syllabus – MS Office Excel Advance

Advanced Functions and Formulas: Learning advanced Excel functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, and arrays.

Statistical Functions: Central Tendency, Correlation, Regression, Anova and Others Tests

Data Validation: Using data validation to control the type of data that can be entered into a cell.

Advanced Charting: Creating advanced charts such as combination charts, stacked charts, and sparklines.

What-if Analysis: Using Excel's what-if analysis tools, including Goal Seek, Scenario Manager, and Solver.

Advanced Pivot Tables: Creating advanced pivot tables, including calculated fields, pivot charts, and slicers.

Data Analysis Tools: Using Excel's data analysis tools, including regression analysis, correlation analysis, and histogram analysis.

Macros and VBA: Learning to create macros using VBA (Visual Basic for Applications) to automate complex tasks.

·         Variables in VBA

·         Various Button Groups in VBA

·         Looping in VBA

·         Mail Functions – VBA

 

Course Fees

PARTICULARS	EXCEL FOUNDATION COURSE	ADVANCE EXCEL COURSE	VBA MACRO
Course Duration	15 Hours	30 Hours	30 Hours
Mode Of Program	Live Classes & Webinars	Live Classes & Webinars	Live Classes & Webinars
Study Material	✔	✔	✔
Practice Exercise	✔	✔	✔
Classes on Weekends	✔	✔	✔
Classes on Week Days	✔	✔	✔
Query Sessions	✔	✔	✔
Assessment	✔	✔	✔
Class Reattend option	✔	✔	✔
Self-Paced Learning	✔	✔	✔
Onsite Training (Min. Batch Size 20)	✔	✔	✔
Industrial Simulation Projects	✔	✔	✔
Sample Data	✔	✔	✔
Offline Training (When Conduct)	✔	✔	✔
Certificate	✔	✔	✔
Pass Criteria	Min. 50%	Min. 50%	Min. 50%
Exam Retake	1 Retake	1 Retake	1 Retake
Platform Used	ZWebinar, G-Meet, M-Teams	ZWebinar, G-Meet, M-Teams	ZWebinar, G-Meet, M-Teams
Instructor Profile	Microsoft Certified	Microsoft Certified	Microsoft Certified
Instructor Name	·         Rakesh kharra ·         Megha	·         Rakesh kharra ·         Megha	·         Megha ·         Shyncy
Course Material Accessibility	One Year	One Year	One Year
Course Fee (Inclusive of taxes)	1500 Rs.	5000 Rs.	5000 Rs.
Exam & Certification Fee	300 Rs.	500.	500

*Terms & Conditions Applied

SESSION PLANNING – FOUNDATION EXCEL PROGRAM

 

Session	Topic Covered	Duration	Session Type
Session 0	Orientation & Introduction	1 Hour	Webinar & Virtual Meet
Session 1	Cell Formatting Fonts & Alignments	1 Hour	Webinar & Virtual Meet
Session 2	Number Formatting	1 Hour	Webinar & Virtual Meet
Session 3	Conditional Formatting 1	1 Hour	Webinar & Virtual Meet
Session 4	Conditional Formatting 2	1 Hour	Webinar & Virtual Meet
Session 5	Table Fomatting, Cells & Editing	1 Hour	Webinar & Virtual Meet
Query Session 1	Excercises & Queries	1.5 Hour	Virtual Meet
Session 6	Formulas-Text	1 Hour	Webinar & Virtual Meet
Session 7	Formulas Date, Time & Information	1 Hour	Webinar & Virtual Meet
Session 8	Formulas Mathamatics	1 Hour	Webinar & Virtual Meet
Session 9	Data Validation	1 Hour	Webinar & Virtual Meet
Session 10	Excel Sheet and Table Designing	1 Hour	Webinar & Virtual Meet
Query Session 2	Excercises & Queries	1.5 Hour	Virtual Meet
Session 11	Charts	1 Hour	Webinar & Virtual Meet
Session 12	Pivot Tables	1 Hour	Webinar & Virtual Meet
Session 13	Excel With AI Tools	1 Hour	Webinar & Virtual Meet
Session 14	Data Analysis	1 Hour	Webinar & Virtual Meet
Session 15	Excel With Google Sheet	1 Hour	Webinar & Virtual Meet
Query Session 3	Exercises & Queries	1.5 Hour	Virtual Meet

 

SESSION PLANNING – ADVANCE EXCEL PROGRAM

 

Session	Topic Covered	Duration	Session Type
Session 0	Orientation & Introduction	1 Hour	Webinar & Virtual Meet
Session 1	Advance Conditional Formatting	1 Hour	Webinar & Virtual Meet
Session 2	Advance Data Formatting	1 Hour	Webinar & Virtual Meet
Session 3	Advance Data Validation	1 Hour	Webinar & Virtual Meet
Session 4	Lookup Functions	1 Hour	Webinar & Virtual Meet
Session 5	Advance Formulas	1 Hour	Webinar & Virtual Meet
Query Session 1	Exercises & Queries	1.5 Hour	Virtual Meet
Session 6	Advance Formulas	1 Hour	Webinar & Virtual Meet
Session 7	Advance Formulas	1 Hour	Webinar & Virtual Meet
Session 8	Advance Charts	1 Hour	Webinar & Virtual Meet
Session 9	Advance Dash Board	1 Hour	Webinar & Virtual Meet
Session 10	Advance Dash Board	1 Hour	Webinar & Virtual Meet
Query Session 2	Exercises & Queries	1.5 Hour	Virtual Meet
Session 11	Advance Pivot Tables	1 Hour	Webinar & Virtual Meet
Session 12	Advance Pivot Tables	1 Hour	Webinar & Virtual Meet
Session 13	Statistical Functions	1 Hour	Webinar & Virtual Meet
Session 14	Data Analysis	1 Hour	Webinar & Virtual Meet
Session 15	Data Analysis	1 Hour	Webinar & Virtual Meet
Query Session 3	Exercises & Queries	1.5 Hour	Virtual Meet
Session 16	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 17	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 18	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 19	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 20	Case Study-1	1 Hour	Webinar & Virtual Meet
Query Session 4	Exercises & Queries	1.5 Hour	Virtual Meet
Session 21	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 22	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 23	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 24	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 25	Case Study-2	1 Hour	Webinar & Virtual Meet
Query Session 5	Exercises & Queries	1.5 Hour	Virtual Meet
Session 26	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 27	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 28	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 29	VBA Macro	1 Hour	Webinar & Virtual Meet
Session 30	Case Study-3	1 Hour	Webinar & Virtual Meet
Query Session 6	Exercises & Queries	1.5 Hour	Virtual Meet

 

For Any Queries Related to Course, Sessions, Timings, Orientation Please Call at the Following Number. +91-99505-66669