|
Microsoft Excel 365: Part 1
Code:
MS Excel 365 P1
Duration:
1 Day
|
$295
USD
|
Welcome to the first part of our Microsoft 365 Excel courseware. Excel is Microsofts powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data.
Most of the features Microsoft incorporated in Office 2019 already exist in Office 365. Office 365 is a great solution for those looking for Office 2019 Training.
This course is available in the following formats:
Duration: 1 Day
Duration: 1 Day
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
This course is intended to help all novice computer users get up to speed with Excel quickly. The course will cover:
- Getting started with the app
- Working with formulas and functions
- Modifying worksheets
- Printing workbook contents
- Managing workbooks
- Customizing the Excel environment
Lesson 1: Getting Started
- Topic A: Getting to Know Excel
- Topic B: Creating Workbooks
- Topic C: Getting Help in Excel 365
- Topic D: Working with Rows and Columns
- Topic E: Sorting and Filtering Data
Lesson 2: Working with Data
- Topic A: A Closer Look at Formulas
- Topic B: Using Formulas and Functions
- Topic C: Working with Data
Lesson 3: Modifying a Worksheet
- Topic A: Formatting Text
- Topic B: Formatting Cells
- Topic C: Aligning Cell Content
- Topic D: Search For and Replace Data
- Topic E: Spell Check a Worksheet
Lesson 4: Printing Workbook Contents
- Topic A: Define the Basic Page Layout for a Workbook
- Topic B: Refine the Page Layout and Apply Print Options
Lesson 5: Managing Large Workbooks
- Topic A: Format Worksheet Tabs
- Topic B: Manage Worksheets
- Topic C: Manage the View of Worksheets and Workbooks
Lesson 6: Customizing the Excel Environment
- Topic A: Customize General and Language Options
- Topic B: Customize Formula Options
- Topic C: Customize Proofing and Save Options
- Topic D: Customize the Ribbon and Quick Access Toolbar
- Topic E: Understanding and Enabling Add-Ins
- Topic F: Customize Advanced and Trust Center Options
Lesson 1: Getting Started
- Topic A: Getting to Know Excel
- Topic B: Creating Workbooks
- Topic C: Getting Help in Excel 365
- Topic D: Working with Rows and Columns
- Topic E: Sorting and Filtering Data
Lesson 2: Working with Data
- Topic A: A Closer Look at Formulas
- Topic B: Using Formulas and Functions
- Topic C: Working with Data
Lesson 3: Modifying a Worksheet
- Topic A: Formatting Text
- Topic B: Formatting Cells
- Topic C: Aligning Cell Content
- Topic D: Search For and Replace Data
- Topic E: Spell Check a Worksheet
Lesson 4: Printing Workbook Contents
- Topic A: Define the Basic Page Layout for a Workbook
- Topic B: Refine the Page Layout and Apply Print Options
Lesson 5: Managing Large Workbooks
- Topic A: Format Worksheet Tabs
- Topic B: Manage Worksheets
- Topic C: Manage the View of Worksheets and Workbooks
Lesson 6: Customizing the Excel Environment
- Topic A: Customize General and Language Options
- Topic B: Customize Formula Options
- Topic C: Customize Proofing and Save Options
- Topic D: Customize the Ribbon and Quick Access Toolbar
- Topic E: Understanding and Enabling Add-Ins
- Topic F: Customize Advanced and Trust Center Options
This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Excel is necessary.