Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power Excel Training
Introduction
Analyzing Data to Make Business Decisions (1:20)
Introduction to Power Excel Training (2:16)
Function
Future Value Function (4:22)
PMT Function (6:31)
Quick Analysis (1:19)
Rate Function (5:17)
Pivot Tables
Pivot Tables (6:30)
Create Custom Groups in Pivot Table (7:37)
Set Conditional Formatting (5:59)
Set Conditional Formatting Continues (6:53)
Evaluate
Troubleshooting and Enhancing Professional Workbooks (10:52)
Troubleshooting and Enhancing Professional Workbooks Continues (11:11)
Name Range and Data Set (8:31)
Key Performance Indicator (KPI) In Excel (10:59)
Date Forma and Time Format
Analysis Data with Function (0:45)
Date Format (6:13)
Time Format (8:13)
Statement and VLookup
Nested If Statement in Excel (10:27)
Count ifs and Sum ifs in Excel (10:04)
VLookup In Excel (2:12)
Future Value Function
Future Value (4:40)
Epitomizing What If Analysis (0:34)
How to Create Scenario in Excel (6:06)
Creating Goal Seek in Excel (5:22)
Creating Goal Seek in Excel Continues (5:07)
Hw to Use Solver Tool in Excel (6:34)
Business Information
Business Information (0:46)
Creating a Dashboard of Sales (10:52)
Create hyperlinks for Sales (6:35)
Profit and Loss of Sales (9:53)
Profit and Loss of Sales Continues (11:16)
Database Information
Formulating the Design From Database Information (1:17)
Working with Data Table in Power Excel (5:18)
Adding New Coloumn in Data Table (7:22)
Using Excel Function in Data Table (6:29)
Working With Data Filtering (6:17)
Working With Data Filtering Continues (3:54)
Data Subtotal Group and Ungroup (5:21)
More on Data Subtotal Group and Ungroup (4:53)
Data Comparison and Filter
Data Comparison in Power Excel (9:04)
Data Filters and Slicers in Power Excel (4:57)
Pivot Chart and Power View
Pivot Chart in Power Excel (6:25)
Power View in Power Excel (7:30)
Power View in Power Excel Continues (8:11)
Working with Macros (0:59)
Example of Macros (8:29)
Example of Macros Continues (10:08)
Teach online with
Nested If Statement in Excel
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock