• LOGIN
  • No products in the basket.

Login

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

4.7

4.7
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE OR ALL COURSES FOR £69.99
  • £24.99
  • 1 year
  • Course Certificate
  • Number of Units23
  • Number of Quizzes2
  • 4 hours, 55 minutes
2 STUDENTS ENROLLED