ITS Online»Email, Calendar & MS Office»Excel

Excel

Getting Help in Microsoft Excel

Help you need is built right into Excel!

Click the question mark icon in the top right corner of Microsoft Excel to search for solutions to your problems, training, and more.

Online Resources

All of Microsoft’s help resources are also available online. Visit Microsoft’s Help and How-to Site to get started.

Microsoft Online Training Courses

Microsoft offers a series of 15-60 minute online training courses that can be completed from your desk at your own pace. Most trainings have an audio component, so be sure to wear headphones or turn up your speakers.

View a complete list of training courses

Don’t have headphones? Email ITS Help.

Course	What You’ll Learn
Excel Quick Start	Create a new workbook from scratch or use a template Save your workbook to OneDrive Create a chart Use conditional formatting Share your workbook with others Set up your Excel mobile app
Intro to Excel	Creat a new workbook Insert, delete, move, and copy worksheets Print a worksheet or workbook Use Excel as your calculator Fill data automatically in worksheet cells Create a dropdown list
Rows and Columns	Insert or delete rows and columns Freeze panes to lock rows and columns Hide or show rows or columns Filter for unique values or remove duplicate values Split text into different columns Create a list of sequential dates
Cells	Move or copy cells and cell contents Change column width or row height Find or replace text and numbers Merge and unmerge cells Apply data validation to cells Import or export text
Formulas and Functions	Create formulas Name cells and ranges Fix formula errors by tracing dependencies Explore available functions Calculations using functions
Formatting	Available number formats Utilize conditional formatting Align or rotate text in a cell Change the format of a cell Copy cell formatting Display or hide zero values
Tables	Create and format tables Sort data in a table Filter data in a table Use slicers to filter data
Charts	Create a chart from start to finish Add or remove titles in a chart Show or hide a chart legend or data table Add or remove a secondary axis Update the data in an existing chart
Share and Coauthor	Share workbooks with others Utilize comments and notes See files others have shared with you Lock or unlock specific areas of a protected worksheet Protect an Excel file Save or convert to PDF

LinkedIn Learning Training Courses

Course	What You’ll Learn
Excel Tips & Tricks	Covers powerful tips, tricks, and shortcuts that can help you leverage more of what Excel has to offer. Learn time-saving tricks for creating formulas rapidly, accelerating data entry, and navigating within worksheets efficiently. Plus, discover drag and drop techniques, formatting shortcuts, charting and PivotTable tips, and much more.
Excel Essential Training (Office 365)	Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, use the printing capabilities of Excel, and more.
Excel Advanced Formulas & Functions	Starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Provides practical examples to help viewers easily transition to using Excel’s most powerful formulas and functions in real-world scenarios.
Excel VLOOKUP & XLOOKUP for Beginners	Many Excel users hear “VLOOKUP” and envision a complicated function reserved only for power users. Not so! VLOOKUP—and XLOOKUP, the newer version for 365 subscribers—are among Excel’s most powerful functions, yet you can master them with a few simple steps. In this mini-course, Jess Stratton walks you step-by-step through creating a simple lookup in Excel using both VLOOKUP and XLOOKUP, then shows you how to error-proof your formulas. Supercharge your Excel skills and save time with these powerful lookup functions.