Training Materials for Microsoft M365 - Excel

Articles (19)

Pinned Article MS Excel Overview

Training Materials for MS Excel

TIPS - Add A Diagonal Line to a Cell

Add A Diagonal Line to a Cell

TIPS - Add more than one row or column

Add more than one row or column at a time

TIPS - AutoFill Your Cells

AutoFill Your Cells

TIPS - Autofit All the Columns/Rows Instantly

Autofit All the Columns/Rows Instantly

TIPS - Don't Use Merge

Don’t Use Merge to Center Content

TIPS - Excel Shortcut Keys

Great Excel Shortcut Keys

TIPS - Flash Fill

Flash Fill for faster results

TIPS - Freeze Headers

Freeze Headers for Scrolling

TIPS - Import a Table From The Web

Import a Table From The Web

TIPS - Line Breaks and Wrapping Text

Line Breaks and Wrapping Text

TIPS - Multiple Cells, Same Data

Update multiple cells with the same data quickly and easily.

TIPS - New Window for Second View

New Window for Second View to zoom in an work on specific data

TIPS - Paint Cells to a New Format

Paint Cells to a New Format

TIPS - Paste Special to Transpose

Transpose your data from vertical to horizontal

TIPS - Pull Data from Pictures

Pull Data from Pictures rather than typing it in manually

TIPS - Text to Columns

Split names or other text fields into multiple columns

TIPS - Use conditional formatting to make cells automatically change color based on data

Use conditional formatting to make cells automatically change color based on data

TIPS - Use filters to simplify your data

Use filters to simplify your data