Excel & Spreadsheets

After this skill you can…

• Build a dynamic dashboard with pivot tables and slicers
• Use VLOOKUP, INDEX-MATCH, and array formulas
• Create automated reports with named ranges and conditional formatting

Watch (10 videos)

Excel Tutoring | Excel Tutorial For Beginners | Microsoft Excel Formulas and Functions | Simplilearn

Simplilearn · beginner

→ Create spreadsheets→ Use Excel formulas→ Analyze data

How to Modify Rows and Columns in Excel

Coursera · beginner hands-on

→ Insert and delete rows and columns in Excel→ Resize rows and columns for readability→ Hide and unhide rows and columns

Navigating the Microsoft Excel Interface

Coursera · beginner hands-on

→ Navigate the Excel interface→ Use essential tools and features→ Manage workbooks

How to use UPPER Function/Formula in Excel?

Professional's Legacy · intermediate hands-on

→ Use UPPER function in Excel→ Format text in Excel

How to use MODE.SNGL Function/Formula in Excel?

Professional's Legacy · intermediate hands-on

→ Apply the MODE.SNGL function to a dataset→ Analyze sales data to find the most frequently occurring value

Excel Lambda Functions: Create Your Own Functions Without VBA or Macros

Mergers & Inquisitions / Breaking Into Wall Street · beginner

→ Use Excel Lambda functions→ Create custom functions without VBA or Macros

Make an Investment Portfolio Tracker in Excel (Stocks, ETFs, Crypto etc.)

Kenji Explains · beginner

→ Use Excel formulas and functions→ Create data visualizations in Excel

How To Set up Print Ranges and Cell Formats in Excel

Michael Nugent · intermediate

→ Create spreadsheets in Excel→ Use Excel formulas and functions

How to Use a Bookkeeping Tracker | Step-by-Step Guide

SpreadsheetsHub · beginner

→ Create and use a bookkeeping template→ Master Excel and Google Sheets for financial tracking

Excel's Game-Changing 5 New Functions!

Kenji Explains · beginner

→ Create spreadsheets→ Use formulas and functions

Read (10 articles)