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
Course Introduction Presentation
Download
Course Introduction.pptx
Complete and Continue