This Excel Learning Path supports GW faculty, staff, and students who use Microsoft Excel and guides you how to use it within Microsoft 365. Follow this learning path in the order of the modules or choose topics to review.
Excel is a program for creating and editing electronic worksheets. Excel’s features include adding, editing, and formatting data, creating tables and charts and visualizing data trends.
NOTE: Prior to storing data in Excel, please refer to the GW’s Information Storage Guide. If you have questions on data categorization and security, contact the IT Support Center at [email protected].
Get to Know Excel
This document defines the differences and limitations of Excel for the web compared to the Desktop versions
Create a Basic Excel Workbook
An Excel workbook is an Excel file that contains one or more worksheets.
Use Formulas and Functions
The power of Excel comes in its ability to quickly and efficiently perform calculations. Learn how to write formulas or use Excel functions to perform these calculations.
Format Your Worksheet
Use Excel’s formatting capabilities to make your worksheets easier to read, understand, and visually more interesting.
Optimize your Excel Files for Accessibility Using Excel Features
An online document or tool is accessible when it can be easily understood by everyone, regardless of what browser or adaptive equipment he or she is using.
Ensuring your Excel Documents Meet GW Accessibility Guidelines
GW Information Storage Guidance
Prior to storing data in OneDrive, please refer to the GW’s Information Storage Guide. If you have questions on data categorization and security, contact the IT Support Center at [email protected].
Excel’s data management capabilities allow you to import data from external sources, sort and filter data, apply data validation rules, analyze data, and create reports and pivot tables.
Manage Your Data in Excel
Import Data from External Sources
Locating Data in Excel with VLOOKUP
Sort and Filter Your Excel Data
Excel’s sort and filter functions are useful when working with large amounts of data by allowing you to select and work with a subset of your data.
Apply Data Validation Rules to Your Data
Data validation allows you to define what type of data should be entered into a cell and to prevent invalid data from being entered.
Analyze Data with Excel
Excel’s data analysis tools allow you to perform simple to very complex data analysis.
Explore Excel's Data Visualization Tools
Excel’s data visualization tools, which includes tables, charts, and pivot tables will help you understand the significance of your data by placing it in a visual context.
Web: Add a Chart in Excel Online Not all chart types are available in Excel Online.
Microsoft 365 allows you to share Excel files with others to view as well as to collaborate on common documents. Get acquainted with some options for sharing and collaborating with others on Excel files.
Share Files Created in Microsoft 365
PC/Mac: Share Your Excel Workbook with Others
This resource applies to PC/Mac versions of Excel. Choose from Windows (PC) or Mac.
Collaborate on Files Created in Microsoft 365
801 22nd Street, NW B101
Washington, DC 20052