Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Database Clinic: MS Excel

via LinkedIn Learning

Overview

Get up to speed with Microsoft Excel. Learn how to enter and organize data, build charts and PivotTables, sort data, and use other Excel features.

Syllabus

Introduction
  • Getting started with Excel for Microsoft 365
  • The future of Excel
1. Getting Started with Excel
  • What is Excel used for?
  • The Ribbon menu and the Quick Access Toolbar
  • Shortcut menus and the Mini toolbar
  • Understanding workbooks and worksheets
  • Use Excel Help
  • Accessibility features in Excel
2. Entering Data
  • Exploring data entry, editing, and AutoFill
  • Working with dates and times
  • Using Undo and Redo
  • Use Save or Save As
3. Formulas and Functions
  • Using simple formulas
  • Copying a formula into adjacent cells
  • Using SUM and AVERAGE
  • XLOOKUP and lookup functions
4. Formatting
  • Exploring font styles and borders
  • Color backgrounds
  • Adjusting row heights and column widths
  • Applying numeric formats
5. Adjusting Worksheet Layout and Data
  • Rows and columns: Insert, delete, hide, and unhide
  • Moving, copying, and inserting data
  • Finding and replacing data
6. Adjusting Page Layout and Printing
  • Page Layout view and commands
  • Using Page Break Preview and print setup options
7. Charts
  • Creating charts
  • Exploring chart types
8. Adjusting Worksheet Views
  • Freezing and unfreezing panes
  • Splitting screens horizontally and vertically
9. Multiple Worksheets and Workbooks
  • Renaming, inserting, and deleting sheets
  • Moving, copying, and grouping sheets
  • Opening, closing, and saving workbooks
10. Data Management Features
  • Sorting data
  • Using filters
  • Creating PivotTables
11. Security and Sharing
  • Protecting worksheets and workbooks
  • Sharing workbooks and tracking changes
Conclusion
  • Continuing your Excel journey

Taught by

Curt Frye

Reviews

4.8 rating at LinkedIn Learning based on 52587 ratings

Start your review of Database Clinic: MS Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.