Menu
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.


Additional Links

Below are some additional product and information links on Excel for you to explore.

Latest Tips

contact

All student/alumni email addresses will transition from @pennlaw.upenn.edu to @penncareylaw.upenn.edu over two year period

Exams

Important info on preparing your laptop for an Examplify exam.