The Ultimate Office Training Programme includes the full suite of Microsoft Office training courses:
- Excel
- Advanced Excel
- PivotTables
- PowerPoint
- Word
- Effective Outlook
- SharePoint
Each course includes our bespoke learning ‘Filter’ to identify your current training requirements and tailor the course content to your exact level of experience. Each individual training course includes certifications in attainment and accomplishment.
Overview - The Ultimate Office Training Programme:
--
Course 1 – Microsoft Excel:
Business ready core skills training.
Course Highlights:
- Consists of 38 business focused Excel units from our syllabus
- Contains 100 hours of learning materials but can be completed in as little as 12 hours of dedicated study
- 24/7 access to all learning materials from the date you register
- Available in all the main versions of Excel (PC: 2003, 2007, 2010 and 2013, 2016 / 365; Mac: 2011)
- Taught through a blend of text-based articles, practice spreadsheets, video tutorials and podcasts
- Comes with email support from our experts.
Syllabus:
- Section 1: Introduction to Excel (5 Modules)
- Section 2: Orientation & Efficiency (7 Modules)
- Section 3: Administration (6 Modules)
- Section 4: Data Handling (6 Modules)
- Section 5: Data Analysis (9 Modules)
- Section 6: Presentation (5 Modules)
--
Course 2 – Advanced Microsoft Excel:
Take your training to the next level and demystify some of the most complex business relevant areas of Microsoft Excel.
Course Highlights:
- Consists of 20 Advanced Excel training modules
- 160 easy to follow instructional videos with accompanying interactive exercises
- Available in all the main versions of Excel (PC: 2003, 2007, 2010 and 2013, 2016 / 365; Mac: 2011)
- Comes with email support from our experts.
Syllabus:
- Section 1: Design and Risk (3 Modules)
- Section 2: Advanced Techniques (6 Modules)
- Section 3: Excel Interactivity (2 Modules)
- Section 4: Spreadsheet Impact (5 Modules)
- Section 5: Turning Data into Decisions (4 Modules)
--
Course 3 – Pivot Tables:
Analyse and present data quickly and easily using PivotTables. PivotTables are one of Microsoft Excel's most useful, powerful and misunderstood features. Learn to master them!
Highlights:
- Identify the primary uses of PivotTables and when to use them
- Identify ‘best’ and ‘worst’ entries in data sets
- Filter, sort and group PivotTable data to maximise its usefulness
- Present your findings clearly and compellingly using PivotCharts and Conditional Formatting
- Customise calculations to ensure PivotTable data is tailored to your requirements
- Use PivotTables to summarise data for management reports
- Work with PivotTables based on OLAP cubes
- Use Slicers to synthesise and emphasise data across multiple PivotTables
- Use PivotTables to build interactive dashboards
Syllabus:
- Section 1: Orientation, best practice, overview (6 modules)
- Section 2: PivotTables for Data Analysis (5 Modules)
--
Course 4 – Microsoft PowerPoint:
Make beautiful, impressive, effective slides with PowerPoint. Whether for yourself or for your business, our online course will teach you the basics and beyond of how to put together outstanding PowerPoint presentations.
Course Highlights:
- Consists of 23 interactive training modules
- Contains 20 hours of learning materials but can be completed in as little as 12 hours of dedicated study
- Provides 24/7 access to all learning materials from the date you register
- Taught through a blend of text-based articles, practice exercises, video tutorials and multiple choice quizzes and tests
Syllabus:
- Section 1: Foundation in PowerPoint (5 Modules)
- Section 2: Basic Slide Editing (5 Modules)
- Section 3: Administration and Efficiency (4 Modules)
- Section 4: Tables (5 Modules)
- Section 5: Making an Impact (4 Modules)
--
Course 5 – Microsoft Word:
Become a Wordsmith with our tailored online Microsoft Word course.
The syllabus uses our vast analytical experience, wide-ranging research and thorough refinement to establish which Word functions and techniques are most useful.
Course Highlights:
- Consists business focused Word units from our distilled syllabus
- Contains 20 hours of learning materials but can be completed in as little as 12 hours of dedicated study
- Provides 24/7 access to all learning materials from the date you register
- Taught through a blend of text-based articles, practice exercises, video tutorials and multiple choice quizzes and tests
Syllabus:
- Section 1: Foundation (6 Modules)
- Section 2: Basics (6 Modules)
- Section 3: Common Tasks (6 Modules)
- Section 4: Administration (5 Modules)
- Section 5: Taking Word Further (3 Modules)
--
Course 6 – Effective Outlook:
Email is the most widely used form of business communication, but also one of the main causes of lost productivity in the workplace. Managing tasks and meetings is crucial to working effectively and professionally, so proficiency with emails and email-management systems has a powerful impact on day-to-day productivity and success of businesses.
Course Highlights:
- Consists business focused Word units from our distilled syllabus
- Contains 20 hours of learning materials but can be completed in as little as 12 hours of dedicated study
- Provides 24/7 access to all learning materials from the date you register
- Taught through a blend of text-based articles, practice exercises, video tutorials and multiple choice quizzes and tests
Syllabus:
- Section 1: Introduction, Personal Productivity, Structure (5 Modules)
- Section 2: Email Management, Search (7 Modules)
- Section 3: Appointments, Meetings, Contacts (5 Modules)
- Section 4: Outlook Advanced – Linking, Synchronisation (3 Modules)
- Section 5: Course Plenary (1 Module)
--
Course 7 – Sharepoint:
SharePoint has been referred to as the ‘Swiss Army Knife’ of collaboration software suites. It has over 100 million users worldwide and is used by over 78% of Fortune 500 companies.
As companies and organisations globalise and economies interweave, teams are increasingly separated by geography, time zones, languages and cultural differences. No matter the environment, SharePoint helps turn individuals into high-performing project teams.
Course Highlights:
- 15 hours of learning material
- Techniques and tricks from SharePoint experts
- Video summaries
- Worked examples with screenshots
- Downloadable templates, Exercises & Multiple-choice tests
Syllabus:
- Section 1: Introduction and Course Structure (4 Modules)
- Section 2: SharePoint Basics (5 Modules)
- Section 3: Sharing Content with SharePoint (5 Modules)
- Section 4: Sharing Knowledge with SharePoint (2 Modules)
- Section 5: Sharing Work with SharePoint (4 Modules) Section 6: Sharing Information with SharePoint (3 Modules)
-------------------------------------------------
Testimonials - Trustpilot:
“One of the best investments I have ever made” - John, USA.
“Skillsology is an excellent training site. Lifetime membership is outstanding and a no brainer to sign up” - Anonymous, UK.
“Fantastic Tool! Just started to use, but very easy to get a grasp on and easy to swap between module's and whilst I am quite computer literate am learning new tips and tricks every time I use it! - Peter, UK.
“Great courses! Would highly recommend to others. Taught me so much more than I ever expected, really valuable training and excellent customer service - Brooke, USA.
“Excellent company, very easy to use. I've been a customer of Skillsology for years, and I really like this company. Their customer service is friendly, responsive, and very easy to work with. - Caty, UK.
