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

Coursera Plus Flash Sale: All Certificates & Courses 40% Off. 72 Hours Only!
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.