Microsoft Office 2016 Advanced
Microsoft Office 2016 Advanced
Original price was: £425.£29Current price is: £29. ex Vat
Take This Course OR
1 Year Access 
Advanced
95 Students -
10 hours, 32 minutes
Introduction
Improve your admin skills, computer literacy and data analysis capabilities with this comprehensive online Microsoft Office course. Focussing on the industry-standard suite of administrative software, the Microsoft Office 2016 Advanced teaches you knowledge and expertise applicable to all areas of industry, boosting your confidence and enhancing your employability.
Course description
The Microsoft Office 2016 Advanced course is taught by expert instructors through easy-to-understand video tutorials, online study materials, and practical activities. You will gain a complete comprehension of using Microsoft Office software including creating documents using Word, managing data and spreadsheets in Excel, designing presentations in PowerPoint, as well as using Access for databases and maintaining your inbox with Outlook.
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
- Mock exams
- Multiple-choice assessment
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Will I receive a certificate of completion?
Upon successful completion you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Microsoft Office 2016 Advanced is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
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 | ||
Related Courses
Intermediate
Intermediate
Intermediate
Important Links
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.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add