Description:

Are looking forward to learning each and every single details of Microsoft Office 2016? Then you are at the right place!

Microsoft Office 2016 Essentials is designed for beginners to educate about Microsoft Office 2016. Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the foundations of Microsoft Office Excel that is essential to create and work with an electronic spreadsheet. You will be able to insert and delete text, adjust cells, create columns, rows and much more. Next, Microsoft PowerPoint will help you to learn to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc.

Microsoft Outlook will help you to set up and use Outlook on Windows. It will also assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and much more.

Overall, this course gives you all information to access Microsoft Office 2016. Register today and get benefit from this course.

Learning Outcomes:

• Word 2016 user interface, creating basic documents and utilizing help
• Managing text through modifying, finding and replacing, and selecting them; and arranging texts through tabs and lists
• Understanding the commands on the home tab and mini toolbar
• Paragraph layout tool, borders, shading, styles and formatting management techniques
• Maximizing your ability to utilize tables within Word 2016
• Inserting symbols and special characters along with techniques for adding them
• Managing your page’s appearance with colours, borders, watermarks, headers, footers and page setup dialog box
• Reviewing documents through spell check, research pane and thesaurus
• Document accessibility options
• Customizing the user interface, modifying save options and managing other file types
• Familiarize the excel user interface, creating basic worksheet and using the help system
• How to create formulas, reuse them and insert functions in a worksheet
• Managing cells, columns and rows and ways to manipulate data
• Utilizing the ‘Search and replace’ data options and spell checking
• Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles
• Define and refine page layouts for printing options
• Managing large workbooks through worksheet tab formatting and using different views
• Options for general customization, language, formula, proofing and saving
• Customizing Quick Access toolbar, ribbon, advanced and Trust Center options
• Utilize Excel’s version control features and enabling add-ins
• Utilize the PowerPoint user interface, creating and saving  presentations, and using help
• Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation
• Discover methods for formatting characters, paragraphs, and text boxes
• Adding images, screenshots, screen recordings, shapes and WordArt
• Modifying options for objects and animation features
• Creating and formatting a table and integrating data from other Microsoft Office applications
• Create format and manipulate a chart
• Navigate throughout the Outlook user interface and learn to perform basic email functions and utilize help
• Composing emails, grammar and spell checks, formatting content, attaching files, enhancing messages and managing automatic message responses
• Customize reading options, work with attachments and manage message responses
• Managing and organization of messages with the help of tags, flags, other commands and folders
• Using calendar options to manage appointments and meetings
• Using People workspace to create, update, view and organise contacts
• Managing tasks and notes
• Creating and managing Quick Steps, and customizing the interface according to needs
• Get familiarized with Microsoft Access 2016, create simple databases, and use the help options
• Change table data, manage records, and create lookups
• Join data from different tables, sort and filter them, and perform calculations for queries
• Creating, adding controls, enhancing appearance and print preparation for reports
• How to utilize Access Options dialog box
• Relational database design, creating tables, managing table fields and creating table relationships
• Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets
• Data normalization and creating junction tables
• Sharing Access data with other applications and through import and export options
• Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones
• Create mailing label report and publishing reports in PDF format

Assessment:

• At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.
• Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

• After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.
• Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

Microsoft Office 2016 Essentials is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our Microsoft Office 2016 Essentials is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.