This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Basic and Advanced MS Excel
Week 1: Introduction to MS Excel Window
Course Introduction Presentation
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
Week 5: Focusing on Specific Data
Limiting the Data That Appears Based on Certain Criteria (4:43)
Selecting Random Rows for Sampling, Research, Lucky Draw etc (4:13)
Summarizing Worksheeet Ignoring or Including Hidden Rows or Unfiltered Rows (3:59)
Finding Unique Rows or Values in Data Sets (0:59)
Validating Data So That Only Data As Per Criteria Is Entered (9:12)
Week 6: Reordering and Summarizing Data
Reordering Data in Worksheets (5:47)
Sorting Based on Customized Lists (6:10)
Organizing and Summarizing Data Into Levels (6:43)
Review Quiz 5
Week 7: Analyzing Data and Using Alternate Data Sets
Analysing Data Using The Quick Analysis Lens (3:44)
Defining an Alternate Data Set for Analysis and Comparison (6:05)
Defining Multiple Alternate Data Sets for Comparing Different Scenarios (4:41)
Performing Sensitivity Analysis Using Data Tables (5:03)
Varying Data to Get Desired Specific Results (3:33)
Finding Mean, Skewness, Kurtosis and Other Descriptive Statistics (5:15)
Week 8: Working with Charts and Graphics
Basics of Creating Charts (3:06)
Customizing the Appearance of Charts (4:34)
Identifying Trends and Making Projections in Data (2:50)
Creating Dual Axis Charts (2:26)
Summarizing Data Using Sparklines (2:41)
Review Quiz 6
Week 9: Creating Dynamic Tables and Charts Through Pivot
Creating and Analyzing Dynamic Tables (5:41)
Filtering, Showing or Hiding Data in Pivot Tables (3:46)
Editing and Restructuring Pivot Tables (3:43)
Creating Dynamic Charts (3:10)
Week 10: Working With Macros
Understanding, Enabling and Examining Macros (4:00)
Creating and Modifying Macros (3:41)
Running a Macro Through Single Button Click (3:00)
Creating a Macro That Runs Whenever a Workbook is Opened (3:19)
Review Quiz 7
Review Quiz 6
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock