The Complete Financial Analyst Course 2024

About Course

Become a certified Financial Analyst with this comprehensive and updated online course. This free course is designed to give you the skills needed to succeed in a financial analyst career.
This course is taught by experienced professionals who have worked at top companies like Pwc and Coca-Cola and covers everything from accounting and financial statements to business analysis and capital budgeting.

This free course provides you with:

A strong foundation in Microsoft Excel
An understanding of accounting, financial statements, and ratios
Knowledge of finance basics such as interest rates, loan calculations, and time value of money
The ability to analyze a business and its performance
The skills needed to create effective presentations using Microsoft PowerPoint

The course includes engaging challenges that will test your skills and help you apply what you’ve learned. You will also receive personalized feedback on your work.

Enroll in this free course today and begin your journey to a successful career in finance.

This course is available for free from platforms like Udemy, Udacity, Coursera, MasterClass, NearPeer, and others.

Work comfortably with Microsoft Excel
Format spreadsheets professionally
Perform routine tasks quicker
Create professional charts in Microsoft Excel
Efficiently work with vast amounts of data
Understand accounting and bookkeeping principles
Build a company’s P&L from scratch
Create a company’s balance sheet
Perform Financial statement analysis
Understand the timing of revenue and cost recognition
Calculate liquidity, solvency, profitability, and growth ratios to analyze a company’s performance
Understand 10-K reports
Assess whether a project is feasible via the net present value (NPV) technique
Calculate a complete loan schedule
Know the difference between variable and fixed interest rates
Perform industry analysis
Realize what drives a company’s value
Know how to analyze a business
Work comfortably with Microsoft PowerPoint
Create professional company presentations in PowerPoint
Become a successful Financial Analyst – if you follow the course entirely!

Course Content

01. Welcome! Course Introduction

A Message from the Professor
001. What Does the Course Cover.mp4

00:00
002. Everything We Will Learn Has a Practical Application.mp4

00:00
003. The Best Way to Take This Course.mp4

00:00
004. Download All Course Materials and FAQ.html

00:00
Section Quiz

02. Microsoft Excel – Quick Introduction

001. Microsoft Excel The World’s #1 Office Software.mp4

00:00
002. Excel Made Easy A Beginner’s Guide to Excel Spreadsheets.mp4

00:00
003. Data Entry Techniques in Excel.mp4

00:00
004. How to Make Your Spreadsheets Look Professional.mp4

00:00
005. Data Entry Techniques in Excel.html

00:00
006. Inserting, Deleting, and Modifying Rows & Columns.mp4

00:00
007. Inserting, Deleting, and Modifying Rows & Columns.html

00:00
008. Excel Formulas for Beginners.mp4

00:00
009. Excel Formulas for Beginners.html

00:00
010. A Beginner’s Introduction to Excel Functions.mp4

00:00
011. Format Cells.mp4

00:00
012. Work Efficiently by Using Cut, Copy, and Paste.mp4

00:00
013. Work Efficiently by Using Cut, Copy, and Paste.html

00:00
014. Pasting Values, Formulas and Formats with Paste Special.mp4

00:00
Section Quiz

03. Microsoft Excel – Useful Tools

001. Inserting a Line Break with Alt + Enter.mp4

00:00
002. Do More with Your Sales Data with Excel’s Text to Columns Feature.mp4

00:00
003. Do More with Your Sales Data with Excel’s Text to Columns Feature.html

00:00
004. Create Easily Printable Excel Documents.mp4

00:00
005. How to Wrap Text in Excel and Adjust a Cell’s Size.mp4

00:00
006. Insert Hyperlinks into Excel Spreadsheets.mp4

00:00
007. Using Excel’s Freeze Panes to Handle Large Datasets.mp4

00:00
008. Find Excel Functionalities in a Quicker Way – Tell Me What You Want to Do.mp4

00:00
009. A Quick Introduction to Excel’s Pivot Tables.mp4

00:00
Section Quiz

04. Microsoft Excel – Best Practices That Will Make a Difference

001. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4

00:00
002. Macros Are a Great Timesaver! Here’s Why..mp4

00:00
003. How to Use the Same Macro On Multiple Workbooks.mp4

00:00
004. Macros Are a Great Timesaver! Here’s Why..html

00:00
005. The Secret to Faster Scrolling in Excel.mp4

00:00
006. Be even quicker F5 + Enter.mp4

00:00
007. FAQ F5 + Enter didn’t work for me.html

00:00
008. The Secret to Faster Scrolling in Excel.html

00:00
009. Using Absolute and Relative Cell References.mp4

00:00
010. Using Absolute and Relative Cell References.html

00:00
011. Find and Select Cells That Meet Specific Conditions.mp4

00:00
012. Find and Select Cells That Meet Specific Conditions.html

00:00
013. How to Create Dynamic Names in Excel Spreadsheets.mp4

00:00
014. How to Create Dynamic Names in Excel Spreadsheets.html

00:00
015. Using Named Ranges to Make Formulas More Readable.mp4

00:00
016. Introduction to Custom Formatting in Excel.mp4

00:00
017. Custom Number Formatting.mp4

00:00
018. How to Add a Drop-down List in Excel.mp4

00:00
019. Using Custom-sort to Sort Multiple Columns Within a Table.mp4

00:00
020. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4

00:00
021. Multiply by 1.mp4

00:00
022. Find and Replace – References.mp4

00:00
023. FAQ Why Do We Replace External References and How Does This Help Us.html

00:00
024. Find and Replace – Formatting.mp4

00:00
025. Green References.mp4

00:00
026. Beauty Saving – The Professional Way of Saving Files.mp4

00:00
027. The Power of F2.mp4

00:00
028. Conditional Formatting.mp4

00:00
029. Quiz Number 1.html

00:00
Section Quiz

05. Microsoft Excel – Beginner, Intermediate & Advanced Functions

001. Key Excel Functions IF.mp4

00:00
002. Enlarge the Formula Bar.mp4

00:00
003. Key Excel Functions SUM, SUMIF, SUMIFS.mp4

00:00
004. A Helpful Consideration.html

00:00
005. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4

00:00
006. Key Excel Functions AVERAGE & AVERAGEIF.mp4

00:00
007. Key Excel Functions Average & Averageif.html

00:00
008. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4

00:00
009. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html

00:00
010. Working with Text in Excel.mp4

00:00
011. Find the Highest and Lowest Values in a Range Max & Min.mp4

00:00
012. = and + are Interchangeable When You Start Typing a Formula.mp4

00:00
013. Use ROUND in Your Financial Models.mp4

00:00
014. Excel’s Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4

00:00
015. INDEX, MATCH, and Their Combination – The Perfect Substitute of VLOOKUP.mp4

00:00
016. INDEX, MATCH, and Their Combination – The Perfect Substitute of VLOOKUP.html

00:00
017. XLOOKUP a Solid Substitute of VLOOKUP (Office 365 only).mp4

00:00
018. Using Excel’s IFERROR Function to Trap Spreadsheet Errors.mp4

00:00
019. A Useful Tool for Financial Analysis – The RANK Function.mp4

00:00
020. Create Flexible Financial Models with CHOOSE.mp4

00:00
021. Goal Seek Will Help You Find the Result You Are Looking For.mp4

00:00
022. Goal Seek Will Help You Find the Result You Are Looking For.html

00:00
023. Perform Sensitivity Analysis with Excel’s Data Tables Functionality.mp4

00:00
024. Perform Sensitivity Analysis with Excel’s Data Tables Functionality.html

00:00
025. Quiz Number 2.html

00:00
Section Quiz

06. Microsoft Excel – Financial Functions in Excel

07. Microsoft Excel – Practical Exercise Build a P&L From Scratch

001. Introduction to the Case Study.mp4

00:00
002. What You Will See Next.mp4

00:00
003. Understand Your Data Source Before You Start Working on It.mp4

00:00
004. Ordering the Source Worksheet.mp4

00:00
005. Creating a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4

00:00
006. Learn How to Create a Database.mp4

00:00
007. Using Lookup Functions (VLOOKUP) to Fill the Database Sheet.mp4

00:00
008. Using SUMIF to Complete the Database Sheet.mp4

00:00
009. FAQ Why Net income should be 0.html

00:00
010. Using INDEX & MATCH as a Substitute for VLOOKUP.mp4

00:00
011. XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH.mp4

00:00
012. The Mapping Exercise.mp4

00:00
013. Mapping the Rows in the Database Sheet.mp4

00:00
014. Building the Structure of the P&L Sheet.mp4

00:00
015. A Practical Example of Professional Formatting in Excel.mp4

00:00
016. Populating the P&L Sheet with SUMIF.mp4

00:00
017. Learn How to Find Mistakes with COUNTIF.mp4

00:00
018. Calculating Growth Rates in Excel.mp4

00:00
019. Quiz Number 3.html

00:00
Section Quiz

08. Practical Exercise – SUMIFS

09. Microsoft Excel – Building Professional Charts in Excel

10. Microsoft Excel – Creating Complete Professional Charts from Scratch

11. Microsoft Excel – Working with Pivot Tables in Excel

001. Pivot Tables – Excel’s Dynamic and Interactive Tables.mp4

00:00
002. Creating a Pivot Table Choosing Row and Column Parameters.mp4

00:00
003. Design the Layout and Format of Your Pivot Tables.mp4

00:00
004. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4

00:00
005. One of the Most Useful Excel Functions – GETPIVOTDATA.mp4

00:00
006. Welcome to the Future – Pivot Table Slicers.mp4

00:00
007. Introduction to the Course Challenge.mp4

00:00
008. COURSE CHALLENGE – Part 1.mp4

00:00
Section Quiz

12. Microsoft Excel – Pivot Tables & Slicers – World-Class Financial Reporting

001. Introduction to the Case Study.mp4

00:00
002. Working with an SAP Data Extraction.mp4

00:00
003. Preliminary Mapping of the Data Extraction.mp4

00:00
004. Creating an Output Structure of the FMCG Model.mp4

00:00
005. Improving the Layout and Appearance of the FMCG Report.mp4

00:00
006. Inserting Formulas and Automating Calculations.mp4

00:00
007. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4

00:00
008. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4

00:00
009. GETPIVOTDATA Fix.mp4

00:00
010. FAQ My GETPIVOTDATA Function Doesn’t Work.html

00:00
011. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4

00:00
012. Getting Fancy with Excel Slicers.mp4

00:00
013. This is How the Report Can be Used in Practice by High-level Executives.mp4

00:00
Section Quiz

13. Modeling in Excel – Building a Complete 3-statement Model

001. Introduction to the Exercise.mp4

00:00
002. Let’s Create a Mapping of Financials.mp4

00:00
003. Building an Output P&L Sheet.mp4

00:00
004. Filling in the Output P&L Sheet with Historical Financials.mp4

00:00
005. Calculating Percentage Variances and Applying Conditional Formatting.mp4

00:00
006. Building an Output Balance Sheet.mp4

00:00
007. Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet.mp4

00:00
008. Adding the Forecast Period.mp4

00:00
Section Quiz

14. Modeling in Excel – Let’s Build a Flexible Model with Multiple Scenarios

15. Modeling in Excel – We Are Almost There! Completing the 3-Statement Model

16. Accounting – Introduction to Accounting & Bookkeeping

17. Accounting – Types of Revenues, Costs, Assets, and Liabilities

001. The Different Types of Accounting Standards.mp4

00:00
002. The Three Financial Statements.mp4

00:00
003. Types of Revenues.mp4

00:00
004. Types of Revenues – Exercise.mp4

00:00
005. Types of Expenses.mp4

00:00
006. Income Taxes.mp4

00:00
007. Depreciation & Amortization.mp4

00:00
008. The Two Types of Income Statement Formats.mp4

00:00
009. Balance Sheet Items.mp4

00:00
010. Asset Categories – Practical Example.mp4

00:00
011. Liability Categories – Practical Example.mp4

00:00
012. Equity.mp4

00:00
013. Equity Categories – Practical Example.mp4

00:00
014. Quiz Number 4.html

00:00
Section Quiz

18. Accounting – Revenue Recognition

19. Accounting – Cost Recognition

20. Accounting – Understanding the Big Picture Why, What, When, and How Much

21. Accounting – The Core Principles of Accounting

22. Accounting – Practical Exercise The Accounting Transactions of a Lemonade Stand

23. Accounting – The Importance of Timing

24. Accounting – Preparing a Cash Flow Statement Understanding Cash Flow Analysis

25. Advanced Accounting – Trade Receivables

26. Advanced Accounting – Inventory

27. Advanced Accounting – Fixed Assets

28. Advanced Accounting – Trade Payables

29. Advanced Accounting – Financial Liabilities

30. Advanced Accounting – Leasing Liabilties

31. Advanced Accounting – Using Leverage

32. Advanced Accounting – Raising Equity, Types of Equity, and Dividend Payments

33. Assessment – Accounting

34. Financial Statement Analysis – An Introduction

35. Financial Statement Analysis – Subtleties

36. Financial Statement Analysis – Practical Case Study Analyzing P&G’s Financials

37. Financial Statement Analysis – Tesla Exercise

38. Working Capital Management

001. Introduction.mp4

00:00
002. The Importance of Working Capital Optimization Case Study.mp4

00:00
003. Overtrading vs. Excessive Investment.mp4

00:00
004. Trade Receivables Management.mp4

00:00
005. Re-order Level.mp4

00:00
006. Economic Order Quantity (EOQ).mp4

00:00
007. Inventory Optimization Techniques.mp4

00:00
008. Trade Payables Management.mp4

00:00
009. Working Capital Optimization – a Roadmap.mp4

00:00
010. Symptoms of Inefficient Working Capital – Trade Payables.mp4

00:00
011. Symptoms of Inefficient Working Capital – Trade Receivables.mp4

00:00
Section Quiz

39. Fundamentals of Business & Financial Analysis

40. Business Analysis in Excel

001. Trend analysis – theory.html

00:00
002. Trend analysis.mp4

00:00
003. Comparative analysis – theory.html

00:00
004. Comparative analysis.mp4

00:00
005. Value-based analysis – theory.html

00:00
006. Value-based analysis.mp4

00:00
007. Correlation analysis – theory.html

00:00
008. Correlation analysis.mp4

00:00
009. Time series analysis – theory.html

00:00
010. Time series analysis.mp4

00:00
011. Regression analysis – theory.html

00:00
012. Regression analysis.mp4

00:00
Section Quiz

41. Finance 101 – The Time Value of Money and Interest Rate Components

001. Finance 101 Important Financial Principles That You Will Need.mp4

00:00
002. Understanding the Time Value of Money.mp4

00:00
003. How Interest Rates Play an Important Role in the Economy.mp4

00:00
004. The Components Forming Interest Rates in Real Life.mp4

00:00
005. What Is Libor and What Purpose Does It Serve.mp4

00:00
006. The Difference Between Fixed and Variable Interest Rates.mp4

00:00
007. What Is Default Risk and How Does a Bank Account For It.mp4

00:00
008. Corporate Loan Specifics.mp4

00:00
Section Quiz

42. Finance 101 – The Value of Cash Flows with Different Timing

43. Finance 101 – Loan Calculations

44. Capital Budgeting – Basic Notions

001. What is Capital Budgeting.mp4

00:00
002. When Do We Use Capital Budgeting.mp4

00:00
003. The Time Value of Money in a Capital Budgeting Setting.mp4

00:00
004. Calculating Present and Future Value.mp4

00:00
005. Cost of Equity.mp4

00:00
006. Project-specific Beta.mp4

00:00
007. The Weighted Average Cost of Capital (WACC).mp4

00:00
008. The Different Cash Flow Types in a Capital Budgeting Exercise.mp4

00:00
009. Modeling Future Cash Flows.mp4

00:00
Section Quiz

45. Capital Budgeting – A Complete Case Study

001. An Introduction to the Case Study.mp4

00:00
002. Organizing Inputs In the Drivers Sheet.mp4

00:00
003. Modeling Expected Savings – Building Cars In Italy vs. Building Cars In Vietnam.mp4

00:00
004. Preparing a Fixed Asset Rollforward Schedule.mp4

00:00
005. Calculating the Cash Impact of Extra Working Capital Required.mp4

00:00
006. Debt Repayment and Interest Expenses Calculation.mp4

00:00
007. The Project’s P&L Sheet.mp4

00:00
008. The Project’s Cash Flow Calculation.mp4

00:00
009. Calculating WACC (Weighted Average Cost of Capital).mp4

00:00
010. Estimating Cost of Equity.mp4

00:00
011. Discounting Project Cash Flows.mp4

00:00
012. Performing Sensitivity Analysis and Wrapping Up the Case Study.mp4

00:00
013. FAQ Data Does Not Change in the DCF Sheet, It Changes From the Drivers Sheet.html

00:00
Section Quiz

46. Tesla Practical Case Study – Building a Financial Planning Model

001. Organizing External Inputs in a ‘Drivers’ Sheet.mp4

00:00
002. Forecasting Tesla’s Expected Deliveries.mp4

00:00
003. Comparing Delivery Figures with the Ones of industry Peers.mp4

00:00
004. Estimating an Average Selling Price of Tesla Vehicles.mp4

00:00
005. Calculating Automotive Revenue.mp4

00:00
006. Peer Comparison Gross Profit %.mp4

00:00
007. Calculating Automotive Gross Profit.mp4

00:00
008. Calculating Automotive Cost of Sales.mp4

00:00
009. Forecasting ‘Energy’ and ‘Services’ Revenue.mp4

00:00
010. Calculating ‘Energy’ and ‘Services’ Gross Profit and Cost of Sales.mp4

00:00
011. Forecasting Operating Expenses.mp4

00:00
012. Building a Fixed Asset Roll Forward PP&E.mp4

00:00
013. Building a Fixed Asset Roll Forward Estimating Capex.mp4

00:00
014. Building a Fixed Asset Roll Forward D&A Schedule.mp4

00:00
015. Calculating DSO, DIO, DPO.mp4

00:00
016. Producing a Clean P&L Output Sheet.mp4

00:00
017. Calculating Investments in Working Capital.mp4

00:00
018. Forecasting Unlevered Free Cash Flow.mp4

00:00
019. Forecasting Other Assets.mp4

00:00
020. Forecasting Other Liabilities.mp4

00:00
021. Completing Unlevered Free Cash Flow.mp4

00:00
022. Modeling Tesla’s Financing Needs in the Forecast Period.mp4

00:00
023. Calculating Net Income.mp4

00:00
024. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4

00:00
025. Balancing the Balance Sheet.mp4

00:00
Section Quiz

47. Data Analysis with ChatGPT – Intro

48. Data Analysis with ChatGPT – Exploratory Data Analysis (EDA)

49. Data Analysis with ChatGPT – Deal with Inconsistent Data

50. Data Analysis with ChatGPT – Organize Messy Data

51. Data Analysis with ChatGPT – Working with Functions

52. Data Analysis with ChatGPT – Clean Text Data

53. Data Analysis with ChatGPT – Dates and Time Data

54. Data Analysis with ChatGPT – Complete Practical Example

55. PowerPoint – Introduction to PowerPoint

001. Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp4

00:00
002. The Structure of the PowerPoint Ribbon.mp4

00:00
003. General Considerations About Slide Structure.mp4

00:00
004. Learn How to Insert Objects in PowerPoint.mp4

00:00
005. Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp4

00:00
006. Add Frequently Used Buttons to the Quick Access Toolbar.mp4

00:00
007. How to Easily Align Objects in PowerPoint.mp4

00:00
008. How to Edit Shapes in Your Presentation.mp4

00:00
009. How to Format Text Boxes in a PowerPoint Presentation.mp4

00:00
010. Practical Learning – Exercise 1.mp4

00:00
011. Changing an Object’s Size and Rotation.mp4

00:00
012. Using Slide Masters.mp4

00:00
013. Bring to Front and Send to Back – An Important PowerPoint Technique.mp4

00:00
014. Learn How to Create, Edit, Resize and Format PowerPoint Tables.mp4

00:00
Section Quiz

56. PowerPoint – Tips & Tricks That Will Transform You Into An Advanced User

001. An Introduction to PowerPoint Animations.mp4

00:00
002. Modifying the Beginning and Ending of a Line Object.mp4

00:00
003. Join Shapes Together By Using Connector Lines.mp4

00:00
004. Edit Points – Learn How to Customize PowerPoint Shapes.mp4

00:00
005. Group or Ungroup Shapes, Pictures or Other Objects.mp4

00:00
006. This is How You Can Fit Text When It Is Larger Than a Shape.mp4

00:00
007. Nudge Objects.mp4

00:00
008. PowerPoint’s Smart Art Feature Offers Great Return for Your Time.mp4

00:00
009. Creating Eye-Catching Text Effects in PowerPoint.mp4

00:00
010. Practical Exercise – Creating an Organisational Chart.mp4

00:00
011. COURSE CHALLENGE – Part 4.mp4

00:00
Section Quiz

57. Who Does What in the World of Finance

58. Next Steps

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

3.5

Total 2 Ratings

0 Rating

1 Rating

0 Rating

kashish raizada

3 months ago

Informative

Lekay John

4 months ago

yes

About Course

What Will You Learn?

Course Content

01. Welcome! Course Introduction

A Message from the Professor

001. What Does the Course Cover.mp4

002. Everything We Will Learn Has a Practical Application.mp4

003. The Best Way to Take This Course.mp4

004. Download All Course Materials and FAQ.html

Section Quiz

02. Microsoft Excel – Quick Introduction

001. Microsoft Excel The World’s #1 Office Software.mp4

002. Excel Made Easy A Beginner’s Guide to Excel Spreadsheets.mp4

003. Data Entry Techniques in Excel.mp4

004. How to Make Your Spreadsheets Look Professional.mp4

005. Data Entry Techniques in Excel.html

006. Inserting, Deleting, and Modifying Rows & Columns.mp4

007. Inserting, Deleting, and Modifying Rows & Columns.html

008. Excel Formulas for Beginners.mp4

009. Excel Formulas for Beginners.html

010. A Beginner’s Introduction to Excel Functions.mp4

011. Format Cells.mp4

012. Work Efficiently by Using Cut, Copy, and Paste.mp4

013. Work Efficiently by Using Cut, Copy, and Paste.html

014. Pasting Values, Formulas and Formats with Paste Special.mp4

Section Quiz

03. Microsoft Excel – Useful Tools

001. Inserting a Line Break with Alt + Enter.mp4

002. Do More with Your Sales Data with Excel’s Text to Columns Feature.mp4

003. Do More with Your Sales Data with Excel’s Text to Columns Feature.html

004. Create Easily Printable Excel Documents.mp4

005. How to Wrap Text in Excel and Adjust a Cell’s Size.mp4

006. Insert Hyperlinks into Excel Spreadsheets.mp4

007. Using Excel’s Freeze Panes to Handle Large Datasets.mp4

008. Find Excel Functionalities in a Quicker Way – Tell Me What You Want to Do.mp4

009. A Quick Introduction to Excel’s Pivot Tables.mp4

Section Quiz

04. Microsoft Excel – Best Practices That Will Make a Difference

001. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4

002. Macros Are a Great Timesaver! Here’s Why..mp4

003. How to Use the Same Macro On Multiple Workbooks.mp4

004. Macros Are a Great Timesaver! Here’s Why..html

005. The Secret to Faster Scrolling in Excel.mp4

006. Be even quicker F5 + Enter.mp4

007. FAQ F5 + Enter didn’t work for me.html

008. The Secret to Faster Scrolling in Excel.html

009. Using Absolute and Relative Cell References.mp4

010. Using Absolute and Relative Cell References.html

011. Find and Select Cells That Meet Specific Conditions.mp4

012. Find and Select Cells That Meet Specific Conditions.html

013. How to Create Dynamic Names in Excel Spreadsheets.mp4

014. How to Create Dynamic Names in Excel Spreadsheets.html

015. Using Named Ranges to Make Formulas More Readable.mp4

016. Introduction to Custom Formatting in Excel.mp4

017. Custom Number Formatting.mp4

018. How to Add a Drop-down List in Excel.mp4

019. Using Custom-sort to Sort Multiple Columns Within a Table.mp4

020. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4

021. Multiply by 1.mp4

022. Find and Replace – References.mp4

023. FAQ Why Do We Replace External References and How Does This Help Us.html

024. Find and Replace – Formatting.mp4

025. Green References.mp4

026. Beauty Saving – The Professional Way of Saving Files.mp4

027. The Power of F2.mp4

028. Conditional Formatting.mp4

029. Quiz Number 1.html

Section Quiz

05. Microsoft Excel – Beginner, Intermediate & Advanced Functions

001. Key Excel Functions IF.mp4

002. Enlarge the Formula Bar.mp4

003. Key Excel Functions SUM, SUMIF, SUMIFS.mp4

004. A Helpful Consideration.html

005. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4

006. Key Excel Functions AVERAGE & AVERAGEIF.mp4

007. Key Excel Functions Average & Averageif.html

008. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4

009. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html

010. Working with Text in Excel.mp4

011. Find the Highest and Lowest Values in a Range Max & Min.mp4