Course Information
Course Name
EXC19B/EXC0365B: Microsoft Excel 2019 / O365 Basic
Exam code
MO-200
Duration
1 Day
Certification
Microsoft Office 2019 OR O365
Overview
Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel 2019 can help.
It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Audience Profile
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2019 that is necessary to create and work with electronic spreadsheets.
Prerequisites
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse.
At Course Completion
Upon successful completion of this course, you will be able to:
Get started with Microsoft Office Excel 2019.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Create Charts and Sparkline
Print workbooks.
Manage workbooks.
Course Outline
Module 1: The Basics
Creating a New Workbook
Understand the Basic Parts of a Workbook
Saving a Workbook
Opening a Workboo
Module 2: Your First Workbook
Selecting Data
Entering and Deleting Data
Using Undo and Redo
Using Cut, Copy, and Paste
Module 3: Working with Data
Inserting Rows and Columns
Merging and Splitting Cells
Moving Cells
Using Paste Special
Using Find and Replace
Hiding and Unhiding Cells
Module 4: Using Timesaving Tools
Using AutoFill
Using Flash Fill
Using AutoSum
Using AutoComplete
Using AutoCalculate
Module 5: Formatting Text
Changing the Font Face, Size, and Color
Applying Text Effects
Applying Borders and Fill
Using the Font Tab of the Format Cells Dialog
Clearing Formatting
Module 6: Formatting Data
Wrapping Text
Changing the Size of Rows and Columns
Adjusting Cell Alignment
Changing Text Direction
Changing Number Format
Module 7: Charting Data
Creating Sparklines
Inserting Charts\
Module 8: Viewing, Printing, and Sharing Your Workbook
Using Views
Saving a Workbook as PDF or XPS
Printing a Workbook
Module 9: Customizing the Interface
Changing Ribbon Display Options
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes
Â
All Microsoft certification courses are conducted by certified trainers from Iverson.
Digital Methods acts as the official training partner and assists with program consultation, registration, coordination, scheduling, and administrative arrangements to ensure a seamless and professionally managed training experience.