Using UNIQUE and TRANSPOSE | EDUCBA

Autoplay
Autocomplete

Previous Lesson Complete and Continue

FINANCIAL MODELING COURSE

Basic Excel Training

accessing MS Excel new (2:41)
MS Excel Startup Screen (2:27)
Understanding the Ribbon (3:03)
Cells in Excel (1:18)
Worksheet Essentials (3:10)
Saving the File (1:14)
Formatting Cells (14:23)
Custom Cell Styles (6:12)
Custom Number Formatting in Excel (11:39)
More on Custom Number Formatting (10:59)
Custom Formats of Data (13:33)
The BEDMAS Order of Mathematical Operations (9:04)
Mathematical Operations without Functions new1 (9:43)
IF Function (10:32)
Mathematical Operations without Functions Continued (11:38)
More on IF Function (8:25)
Importing Data and Calculations (10:46)
Working with the Count Function (12:40)
Conditional Counts - CountIF Function (4:58)
Working with the Sum Function (14:02)
Finding the Average (11:17)
Conditional Average - Average IFS Function (8:31)
Finding the Maximum Value Using the MAX Function (8:36)
Finding the Minimum Value Using the MINFS Function (8:04)
Determining Proportions and Updating a Calculation (10:06)
Conditional Formatting new1 (18:24)
More on Conditional Formatting (7:47)
Working with Tables (13:03)
Formatting Table (13:31)
Filtering and Sorting of Data (9:40)
Freeze and Split (11:18)
Printing and Layouts in Excel (9:51)
Pivot Tables (7:50)
Creating Custom Tables (8:58)
Organizing Pivot Tables (8:35)
Column Chart (10:32)
Bar Chart (8:03)
Line Chart (14:24)
Pie Chart (10:27)
Map Chart (6:46)
Common Errors in Excel (11:12)
More on Common Errors (13:42)
Conditional Formatting (9:47)
Mathematical Operations without Functions (9:43)

Advanced Excel Training 2019

Logical Function - IF new (8:21)
AND OR and XOR Functions (8:48)
IFS Function - Example 1 (6:25)
IFS Function - Example 2 (9:02)
SWITCH Function (10:17)
Other Logical Functions (8:20)
Information Functions - ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXT (10:49)
Date Functions - TODAY DAY (9:36)
MONTH YEAR WEEKDAY WEEKNUM Functions (11:23)
EDATE and EOMONTH Functions (8:38)
YEARFRAC Function (7:19)
Joining Data using CONCAT and TEXTJOIN (9:59)
LEN FIND LEFT RIGHT TRIM (10:26)
Using UNIQUE and TRANSPOSE (11:27)
TEXT Function (10:00)
CHOOSE Function (10:46)
More on CHOOSE Function (6:34)
VLookUp Function (12:47)
HLOOKUP Function (5:12)
Index Function (10:31)
Match Function (9:24)
XLOOKUP and XMATCH Functions (8:43)
Using the OFFSET Function (8:49)
OFFSET Function - Total and Average Score (9:29)
OFFSET Function - Highest and Lowest Score (8:57)
OFFSET Function - Year to Month Sales (11:01)
OFFSET Function - Quarterly and Half-Month Sales (6:39)
Naming of Cell (12:30)
Naming a Range (10:01)
Text to Columns (6:35)
Grouping Tabs and Subtotal Function (12:47)
Working with Hyperlinks (11:17)
Data Validation (11:00)
Data Validation Continued (11:14)
Custom Data Validation (12:17)
Generating Random Numbers (6:10)
Custom Views (10:34)
Protecting Worksheet and Workbook (17:36)
PivotTable - Advanced Features (10:02)
More on Advanced Features (6:50)
Slicers and Timelines (6:43)
Solver (11:37)
Data Tables (10:42)
More on Data Tables (9:53)
Goal Seek (8:43)
Combo Charts (13:51)
More on Combo Charts (12:11)
Sparklines (8:10)
Waterfall Chart (9:37)
Box Chart (12:48)
Whisker Chart (11:29)
TreeMap and Sun Burst Charts (11:53)
Radar Chart (7:55)
Scroll Bar (10:00)
Spin Button and Radio Button (10:52)
Form Control Application (10:01)
Form Control Application Continued (5:32)
Data Entry Form (3:44)
Logical Function - IF (8:20)

Accounting - The Foundation

An Introduction To Financial Accounting (0:48)
Purpose Of Financial Statements (3:16)
Explaining A Business Cycle (2:16)
Accounting For Income Statement (9:31)
Accounting For Balance Sheet 1 (7:47)
Accounting For Balance Sheet 2 (9:53)
Accounting For Balance Sheet 3 (6:24)
Accounting For Cash Flows (5:20)
Conclusion (0:28)

Accounting 01 - Income Statement

Financial Statements - Fiscal Year Vs Calendar Year new (6:34)
Income Statement Format new (8:23)
Calculating Profit Margins new1 (2:33)
Non Recurring Items new (9:10)
Changes In Accounting Estimates new (3:00)
Final Remarks new (3:09)
Revenue Recognition Percentage Completion and Completed Contract new (11:30)
Revenue Recognition Installment Method and Cost Recovery new (6:22)
Depreciation Expense x (10:40)
Downloading Colgates Income Statement new (12:21)
Analyst Format Of Colgate-S Income Statement (3:17)
Formatting The Income Statement (2:39)
Investigating The Non-Recurring Charges (4:58)
Seperating non-recurring Items (7:07)
Comparision Of Margins - Before And After Adjustments (3:34)

Financial Modeling Tesla

Tesla Unveiled (4:05)
Analyzing Teslas Sales Performance (2:23)
Sourcing Historical Data (6:01)
Navigating Teslas Annual Report (3:38)
Consolidated Financial Statements
Historical Revenue Growth Rate (3:02)
Projecting Teslas Revenue (17:38)
Color-Coding in Financial Models (2:53)
Projecting Cost of Sales (18:07)
Forecasting Operating Expenses (9:07)
Working Capital Ratios (7:14)
Working Capital Projections (12:21)
Calculating Proportion of Assets (5:47)
CAPEX Projections (3:31)
CAPEX Distribution (2:21)
Using TRANSPOSE Function (4:14)
Calculating Machinery and Equipment Depreciation (8:38)
Completing Ending Net PPE (9:04)
Common Stock Calculations (5:16)
Retained Earnings Calculations
Net Income Attributable to Non-Controlling Interests
Provision for Income Taxes (8:21)
Cash Flow Statement (14:11)
Balance Sheet Linkages (9:09)
Completing cash Flow Linkages (11:59)
Cash Available for Debt Repayment (3:03)
Long-Term Debt Payments (6:48)
Income Statement Linkages (11:52)
FCFF Calculations (4:19)
Understanding WACC (4:57)
WACC Calculations (12:08)
Terminal Value Explained (7:19)
NPV Calculation Steps (13:14)
Target Share Price Calculations (5:51)
Sensitivity Analysis (7:13)
Weighted Average Number of Shares (12:11)
Basic & Diluted EPS (5:13)
EBITDA Calculations (3:57)
Tesla Ratio Analysis (16:26)

Teach online with

Using UNIQUE and TRANSPOSE

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock