- What Does the Course Cover?
- Everything We Will Learn Has a Practical Application
- The Best Way to Take This Course
- Download All Course Materials and FAQ
- Microsoft Excel: The World's #1 Office Software
- Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
- Data Entry Techniques in Excel
- How to Make Your Spreadsheets Look Professional
- Data Entry Techniques in Excel
- Inserting, Deleting, and Modifying Rows & Columns
- Inserting, Deleting, and Modifying Rows & Columns
- Excel Formulas for Beginners
- Excel Formulas for Beginners
- A Beginner's Introduction to Excel Functions
- Format Cells
- Work Efficiently by Using Cut, Copy, and Paste
- Work Efficiently by Using Cut, Copy, and Paste
- Pasting Values, Formulas and Formats with Paste Special
- Inserting a Line Break with Alt + Enter
- Do More with Your Sales Data with Excel's Text to Columns Feature
- Do More with Your Sales Data with Excel's Text to Columns Feature
- Create Easily Printable Excel Documents
- How to Wrap Text in Excel and Adjust a Cell's Size
- Insert Hyperlinks into Excel Spreadsheets
- Using Excel's Freeze Panes to Handle Large Datasets
- Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
- A Quick Introduction to Excel's Pivot Tables
- Initial Formatting Is Key for Creating Professional-looking Spreadsheets
- Macros Are a Great Timesaver! Here's Why.
- How to Use the Same Macro On Multiple Workbooks
- Macros Are a Great Timesaver! Here's Why.
- The Secret to Faster Scrolling in Excel
- Be even quicker: F5 + Enter
- FAQ: F5 + Enter didn't work for me
- The Secret to Faster Scrolling in Excel
- Using Absolute and Relative Cell References
- Using Absolute and Relative Cell References
- Find and Select Cells That Meet Specific Conditions
- Find and Select Cells That Meet Specific Conditions
- How to Create Dynamic Names in Excel Spreadsheets
- How to Create Dynamic Names in Excel Spreadsheets
- Using Named Ranges to Make Formulas More Readable
- Introduction to Custom Formatting in Excel
- Custom Number Formatting
- How to Add a Drop-down List in Excel
- Using Custom-sort to Sort Multiple Columns Within a Table
- Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
- Multiply by 1
- Find and Replace - References
- FAQ: Why Do We Replace External References and How Does This Help Us?
- Find and Replace - Formatting
- Green References
- Beauty Saving - The Professional Way of Saving Files
- The Power of F2
- Conditional Formatting
- Quiz Number 1
- Key Excel Functions: IF
- Enlarge the Formula Bar
- Key Excel Functions: SUM, SUMIF, SUMIFS
- A Helpful Consideration
- Key Excel Functions: COUNT, COUNTA, COUNTIF, COUNTIFS
- Key Excel Functions: AVERAGE & AVERAGEIF
- Key Excel Functions: Average & Averageif
- Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &
- Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &
- Working with Text in Excel
- Find the Highest and Lowest Values in a Range: Max & Min
- = and + are Interchangeable When You Start Typing a Formula
- Use ROUND in Your Financial Models
- Excel's Lookup Functions: VLOOKUP & HLOOKUP Made Easy
- INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP
- INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP
- Using Excel's IFERROR Function to Trap Spreadsheet Errors
- A Useful Tool for Financial Analysis - The RANK Function
- Create Flexible Financial Models with CHOOSE
- Goal Seek Will Help You Find the Result You Are Looking For
- Goal Seek Will Help You Find the Result You Are Looking For
- Perform Sensitivity Analysis with Excel's Data Tables Functionality
- Perform Sensitivity Analysis with Excel's Data Tables Functionality
- Quiz Number 2
- Discounting Cash Flows in Microsoft Excel
- Calculating Internal Rate of Return (IRR) in Excel
- Using the PMT Function to Create a Complete Loan Schedule
- Date Functions in Excel
- Introduction to the Case Study
- What You Will See Next
- Understand Your Data Source Before You Start Working on It
- Ordering the Source Worksheet
- Creating a Code: The Best Way to Organize Your Data and Work Efficiently with It
- Learn How to Create a Database
- Using Lookup Functions (VLOOKUP) to Fill the Database Sheet
- Using SUMIF to Complete the Database Sheet
- FAQ: Why Net income should be 0?