Microsoft Excel - Beginner to Master Level
4.7( 11 REVIEWS )
2013 STUDENTS
£199.00
Course Curriculum
| Microsoft Excel: Basic Level | |||
| Introduction to Microsoft Excel | |||
| 0101 Touring the interface | 00:03:00 | ||
| 0102 Enter data & saving workbook | 00:04:00 | ||
| 0103 Applying Formulas | 00:03:00 | ||
| 0104 Changing a worksheet’s structure | 00:04:00 | ||
| 0105 Find, Replace & Spell Check | 00:03:00 | ||
| 0106 Applying fonts, background colors, and borders | 00:05:00 | ||
| 0107 Formatting numbers and dates | 00:04:00 | ||
| 0108 Making the pieces fit | 00:04:00 | ||
| 0109 Inserting headers & footers and Repeating Rows | 00:02:00 | ||
| 0110 Managing Large Workbooks | 00:05:00 | ||
| Microsoft Excel: Intermediate Level | |||
| Excel Essentials | |||
| 0201 Formula Writing (Don’t Miss This) | 00:08:00 | ||
| Ex 0201 Formula Writing (Don’t Miss This) | 00:02:00 | ||
| Sum Count Average Functionality - With Conditions | |||
| 0301 SumIf & SumIfs | 00:24:00 | ||
| Ex 0301 SumIf & SumIfs | 00:08:00 | ||
| 0302 Count Functions | 00:08:00 | ||
| Ex 0302 Count Functions | 00:02:00 | ||
| 0303 AverageIf & AverageIfs | 00:03:00 | ||
| Ex 0303 AverageIf & AverageIfs | 00:03:00 | ||
| Text Functions - Manipulating Text | |||
| 0401 Change Case (Upper, Lower, Proper) | 00:04:00 | ||
| Ex 0401 Change Case (Upper, Lower, Proper) | 00:03:00 | ||
| 0402 Separating Text on Symmetrical Data | 00:06:00 | ||
| Ex 0402 Separating Text on Symmetrical Data | 00:06:00 | ||
| 0403 Separating Text on Non-Symmetrical Data | 00:08:00 | ||
| Ex 0403 Separating Text on Non-Symmetrical Data | 00:05:00 | ||
| Logical Functions - Working With Conditions | |||
| 0501 If Functionality | 00:04:00 | ||
| Ex 0501 IF Functionality | 00:03:00 | ||
| 0502 If with AND | 00:05:00 | ||
| Ex 0502 If with AND | 00:03:00 | ||
| 0503 If with OR | 00:03:00 | ||
| Ex 0503 If with OR | 00:03:00 | ||
| 0504 If with “AND” & “OR” / IF with Countif | 00:08:00 | ||
| Ex 0504 If with “AND” & “OR” / IF with Countif | 00:04:00 | ||
| 0505 Nested IF (A Genie with 3 wishes) | 00:13:00 | ||
| Ex 0505 Nested IF (A Genie with 3 wishes) | 00:05:00 | ||
| Lookup Functionality - Burn Simple Find Technique | |||
| 0601 Vlookup (Exact Match) # 1 | 00:23:00 | ||
| Ex 0601 Vlookup (Exact Match) # 1 | 00:04:00 | ||
| 0602 Type of References (Use of $ sign) | 00:11:00 | ||
| 0603 Vlookup (Exact Match) # 2 | 00:04:00 | ||
| Ex 0603 Vlookup (Exact Match) # 2 | 00:06:00 | ||
| 0604 Double Vlookup | 00:11:00 | ||
| Ex 0604 Double Vlookup | 00:10:00 | ||
| 0605 Vlookup on Duplicate Values | 00:10:00 | ||
| Ex 0605 Vlookup on Duplicate Values | 00:05:00 | ||
| 0606 Vlookup (Approximate Match) | 00:08:00 | ||
| Ex 0606 Vlookup (Approximate Match) | 00:02:00 | ||
| 0607 Vlookup with If (Conditional Vlookup) | 00:05:00 | ||
| Ex 0607 Vlookup with If (Conditional Vlookup) | 00:02:00 | ||
| 0608 Hlookup (Exact Match) | 00:03:00 | ||
| Ex 0608 Hlookup (Exact Match) | 00:03:00 | ||
| 0609 Hlookup (Approximate Match) | 00:02:00 | ||
| Ex 0609 Hlookup (Approximate Match) | 00:02:00 | ||
| 0610 Lookup (Don’t use this !) | 00:05:00 | ||
| Ex 0610 Lookup (Don’t use this !) | 00:02:00 | ||
| 0611 Vlookup with Match (Create Magical Vlookup) | 00:14:00 | ||
| Ex 0611 Vlookup with Match (Create Magical Vlookup) | 00:05:00 | ||
| 0612 Match (Gives us Column/Row Index #) | 00:03:00 | ||
| Ex 0612 Match (Gives us Column/Row Index #) | 00:03:00 | ||
| 0613 Index & Match (Made for Each Other) | 00:11:00 | ||
| Ex 0613 (1) Index & Match (Made for Each Other) | 00:05:00 | ||
| Ex 0613 (2) Index & Match (Made for Each Other) | 00:03:00 | ||
| Date & Time Function - A Tricky Game | |||
| 0701 How Excel Records Date & Time | 00:02:00 | ||
| 0702 Now, Today & Autofill | 00:02:00 | ||
| 0703 DateValue & TimeValue | 00:02:00 | ||
| 0704 Calculate WorkingDays | 00:03:00 | ||
| 0705 DatedIf | 00:05:00 | ||
| Financial Functions | |||
| 0801 Loan Calculation (PMT, PPMT, IPMT etc.) | 00:12:00 | ||
| Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) | 00:07:00 | ||
| 0802 Creating a Loan Table | 00:09:00 | ||
| Ex 0802 Creating a Loan Table | 00:06:00 | ||
| 0803 Calculate Depriciation | 00:02:00 | ||
| Ex 0803 Calculate Depriciation | 00:02:00 | ||
| Sort & Filter | |||
| 0901 Basic Sorting & Shortcut keys | 00:16:00 | ||
| Ex 0901 Basic Sorting & Shortcut keys | 00:06:00 | ||
| 0902 Sorting Using Custom List | 00:08:00 | ||
| Ex 0902 Sorting Using Custom List | 00:02:00 | ||
| 0903 Horizontal Sorting | 00:01:00 | ||
| Ex 0903 Horizontal Sorting | 00:01:00 | ||
| 0904 Basic Filter & Shortcut Keys | 00:09:00 | ||
| Ex 0904 Basic Filter & Shortcut Keys | 00:00:00 | ||
| 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) | 00:06:00 | ||
| Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) | 00:03:00 | ||
| 0906 Filter Problem # 2 (Pasting Values on Filtered Data) | 00:07:00 | ||
| Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) | 00:02:00 | ||
| 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) | 00:07:00 | ||
| Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) | 00:01:00 | ||
| 0908 Advanced Filter (Applying Complex Criteria’s) | 00:13:00 | ||
| Ex 0908 Advanced Filter (Applying Complex Criteria’s) | 00:05:00 | ||
| Microsoft Excel: Advanced Level | |||
| Excel Charts - Visual Presentation | |||
| 1001 How to create a chart | 00:06:00 | ||
| 1002 Format Axis | 00:02:00 | ||
| 1003 Plot Values on Secondary Axis | 00:04:00 | ||
| 1004 Life of Pie (Charts) | 00:03:00 | ||
| 1005 How to Show Axis Title | 00:02:00 | ||
| 1006 How to Show Data Label | 00:02:00 | ||
| 1007 Show data with chart in Data Table | 00:02:00 | ||
| 1008 Column Chart | 00:02:00 | ||
| 1009 Bar Chart | 00:01:00 | ||
| 1010 Line Chart 1 | 00:03:00 | ||
| 1011 Line Chart 2 | 00:02:00 | ||
| 1012 Area Chart | 00:01:00 | ||
| 1013 Pie Chart | 00:02:00 | ||
| 1014 Pie of Pie or Bar of Pie | 00:02:00 | ||
| 1015 Line Chart with Log Scale | 00:02:00 | ||
| 1016 Bubble Chart | 00:01:00 | ||
| 1017 Selecting Chart Elements | 00:05:00 | ||
| 1018 Use of Format Dialog box | 00:03:00 | ||
| 1019 Modifying Chart & Plot Area | 00:04:00 | ||
| 1020 Modifying Data Series | 00:02:00 | ||
| 1021 How to handle Missing Data | 00:04:00 | ||
| 1022 Modifying 3-D Charts | 00:03:00 | ||
| 1023 Creating Combination of upto 5 Different Charts | 00:03:00 | ||
| 1025 Creating Picture Charts | 00:02:00 | ||
| Data Consolidation - Multiple WorkBooks WorkSheets | |||
| Consolidate Data using Excel Inbuilt Function | 00:06:00 | ||
| Ex Consolidate Data using Excel Inbuilt Function | 00:03:00 | ||
| Data Validation | |||
| 1201 Applying Data Validation | 00:13:00 | ||
| Ex 1201 Applying Data Validation | 00:05:00 | ||
| 1202 Dependent Dropdown List | 00:07:00 | ||
| Ex1202 Dependent Dropdown List | 00:05:00 | ||
| Using Data Validation with Vlookup & Match | 00:05:00 | ||
| Other Data Validation Examples | 00:10:00 | ||
| Protection of Worksheet Workbook | |||
| 1301 Worksheet Level Protection | 00:01:00 | ||
| Ex 1301 Worksheet Level Protection | 00:01:00 | ||
| 1302 Cell Level Protection | 00:05:00 | ||
| Ex 1302 Cell Level Protection | 00:02:00 | ||
| 1303 Hiding Formulas from Formula Bar | 00:03:00 | ||
| Ex 1303 Hiding Formulas from Formula Bar | 00:02:00 | ||
| 1304 Protecting Workbook Structure | 00:01:00 | ||
| Ex 1304 Protecting Workbook Structure | 00:01:00 | ||
| 1305 Workbook Level Protection | 00:02:00 | ||
| Ex 1305 Workbook Level Protection | 00:01:00 | ||
| Pivot Table & Techniques | |||
| 1401 Understanding pivot Table | 00:12:00 | ||
| 1402 Using Pivot Table in Real Scenario | 00:10:00 | ||
| Ex 1402 Using Pivot Table in Real Scenario | 00:09:00 | ||
| 1403 Grouping in Pivot Table | 00:04:00 | ||
| Ex 1403 Grouping in Pivot Table | 00:01:00 | ||
| 1404 Using Slicers (A Visually attractive Filter) | 00:03:00 | ||
| Ex 1404 Using Slicers (A Visually attractive Filter) | 00:01:00 | ||
| What-If Analysis & Solver Add-In | |||
| 1501 Goal Seek (A Reverse Approach) | 00:04:00 | ||
| Ex 1501 Goal Seek (A Reverse Approach) | 00:02:00 | ||
| 1502 One Way Data Table | 00:03:00 | ||
| 1503 Two Way Data Table | 00:02:00 | ||
| 1504 Scenario Manager | 00:04:00 | ||
| 1505 Solver Add-In | 00:07:00 | ||
| Automation in Excel - Macros | |||
| 1601 Record your first Macro | 00:15:00 | ||
| 1602 Record Another Macro | 00:02:00 | ||
| 1603 Assigning macro to a Shape, Button, Picture etc | 00:02:00 | ||
| 1604 Editing or Deleting a Macro | 00:03:00 | ||
| 1605 Security Settings of a Macro | 00:02:00 | ||
| Supplementary Resources | |||
| Supplementary Resources – Microsoft Excel – Beginner To Master Level | 00:00:00 | ||
| Assessment | |||
| Assessment – Microsoft Excel – Beginner to Master Level | 00:10:00 | ||
| Obtain Your Certificate | |||
| Order Your Endorsed Certificate of Achievement | 00:00:00 | ||
| Get Your Insurance Now | |||
| Get Your Insurance Now | 00:00:00 | ||
| Feedback | |||
| Feedback | 00:00:00 | ||