Microsoft Office 2016 Excel for Beginners

This Microsoft Office 2016 Excel for Beginners – Video Course covers the basic functions and features of Excel 2016. In this course you will get to know Excel 2016 by performing calculations. You will learn to modify and format worksheets, how to print and manage workbooks, work comfortably with Microsoft Excel 2016 and many of its advanced features, learn what is new in Excel 2016, be much quicker at carrying out regular tasks, use sophisticated functions that will improve the quality of your work. Here you will learn from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.

You can get this course if want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Why Should You Choose Microsoft Office 2016 Excel for Beginners – Video Course

• Internationally recognised accredited qualification
• 1 year accessibility to the course
• Free e-Certificate
• Instant certificate validation facility
• Properly curated course with comprehensive syllabus
• Full-time tutor support on working days (Monday – Friday)
• Efficient exam system, assessment and instant results
• Access to the course content on mobile, tablet or desktop from anywhere anytime
• Eligible for **NUS Extra** card which gives you 1000’s of discounts from biggest companies.

Course Curriculum

Getting Started with Microsoft Office Excel 2016

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help

Performing Calculations

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions

Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

Formatting a Worksheet

• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Printing Workbooks

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

Managing Workbooks

• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties