Description
In this course, you will learn:
- How to deal with difficult people, manage change, and confront fears. Each lesson is tied to an accompanying practice, which will help you change the structure of your brain to respond better to stressors. Our world is changing rapidly. Evolve your mind to handle challenges with confidence.
Syllabus:
- Introduction
- Getting started with Excel for Office 365
1. Getting Started with Excel
- What is Excel used for?
- Using the Quick Access Toolbar and ribbon menu
- Shortcut menus and the Mini toolbar
- Understanding workbooks and worksheets
- Using Excel Help
2. Entering Data
- Exploring data entry, editing, and AutoFill
- Working with dates and times
- Using Undo and Redo
- Using 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 effects
- Applying borders and color backgrounds
- Adjusting row heights and column widths
5. Adjusting Worksheet Layout and Data
- Rows and columns: Insert, delete, hide, and unhide
- Moving, copying, and inserting data
- Finding and replacing data
6. Printing
- Page Layout view and commands
- Using Page Break Preview and print setup options
7. Charts
- Creating charts
- Exploring chart types
- Working with Excel Ideas
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
10. Data Management Features
- Sorting data
- Using filters
- Creating PivotTables
- New data types coming to Excel for 365
11. Sharing Workbooks
- Protecting worksheets and workbooks
- Sharing workbooks
- Tracking changes