Database Clinic: MS Excel

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.

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