Excel video training
Connect with me: Youtube | LinkedIn | WhatsApp Channel | Web | Facebook | Twitter
- Download PDF
- To access the updated handouts, please click on the following link: https://yasirbhutta.github.io/ms-excel/resources/video-training-excel.pdf
- Download: Excel Handouts
- Youtube: Excel Playlist
Quick start
Intro. to Excel
- Microsoft Excel Interface
- Enter data manually in worksheet cells
- Enter a dates or a time in a cell
- Manage Worksheets
- Select cells, ranges, rows, or columns
- Pin a file to the recently used files list
Rows and columns
Cells
Formatting
- Format numbers as TEXT
- Converts a number from one measurement system to another
- Show or hide gridlines on a worksheet
Formulas
Functions
Cell references
- Use cell references in a formula
- Create an Absolute Reference
- Coping formula
Most frequently used functions
- Use of Sum function and AutoSum to sum numbers
- How to: Use cell references in a formula
- MAX and MIN
- AVERAGE
- PRODUCT
- POWER
- COUNT
- COUNTA
- COUNTIF
- SUMIF
- IF
- DAYS
- Change the case of text in excel
- TODAY and NOW
- Join First Name and Last Name - CONCAT function
- Find unique list of cities using Unique Function
New functions - Microsoft 365
- Find Employee using XLOOKUP function
- Generate Serial# using sequence
- CHOOSECOL
- How to: Filter data by using a formula in excel
- TEXTSPLIT: split cells / text strings by delimiter
More Functions
- TRANSPOSE function:Vertical range of cells as a horizontal range
- Display formula of cell as string in Excel
- Array of text values from range of cells
- Date
Errors
Tables
Sort and Filter
Charts
PivotTables
Share & co-author
Linked dat types
Get to know Power Query
Tips and Tricks
- Insert copyright, registered and trademark symbols
- How to: Populate a Dropdown List Based on Cells Value
- Generate a sequence end with text
- Populate a Dropdown List Based on Cells Value
- Video: Transpose (rotate) data from rows to columns or vice versa - Microsoft 365
- Video: Flash Fill in Excel
- Video: Quick Analysis in Excel
- Video: Define and use names in formulas - Learn the Basics Quickly
- Video: Copy values quickly from the status bar | Excel for Microsoft 365
Advance Topics
- Video: Use conditional formatting to highlight information
- Video: Apply data validation to cells - Microsoft Excel
- Video: Repeat specific rows or columns on every printed page
- Video: Set or clear a print area on a worksheet
- Video: What is Excel Labs | Try experimental features in Excel for Windows
Excel Mobile App
Get Started:
Formatting:
Sort & Filter:
More videos: