Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Basics of MS Excel
Week 1: Introduction to MS Excel Window
Understanding the MS Excel Window (8:50)
Understanding the dynamism of MS Excel Menu Ribbon (3:46)
Zoomin in and Zooming out (2:45)
Scrolling Multiple Workbooks Simultaneously (3:46)
Understanding and Modifying The Quick Access Toolbar (3:37)
Customize the Menu Ribbon According To Your Requirements (3:20)
Learn To Change Author Keywords And Other Properties of MS Excel file (2:06)
Modifying and Improving Worksheets (6:28)
Modifying Rows and Columns as Per Requirements (8:03)
Review Quiz 1
Week 2: Basics of Data Entry And Tools For Quick Data Entry
Basics of Data Entry (3:27)
Filling Data Series Automatically (3:36)
Filling special series like skipping weekends, number series with gaps etc (4:17)
Filling data quickly using AutoComplete (2:09)
Filling Data by Picking From Drop Down Lists (1:30)
Filling Same Data In a Range or Selected Cells (1:50)
Filling Data Automatically By Recognizing Patterns of Data Filling (5:18)
Moving Data From One Place to Another (4:52)
Searching Data in Huge Lists (3:11)
Easily Changing Data at Multiple Locations in a File (2:13)
Improving Contents by Checking Spellings, Meanings and Researching (3:26)
Improving Look and Feel of Worksheet by Defining Tables (3:26)
Review Quiz 2
Week 3: Formatting to make interesting looking worksheets
The Basics of formatting (6:27)
Saving and using Preferred formats (3:42)
Copying Formats Quickly (2:56)
Working with Worksheet Themes (2:16)
Number formats like decimals, phone numbers etc (6:12)
Working with date formats (3:59)
Currency Formats and Adding Currency Symbol to Numbers (3:38)
Custom Formats and Adding Suffix to Numbers (3:35)
Beautifying the Worksheet by Adding Images (2:04)
Review Quiz 3
Week 4: Performing Calculations
Basics of Performing Calculations (4:28)
Getting the Total for a Range or Selected Cells (5:23)
Finding Average for a Range or Selected Cells (2:35)
Finding the Largest Value in a Range or Selected Cells (1:29)
Finding the Smallest Value in a Range or Selected Cells (1:13)
Finding the Second, Third or Nth Largest Value in Data (2:02)
Finding the Second, Third, or Nth Smallest Value in Data (1:45)
Counting Cells Containing Numeric Data (2:28)
Counting Cells Containing Any Type of Data (2:13)
Counting Cells with Non-Numeric Data Only (3:15)
Counting Cells That are Blank or Have no Data (1:19)
Absolute, Mixed and Relative Referencing in MS Excel (13:36)
Naming Data Ranges and Cells (7:28)
Using Array Formulas (4:30)
Finding And Correcting Errors (8:54)
Review Quiz 4
Counting Cells Containing Numeric Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock