Microsoft Office 2016 Advanced
Microsoft Office 2016 Advanced
Original price was: £425.£29Current price is: £29. ex Vat
Save 93.18 % - ENDS SOON
OR
Or
Take All courses for £49
1 Year Access 
Advanced
108 Students -
10 hours, 32 minutes
Get access to 5000+ courses including this for
Overview
Empower your career journey with our in-demand course: Microsoft Office 2016 Advanced
Boost your proficiency and propel your career forward with our meticulously crafted course, designed to be your ultimate guide to professional development. Our super-accessible modules break down complex topics into bite-sized, easy-to-understand lessons, filling your knowledge gaps and equipping you with real-world, practical skills.
Seeking career advancement and application of your skills? You’ve found the right place. This Microsoft Office 2016 Advanced is your exclusive passport to unlocking your full potential.
Enroll today and enjoy:
- 100% online flexibility: Learn at your own pace, from anywhere in the world.
- Expert support: We're by your side throughout your journey, providing guidance and assistance.
- Comprehensive curriculum: Dive deep into relevant topics aligned with industry standards.
- Practical focus: Apply your learnings to real-world scenarios and situations.
This sought-after course is your key to a successful and lucrative career. Don’t miss out on this transformative opportunity. Enroll now and take your professional life to the next level!
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Exam & Retakes
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.
Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).
Course Curriculum
| Microsoft Excel Advanced | |||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Sharing and Protecting Workbooks | |||
| Collaborate on a Workbook | 00:19:00 | ||
| Protect Worksheets and Workbooks | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Use the Goal Seek Feature | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
| Microsoft Word Advanced | |||
| Manipulating Images | |||
| Integrate Pictures and Text | 00:15:00 | ||
| Adjust Image Appearance | 00:09:00 | ||
| Insert Other Media Elements | 00:02:00 | ||
| Using Custom Graphic Elements | |||
| Create Text Boxes and Pull Quotes | 00:06:00 | ||
| Add WordArt and Other Text Effects | 00:05:00 | ||
| Draw Shapes | 00:07:00 | ||
| Create Complex Illustrations with SmartArt | 00:08:00 | ||
| Collaborating on Documents | |||
| Prepare a Document for Collaboration | 00:09:00 | ||
| Mark Up a Document | 00:06:00 | ||
| Review Markups | 00:04:00 | ||
| Merge Changes from Other Documents | 00:06:00 | ||
| Adding Document References and Links | |||
| Add Captions | 00:06:00 | ||
| Add Cross References | 00:08:00 | ||
| Add Bookmarks | 00:05:00 | ||
| Add Hyperlinks | 00:06:00 | ||
| Insert Footnotes and Endnotes | 00:05:00 | ||
| Add Citations and a Bibliography | 00:11:00 | ||
| Securing a Document | |||
| Suppress Information | 00:07:00 | ||
| Set Formatting and Editing Restrictions | 00:06:00 | ||
| Restrict Document Access | 00:02:00 | ||
| Add a Digital Signature to a Document | 00:04:00 | ||
| Using Forms to Manage Content | |||
| Create Forms | 00:09:00 | ||
| Modify Forms | 00:03:00 | ||
| Automating Repetitive Tasks with Macros | |||
| Automate Tasks by Using Macros | 00:10:00 | ||
| Create a Macro | 00:19:00 | ||
| Microsoft PowerPoint Advanced | |||
| Customize the User Interface | 00:19:00 | ||
| Set PowerPoint 2016 Options | 00:07:00 | ||
| Modify Slide Masters and Slide Layouts | 00:16:00 | ||
| Add Headers and Footers | 00:05:00 | ||
| Modify the Notes Master and the Handout Master | 00:04:00 | ||
| Create SmartArt | 00:09:00 | ||
| Modify SmartArt | 00:05:00 | ||
| Write Math Equations | 00:07:00 | ||
| Add Audio to a Presentation | 00:09:00 | ||
| Add Video to a Presentation | 00:10:00 | ||
| Customize Animations and Transitions | 00:14:00 | ||
| Review a Presentation | 00:15:00 | ||
| Store and Share Presentations on the Web | 00:06:00 | ||
| Annotate a Presentation | 00:07:00 | ||
| Set Up a Slide Show | 00:08:00 | ||
| Create a Custom Slide Show | 00:03:00 | ||
| Add Hyperlinks and Action Buttons | 00:07:00 | ||
| Record a Presentation | 00:05:00 | ||
| Secure a Presentation | 00:11:00 | ||
| Broadcast a Slide Show | 00:07:00 | ||
| Create a Video or a CD | 00:08:00 | ||
| Microsoft Access Advanced | |||
| Add Controls to Forms | 00:11:00 | ||
| Enhance Navigation and Organization of Forms | 00:14:00 | ||
| Apply Conditional Formatting | 00:04:00 | ||
| Import Data into Access | 00:08:00 | ||
| Export Access Data | 00:06:00 | ||
| Link Tables to External Data Sources | 00:05:00 | ||
| Create a Mail Merge | 00:02:00 | ||
| Create a Macro | 00:08:00 | ||
| Restrict Records by Using a Condition | 00:04:00 | ||
| Validate Data by Using a Macro | 00:05:00 | ||
| Automate Data Entry by Using a Macro | 00:04:00 | ||
| Manage a Database | 00:08:00 | ||
| Determine Object Dependency | 00:04:00 | ||
| Manage a Database | 00:07:00 | ||
| Document a Database | 00:04:00 | ||
| Splitting a Database for Multiple User Access | 00:05:00 | ||
| Implement Security | 00:03:00 | ||
| Convert an Access Database to an ACCDE File | 00:04:00 | ||
| Package a Database with a Digital Signature | 00:01:00 | ||
| Create a Database Switchboard | 00:05:00 | ||
| Modify a Database Switchboard | 00:02:00 | ||
| Set Start up Options | 00:04:00 | ||
| Order Your Certificate | |||
| Order Your Certificate Now | 00:00:00 | ||
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
