No products in the cart.

Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access)

Highlights
Curriculum
Testimonial

The Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is the ultimate online bundle training program, designed for learners of all levels. It covers Microsoft Office 2016’s most fundamental functions and formulas, exploring five key programs; Word, Excel, PowerPoint, Outlook and Access. Taking you from beginner to expert, you will learn the basics such as how to personalise the interface, automate formulas, modify your slide presentations, organise your inbox, and many other fundamental administrative procedures.

This course can be studied on a full-time or part-time basis and applies to anyone who works in an office-based role, equipping you with core transferable skills, techniques and shortcuts required to boost your professional development and gain the confidence you need to master both simple and complex administrative tasks with ultimate proficiency.

Course Curriculum

Microsoft Word 2016
	Modify User Information	00:15:00
	Share a Document	00:30:00
	Work with Comments	00:15:00
	Compare Document Changes	00:15:00
	Review a Document	00:15:00
	Merge Document Changes	00:15:00
	Coauthor Documents	00:15:00
	Add Captions	00:15:00
	Add Cross-References	00:15:00
	Add Bookmarks	00:15:00
	Add Hyperlinks	00:15:00
	Insert Footnotes and Endnotes	00:15:00
	Add Citations	00:30:00
	Insert a Bibliography	00:15:00
	Insert Blank and Cover Pages	00:15:00
	Insert an Index	00:30:00
	Insert a Table of Contents	00:30:00
	Insert an Ancillary Table	00:15:00
	Manage Outlines	00:30:00
	Create a Master Document	00:30:00
	Suppress Information	00:30:00
	Set Editing Restrictions	00:30:00
	Add a Digital Signature to a Document	00:15:00
	Restrict Document Access	00:15:00
	Create Forms	00:30:00
	Manipulate Forms	00:15:00
	Form Data Conversion	00:15:00
	Create a New Document Version	00:30:00
	Compare Document Versions	00:15:00
	Merge Document Versions	00:15:00
	Activities – Microsoft Word 2016 Advanced	00:00:00
Microsoft Excel 2016
	Update Workbook Properties	00:15:00
	Activity-Update Workbook Properties	00:05:00
	Create and Edit a Macro	00:15:00
	Activity-Create and Edit a Macro	00:05:00
	Apply Conditional Formatting	00:15:00
	Activity-Apply Conditional Formatting	00:05:00
	Add Data Validation Criteria	00:15:00
	Activity-Add Data Validation Criteriaty	00:05:00
	Trace Cells	00:15:00
	Activity-Trace Cells	00:05:00
	Troubleshoot Invalid Data and Formula Errors	00:15:00
	Activity-Troubleshoot Invalid Data and Formula Errors	00:05:00
	Watch and Evaluate Formulas	00:15:00
	Activity-Watch and Evaluate Formulas	00:05:00
	Create a Data List Outline	00:15:00
	Activity-Create a Data List Outline	00:05:00
	Create Sparklines	00:15:00
	Activity_Create Sparklines	00:05:00
	Create Scenarios	00:15:00
	Activity-Create Scenarios	00:05:00
	Perform a What-If Analysis	00:15:00
	Activity-Perform a What-If Analysis	00:05:00
	Perform a Statistical Analysis with the Analysis ToolPak	00:15:00
	Activity-Perform a Statistical Analysis with the Analysis ToolPak	00:05:00
	Create Interactive Data with Power View	00:15:00
	Activity-Create Interactive Data with Power View	00:05:00
	Consolidate Data	00:15:00
	Activity-Consolidate Data	00:05:00
	Link Cells in Different Workbooks	00:15:00
	Activity-Link Cells in Different Workbooks	00:05:00
	Merge Workbooks	00:15:00
	Activity-Merge Workbooks	00:05:00
	Export Excel Data	00:15:00
	Activity-Export Excel Data	00:05:00
	Import a Delimited Text File	00:14:00
	Activity- Import a Delimited Text File	00:05:00
	Integrate Excel Data with the Web	00:15:00
	Activity-Integrate Excel Data with the Web	00:05:00
	Create a Web Query	00:15:00
	Activity-Create a Web Query	00:05:00
	Import and Export XML Data	00:15:00
	Activity-Import and Export XML Data	00:05:00
	Activities and Exercise Files – Microsoft Excel 2016 Advanced	00:00:00
Microsoft PowerPoint 2016
	Customize the User Interface	01:30:00
	Set PowerPoint 2016 Options	00:45:00
	Create and Manage Sections	01:00:00
	Modify Slide Masters and Slide Layouts	01:15:00
	Add Headers and Footers	00:30:00
	Modify the Notes Master and the Handout Master	00:45:00
	Create SmartArt	00:45:00
	Modify SmartArt	01:00:00
	Add Audio to a Presentation	00:45:00
	Add Video to a Presentation	01:00:00
	Customize Animations and Transitions	01:00:00
	Add Comments to a Presentation	00:45:00
	Review a Presentation	00:45:00
	Store and Share Presentations on the Web	01:30:00
	Annotate a Presentation	00:45:00
	Set Up a Slide Show	00:45:00
	Create a Custom Slide Show	00:30:00
	Add Hyperlinks and Action Buttons	00:45:00
	Record a Presentation	00:15:00
	Secure a Presentation	01:30:00
	Present a Slide Show Online	01:00:00
	Create a Video or a CD	00:45:00
	Activities – Microsoft PowerPoint 2016 Advanced	00:00:00
Microsoft Outlook 2016
	Insert Advanced Characters and Objects	01:30:00
	Modify Message Settings, Properties, and Options	01:30:00
	Use Automatic Replies	01:30:00
	Sort Messages	00:45:00
	Filter Messages	01:00:00
	Organize Messages	02:00:00
	Search Messages	01:30:00
	Manage Junk Mail	01:00:00
	Manage Your Mailbox	02:00:00
	Manage Advanced Calendar Options	00:45:00
	Manage Additional Calendars	01:00:00
	Manage Meeting Responses	00:45:00
	Assign and Manage Tasks	01:00:00
	Edit an Electronic Business Card	01:00:00
	Manage Advanced Contact Options	01:30:00
	Forward Contacts	00:30:00
	Export Contacts	01:00:00
	Delegate Access to Mail Folders	01:00:00
	Share Your Calendar	00:30:00
	Share Your Contacts	00:15:00
	Back Up Outlook Items	00:45:00
	Change Data File Settings	00:45:00
	Configure E-mail Message Security Settings	00:30:00
	Activities – Microsoft Outlook 2016 Advanced	00:00:00
Microsoft Access 2016
	Add Controls to Forms	01:00:00
	Set Form Controls	01:00:00
	Create Subforms	00:30:00
	Organize Information with Tab Pages	00:30:00
	Enhance Navigation with Forms	00:30:00
	Format a Form	01:00:00
	Apply Conditional Formatting	00:30:00
	Field Validation	00:30:00
	Form and Record Validation	00:30:00
	Create a Macro	01:00:00
	Restrict Records Using a Condition	00:30:00
	Validate Data Using a Macro	00:30:00
	Automate Data Entry Using a Macro	00:30:00
	Convert a Macro to VBA	00:30:00
	Link Tables to External Data Sources	00:30:00
	Manage a Database	00:30:00
	Determine Object Dependency	00:30:00
	Document a Database	00:30:00
	Analyze the Performance of a Database	00:30:00
	Split a Database for Multiple User Access	00:30:00
	Implement Security	00:30:00
	Set Passwords	00:30:00
	Convert an Access Database to an ACCDE File	00:30:00
	Package a Database with a Digital Signature	00:30:00
	Create a Database Switchboard	01:00:00
	Modify a Database Switchboard	00:30:00
	Set Startup Options	00:30:00
	Activities – Microsoft Access 2016 Advanced	00:00:00
Mock Exam
	Mock Exam- Microsoft Office 2016 Advanced	00:30:00
Final Exam
	Final Exam- Microsoft Office 2016 Advanced	00:30:00

Don't just take our word for it

Amazing workshop. Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.

Aarini Sinha

It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.

Varsha Sivamohan

I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.

Judith Taylor

The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable. I am very grateful for the support

Charlie Anderson

Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it. Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.

Parmjit Dosanjh

I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.

Shan

I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪

Sara Nana