Create a Worksheet
Excel provides a powerful set of tools and functionality for creating electronic spreadsheets. Get acquainted with Excel’s file creation and data management features. You can also explore how to optimize your documents for accessibility.
Create a Basic Worksheet
For an overview of creating files in Excel worksheets and workbooks, choose to review a text-based guide or view a more comprehensive video course from LinkedIn Learning.
NOTE: An Excel workbook is an Excel file that contains one or more worksheets.
- PC: Excel Essential Training
Links to an external site. (Video 2h 29m)
- NOTE: This LinkedIn Learning course covers creating and opening worksheets and workbooks, entering text and numbers, working with formulas, basic formatting, inserting charts and graphics, and sharing and printing workbooks
- PC: Create a New Workbook Links to an external site. (External resource)
- MAC: Excel for Mac Essential Training Links to an external site. (Video 3h 53m)
Add Numbers and Text
- PC: Exploring Data Entry, Editing and AutoFill Links to an external site. (Video 5m 8s)
- Working with Dates and Times Links to an external site. (Video 2m 43s)
- Mac: Enter Data Using AutoFill and Other Techniques Links to an external site. (Video 6m 1s)
- Mac: Copy and Paste Cell Data Links to an external site. (Video 3m 46s)
- Web: Available Number Formats in Excel Online Links to an external site. (External resource)
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.
- PC and Mac: Overview of Formulas in Excel Links to an external site. (External resource)
- PC and Mac: Excel Functions by Category Links to an external site. (External resource)
- Web: Overview of Formulas Links to an external site. (External resource)
Format Your Worksheet
Use Excel’s formatting capabilities to make your worksheets easier to read and understand, and also visually more interesting.
- PC: Exploring Font Styles and Borders Links to an external site. (Video 4m)
- PC: Color Backgrounds Links to an external site. (Video 3m 30s)
- PC: Adjust Row Heights and Column Widths Links to an external site.(Video 4m 48s)
- Mac: Apply Fonts, Background Colors, and Borders Links to an external site. (Video 6m 27s)
- Mac: Apply Number and Date Formats to Cells Links to an external site. (Video 4m 49s)
- Mac: Manage Text Alignment Links to an external site. (Video 4m 33s)
- Mac: Copy Cell Formats Links to an external site. (Video 4m 59s)
- Web: Format Numbers in Excel Online Links to an external site. (External resource)