Microsoft Excel 365: Level 1 – ME-EXL365L1
Microsoft Office 365 Excel Level 1
Course Code: ME-EXL365L1
Microsoft Office Excel 365 Online is Microsoft’s cloud-based, easy-to-use spreadsheet program. This course is intended to help all users get up to speed with Excel 365 Online. By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professional and presentable. This one-day workshop will teach participants how to: – Create a new Spreadsheet – Navigate on the Application – Open save, share and print Workbooks – Using different Help Tools – Work with Data; Using the basics of Excel formulas ad functions – Formatting a Worksheet – Adding Pictures and Shapes; how to Insert and Modify Pictures – Organizing Worksheet Data with Tables and Charts. The training delivery is based on the desktop application and not on the online/browser version of the application.
- Duration: 1 Day
- Level: Introduction
- Technology: Microsoft Excel
- Delivery Method: Instructor Led
- Training Credits: NA
This course is intended to help all novice computer users become accustomed to working on Excel This manual is designed for users who are comfortable using Windows and Internet Explorer or Microsoft Edge.
There are no prerequisites for this course. Students should be comfortable using the keyboard and mouse Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft is necessary.
– Getting started with the app
– Working with formulas and functions
– Formatting parts of a worksheet
– Using pictures, tables, charts, and PivotTables
– Finalizing workbooks
There is no international certification linked to this course currently.
Modules
TOPIC A: GETTING TO KNOW EXCEL
– Microsoft 365 Excel
– What are Spreadsheets, Worksheets, and Workbooks?
– What are Columns, Rows, Cells, and Ranges?
– The Excel Interface
– Navigating in Excel
– Keyboard Navigation Options
– Activity 1-1: Getting to Know Excel
TOPIC B: CREATING WORKBOOKS
– The Ribbon
– The Backstage View
– Data Types
– Excel 365 File Formats
– The Save and Save As Commands
– Saving to Microsoft OneDrive
– Compatibility Mode
– The Convert Option
– The Compatibility Checker
– Checking for Accessibility Issues
– Activity 1-2: Creating Workbooks
TOPIC C: GETTING HELP IN EXCEL 365
– Using the Microsoft Search Box
– Accessing Advanced Help Options
– Activity 1-3: Getting Help in Excel 365
– Summary
– Review Questions
TOPIC A: A CLOSER LOOK AT FORMULAS
– Excel Formulas
– The Formula Bar
– Elements of an Excel Formula
– Mathematical Operators
– The Order of Operations
– Types of References
– Activity 2-1: A Closer Look at Formulas
TOPIC B: USING FORMULAS AND FUNCTIONS
– About Functions
– Creating a Function with AutoComplete
– Using the Insert Function Dialog Box
– Using AutoSum
– Viewing AutoSum Calculations in the Status Bar
– Automatic Workbook Calculations
– Activity 2-2: Using Formulas and Functions
TOPIC C: WORKING WITH DATA
– Selecting Cells
– The Cut, Copy, and Paste Commands
– Using Paste Options
– Live Preview
– The Transpose Option
– Moving Data with Drag and Drop
– The Undo and Redo Commands
– Using AutoFill
– Using Flash Fill
– Activity 2-3: Working with Data
TOPIC D: WORKING WITH ROWS AND COLUMNS
– Inserting Rows and Columns
– Deleting Rows and Columns
– Clearing Data from Cells
– Changing Column Width and Row Height
– The Hide and Unhide Options
– Activity 2-4: Working with Rows and Columns
TOPIC E: SORTING AND FILTERING DATA
– The Difference Between Sorting and Filtering
– Sorting Data
– Enabling Filtering
– Using the Filter Menu
– Using Text Filters
– Clearing a Filter
– Activity 2-5: Sorting and Filtering Data
– Summary
– Review Questions
TOPIC A: FORMATTING TEXT
– What is a Font?
– The Font Group
– The Format Cells Dialog Box
– The Format Painter
– Live Preview and Formatting
– The Mini Toolbar
– Creating Links
– Activity 3-1: Formatting Text
TOPIC B: FORMATTING CELLS
– Applying a Border
– Applying a Fill
– Changing the Number Format
– Formatted Numbers and Cell Width
– Customizing Number Formats
– Activity 3-2: Formatting Cells
TOPIC C: Aligning Cell Content
– Alignment Options
– The Indent Commands
– The Wrap Text Command
– Merge & Center Options
– Activity 3-3: Aligning Cell Content
TOPIC D: SEARCH FOR AND REPLACE DATA
– Cell Names and Range Names
– The Find Command
– The Replace Command
– The Go To Command
– Activity 3-4: Search for and Replace Data
TOPIC E: SPELL CHECK A WORKSHEET
– The Spelling Dialog Box
– Activity 3-5: Spell Checking a Worksheet
– Summary
– Review Questions
TOPIC A: DEFINE THE BASIC PAGE LAYOUT FOR A WORKBOOK
TOPIC OBJECTIVES
– The Print Options in Backstage View
– The Page Setup Dialog Box
– The Print Preview Option
– Workbook Views
– Headers and Footers
– Header and Footer Settings
– Page Margins
– Margins Tab Options
– Page Orientation
– Activity 4-1: Previewing a Workbook Before Printing
TOPIC B: REFINE THE PAGE LAYOUT AND APPLY PRINT OPTIONS
– Zoom Options
– Page Breaks
– Page Break Options
– The Print Area
– Print Titles
– Scaling Options
– Activity 4-2: Refining the Page Layout and Applying Print Options
– Review Questions
TOPIC A: FORMAT WORKSHEET TABS
– Renaming Worksheet Tabs
– Changing Tab Colour
– Activity 5-1: Formatting Worksheet Tabs
TOPIC B: MANAGE WORKSHEETS
– Grouped Worksheets
– Repositioning Worksheets
– Inserting or Deleting Worksheets
– Hiding and Unhiding Worksheets
– Worksheet References in Formulas
– Activity 5-2: Managing Worksheets
TOPIC C: MANAGE THE VIEW OF WORKSHEETS AND WORKBOOKS
– The Freeze Options
– The Split Command
– The Switch Windows Command
– The New Window Command
– Activity 5-3: Managing the View of Worksheets and Workbooks
– Summary
– Review Questions
TOPIC A: CUSTOMIZE GENERAL AND LANGUAGE OPTIONS
– The Excel Options Dialog Box
– The General Category
– The Language Category
– Activity 6-1: Customizing General and Language Options
TOPIC B: CUSTOMIZE FORMULA OPTIONS
– The Formulas Category
– Activity 6-2: Customizing Formula Options
TOPIC C: CUSTOMIZE PROOFING AND SAVE OPTIONS
– The Proofing Category
– The Save Category
– Version Control
– Activity 6-3: Customizing Proofing and Save Options
TOPIC D: CUSTOMIZE THE RIBBON AND QUICK ACCESS TOOLBAR
– The Customize Ribbon Category
– The Quick Access Toolbar Category
– Activity 6-4: Customizing the Quick Access Toolbar
TOPIC E: Understanding and Enabling Add-Ins
– What Are Add-ins?
– The Add-Ins Category
– The Developer Tab
– Activity 6-5: Understanding and Enabling Add-ins
TOPIC F: CUSTOMIZE ADVANCED AND TRUST CENTER OPTIONS
– The Advanced Category
– The Trust Center Category
– Activity 6-6: Customizing Advanced and Trust Center Options
– Summary
– Review Questions
– Course Wrap-Up
– Post-Course Assessment
– Course Summary
