Microsoft office academic 2016
Different customisation and view options - this could be hiding or un-hiding columns and rows, customising the popular quick access toolbar or modifying document properties.
#MICROSOFT OFFICE ACADEMIC 2016 HOW TO#
You may also be tested on workbook themes and how to change them, altering the height or width of rows and columns, and inserting headers and footers into a worksheet Formatting topics - renaming a worksheet, changing tab colours, modifying page setups or worksheet orders, or inserting and deleting columns/rows.Navigating around worksheets and workbooks - this could look at searching for data in a workbook, navigating to specific cells, range or a workbook element, or inserting and removing hyperlinks.Creation of worksheets and workbooks - including importing data from a delimited text file, adding worksheets to existing workbooks, and copying or moving a worksheet.This official Microsoft exam could include questions based on the following topics: What does the MS Excel 2016 course cover? Look at the usage of macros, including their creation, editing and the options of macro security.Familiarise yourself with the options of protecting and sharing the workbook content.Learn to prepare a table or entire worksheet before printing.Also, examine the insertion of various graphical elements into worksheets i.e.Focus on the creation of charts and automation of the work in the program using macros.Examine how to split longer text entries in tables into individual data placed into several columns.Study searching for specific values in extensive tables.Familiarise yourself with the advanced options of sorting and filtering data.
#MICROSOFT OFFICE ACADEMIC 2016 SERIES#
This package is made up of three courses: What are the MS Excel online course modules?