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)
