The Microsoft Office 2016 Excel Beginner provides thorough introductory training of Excel 2016. This course covers beginning-level skills, and is ideal for the newer computer user who wants to become well versed in Excel. Topics introduced include the Ribbon interface; entering and editing data; selecting cells and ranges; printing worksheets; creating formulas and functions; formatting cell contents; inserting and deleting columns, rows, and cells; charts, large worksheets and more.
Learning Outcomes:
- Recognize spreadsheet terminology; start Microsoft Excel and identify the components of the Excel interface; create a new workbook; open an existing workbook; navigate worksheets
- Create, format, modify, and print charts based on worksheet data; work with various chart elements; and apply chart types and chart styles
- Insert and modify a picture and SmartArt graphics; and represent data graphically
- Format and merge cells; apply number and color styles; use the Format Painter tool and setup conditional format rules
How is this qualification is delivered?
Our courses are taught entirely online, meaning you can access the materials wherever, whenever, at a pace that suits you, without formal deadlines or teaching schedules.
The courses are delivered through
- Video lessons
- PDF handouts
- Online assessment
These can be accessed through any device with an internet connection. Our e-learning platform is optimised for use on mobile, tablet, laptops and desktop computers.
How is the course assessed?
Our Microsoft Office 2016 Excel Beginner will ensure that you’re fully prepared for the exam. Successful completion of the exam – provided by the authorised awarding body – is a prerequisite to obtaining your qualification.
Course Curriculum
Getting Started with Microsoft Office Excel 2016 | |||
Navigate the Excel User Interface | FREE | 00:28:00 | |
Use Excel Commands | 00:10:00 | ||
Create and Save a Basic Workbook | 00:19:00 | ||
Enter Cell Data | 00:12:00 | ||
Use Excel Help | 00:05:00 | ||
Performing Calculations | |||
Create Worksheet Formulas | 00:15:00 | ||
Insert Functions | 00:17:00 | ||
Reuse Formulas and Functions | 00:17:00 | ||
Modifying a Worksheet | |||
Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
Search for and Replace Data | 00:09:00 | ||
Use Proofing and Research Tools | 00:07:00 | ||
Formatting a Worksheet | |||
Apply Text Formats | 00:17:00 | ||
Apply Number Format | 00:08:00 | ||
Align Cell Contents | 00:09:00 | ||
Apply Styles and Themes | 00:12:00 | ||
Apply Basic Conditional Formatting | 00:11:00 | ||
Create and Use Templates | 00:07:00 | ||
Printing Workbooks | |||
Preview and Print a Workbook | 00:10:00 | ||
Set Up the Page Layout | 00:08:00 | ||
Configure Headers and Footers | 00:07:00 | ||
Managing Workbooks | |||
Manage Worksheets | 00:05:00 | ||
Manage Workbook and Worksheet Views | 00:07:00 | ||
Manage Workbook Properties | 00:05:00 | ||
Mock Exam | |||
Mock Exam- Microsoft Office 2016 Excel Beginner | 00:20:00 | ||
Final Exam | |||
Final Exam- Microsoft Office 2016 Excel Beginner | 00:20:00 |
Course Reviews
No Reviews found for this course.