Excel video training

Excel video training

• 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

• Select a range of cells

Formatting

• Format numbers as TEXT
• Converts a number from one measurement system to another
• Show or hide gridlines on a worksheet

Formulas

• Create a simple formula in Excel
• Enter formula in multiple cells using array 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
  • Download a sample data workbook #2
• Display formula of cell as string in Excel
• Array of text values from range of cells
• Date

Errors

• Top 4 Most Common Excel Errors

Tables

• Video: How to Make Tables in Excel: Easy Step-by-Step Guide
• Video: Use slicers to filter data

Sort and Filter

• Video: Sort and Filter data in a range - Microsoft Excel
  • Download a sample data workbook

Charts

PivotTables

• Video: Create a PivotTable in excel
  • Download a sample data workbook

Share & co-author

• Video: Share a section of a workbook
• Video: How to: Protect a worksheet

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
  • Download a sample data workbook #1
• Video: Flash Fill in Excel
  • Download a sample data workbook
• Video: Quick Analysis in Excel
  • Download a sample data workbook
• Video: Define and use names in formulas - Learn the Basics Quickly
  • Download a sample data workbook
• Video: Copy values quickly from the status bar | Excel for Microsoft 365

Advance Topics

• Video: Use conditional formatting to highlight information
  • Download a sample data workbook
• Video: Apply data validation to cells - Microsoft Excel
  • Download a sample data workbook
• Video: Repeat specific rows or columns on every printed page
  • Download a sample data workbook
• Video: Set or clear a print area on a worksheet
  • Download a sample data workbook
• Video: What is Excel Labs | Try experimental features in Excel for Windows

Excel Mobile App

Get Started:

• Install Excel App on android phone
• TOP 25 Tips to use Excel Mobile App

Formatting:

• Apply cells border
• Merge & Center and Wrap text
• Change Date Format

Sort & Filter:

• Sort data in an Excel worksheet using Mobile App

More videos:

• Fill a column with a series
• use a cards view
• Fill a column with a series in excel