Description:
Master Microsoft Office Suite and boost your proficiency in leading Microsoft programs with the best-selling Microsoft Office Applications Training course. This Microsoft Office training course includes time-saving techniques to advance your productivity in everyday office tasks and help you stand out to prospective employers.
Training online allows you to study in your own time at your convenience, from anywhere with an internet connection. Our expert, instructor-led training program, will guide you step-by-step through Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and other vital applications used for day-to-day Microsoft projects. You will learn how to make full use of each program’s functions and formulas to help you to become an expert in Office 365 in no time. Enrol today and add valuable transferable skills to your CV.
Your Learning Goals:
- Boost your proficiency in the Microsoft Office suite and master the features and functions of key Microsoft Office programmes
- Manage everyday administrative tasks with ease, with our instructor-led training modules
- Discover advanced tools, techniques and shortcuts to increase your productivity at work
- Stand out to employers and enhance your resume with valuable transferable office skills
- Be able to automate tasks in Word, create advanced spreadsheets, graphs and charts in Excel, plus much more.
- Develop the skills and knowledge to deliver compelling presentations in PowerPoint
- Learn from the experts and get round-the-clock customer service and tutor support.
- Get trained on how to manage your tasks and create, save and open documents
Who is this Course for?
Microsoft Office Applications Training is 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.
Entry Requirement:
- This course is available to all learners, of all academic backgrounds.
- Learners should be aged 16 or over to undertake the qualification.
- Good understanding of English language, numeracy and ICT are required to attend this course.
CPD Certificate from Course Gate
At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.
Career path
This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.
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 Applications Training | 00:20:00 | ||
Final Exam | |||
Final Exam – Microsoft Office Applications Training | 00:20:00 | ||
Certificate and Transcript | |||
Order Your Certificates or Transcripts | 00:00:00 |
Course Reviews
No Reviews found for this course.