Curriculum
- 14 Sections
- 75 Lessons
- 6 Weeks
Expand all sectionsCollapse all sections
- 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