COURSE DESCRIPTION
Microsoft’s iconic spreadsheet application Excel is the most widely used office application globally across industries in every sector.One doesn’t get to know the utility of the application before one lands to a workplace.It is a bread and butter application in any desk job. Industries in all sectors of economy use it as a multipurpose analyses application. All job profiles demand MS Excel skills. Big companies hire consultants to model their business in excel.
Trying to learn Intermediate proficiency excel to advanced level business analysis in excel without an ideal beginning is just like trying to build a multi-storeyed building on a shaky foundation.
If you lack Basic Foundation skills in MS Excel, then you can’t make the best out of advanced features, no matter who you are & for how long you have been working on excel.
Professionals spend their years searching PIECEMEAL KNOWLEDGE on GOOGLE & YOUTUBE for help whenever they get stuck & this then becomes a habit that keeps from reaching their potential, giving them a feeling each time that “Excel is vastly difficult with so many unknown features”!This happens because they have made it a habit to see only the “Tip of the iceberg”(i.e. 20%) without actually caring for the “submerged basics/foundation”(i.e. 80%) of this greatest ever productivity tool MS excel.
This course gives an unbelievably engaging introduction, to the young students, undergrads./ wannabe professionals, budding entrepreneurs & everyone else interested, to grasp the solid foundation skills to prepare you for using the application better than 95% of Indian users.
CERTIFICATE OF COMPLETION
Once you complete the lessons and quizzes at this level, you can download and share your certificates at different platforms. You have 6 weeks to complete once you enroll.
LEARNING OUTCOMES
- 70+ lectures and 8 hours of content!
- Quizzes at the end of each section to test your learning.
- Practical learning experience by way of steps demonstration in the form of video lessons.
- Best suitable for BEGINNERS who learn faster when demonstrated.
- Course content designed by considering current Excel versions and the job market.
- Practical learning experience with examples.
For progressing to higher levels, take the subsequent courses ONLY in recommended order:
INTERMEDIATE PROFICIENCY LEVEL EXCEL (L2) – Coming Soon
ADVANCED ANALYTICAL LEVEL EXCEL (L3) – Coming Soon
MACROS & VBA PROGRAMMING LEVEL EXCEL (L4) – Coming Soon
Course Features
- Lectures 75
- Quizzes 12
- Duration 8 hours
- Skill level All levels
- Language English
- Students 90
- Certificate Yes
- Assessments Yes
Curriculum
- 14 Sections
- 75 Lessons
- 6 Weeks
- Introduction to course2
- Excel interface & elements7
- Workbook structure & navigation5
- Working with cell values & variable formatting6
- 5.1Entering, Modifying & Deleting Cell Values & Partial Selection6 Minutes
- 5.2Variable Formats-Default, Number, Currency, Accounting ,%age6 Minutes
- 5.3Variable Formats-Fraction, Date, Time, Scientific4 Minutes
- 5.4Variable Formats-Special, Custom, Text6 Minutes
- 5.5Variable Formats-Within Format subformats4 Minutes
- 5.6Quiz#412 Minutes6 Questions
- The Autofills7
- Selection methods3
- Worksheets & navigation11
- 8.1Worksheets Tab Naming & Coloring5 Minutes
- 8.2Worksheets Addition3 Minutes
- 8.3Worksheets Deletion & Conditional Recovery3 Minutes
- 8.4Worksheets Copy within & Across files (Part 1 of 3)3 Minutes
- 8.5Worksheets Copy within & Across files (Part 2 of 3)2 Minutes
- 8.6Worksheets Copy within & Across files (Part 3 of 3)4 Minutes
- 8.7Worksheets Movement Within Workbooks3 Minutes
- 8.8Adjacent Worksheets Hide Unhide & Bottom Scroll Bar Adjustment4 Minutes
- 8.9Worksheets Selection & Hide Unhide of Non-Contiguous Sheets3 Minutes
- 8.10Worksheets Movement Across Workbooks4 Minutes
- 8.11Move and Copy Data Within & Across Sheets3 Minutes
- Columns, rows and their navigation5
- Formula,functions & addressing methods11
- 10.1Formula Basics5 Minutes
- 10.2Formulas Tab & Auditing Options5 Minutes
- 10.3Relative Addressing & Absolute Addressing6 Minutes
- 10.4Calculation Rule for Mathematical Operations8 Minutes
- 10.5The SUM() function5 Minutes
- 10.6The COUNT() function3 Minutes
- 10.7The AVERAGE() function3 Minutes
- 10.8The MIN() & MAX() functions5 Minutes
- 10.9Naming Cells6 Minutes
- 10.10Named Ranges for productivity7 Minutes
- 10.11Quiz#812 Minutes6 Questions
- Font formatting, conditional formatting & style6
- Working with illustrations7
- Working with Charts10
- 13.1Introduction to Charts & creating first one4 Minutes
- 13.2Chart Design Tab & Chart Elements5 Minutes
- 13.3Quick Layout,Styles & Data options6 Minutes
- 13.4Using Chart filter & Secondary Axis4 Minutes
- 13.5Chart Element Selection & Formatting Area Window4 Minutes
- 13.6Custom Chart Formatting with Dynamic Titles6 Minutes
- 13.7Custom Chart Color Formatting5 Minutes
- 13.8Moving & Sizing the chart4 Minutes
- 13.9Pie-chart utility & limitations5 Minutes
- 13.10Quiz#114 Minutes2 Questions
- Readying to print.Finally!!6
- 14.1Print Preview Window Settings-Intro6 Minutes
- 14.2Margin Settings5 Minutes
- 14.3Page Orientation & Using Center on page option4 Minutes
- 14.4Repeating Rows or Columns & Understanding Page Order6 Minutes
- 14.5Headers-Footers Formatting, Inserting Page Numbers & other elements4 Minutes
- 14.6Quiz#1210 Minutes5 Questions
- Conclusion1