Training Course in Advanced Microsoft Office Skills

Course Description

This Training Course in Advanced Microsoft Office Skills offered by Phoenix Center for Policy, Research and Training is a comprehensive program designed to enhance participants' proficiency in various advanced computer skills. In today's digital age, having strong computer skills is essential for productivity, efficiency, and competitiveness in the workplace. This course aims to equip participants with advanced techniques and knowledge across multiple computer applications and tools, enabling them to excel in their roles and contribute to organizational success.

Advanced Microsoft Office skills go beyond the basic actions you can complete in the Microsoft Office suite. They require a deep understanding of and proficiency in using various features and tools within Microsoft Office applications. Microsoft Office includes popular tools like:

• PowerPoint: Used to create presentations using slides
• Word: Used to create text documents such as letters and reports
• Teams: Used for workspace chats and video conferencing
• Excel: Used to calculate, format, and organize data in spreadsheets
• Outlook: Used for email communication within the Microsoft Exchange Server
• SharePoint: Used to create websites
• Access: Used to store and organize large amounts of data

Course Objectives

Upon the successful completion of this Training Course in Advanced Microsoft Office Skills, participants will be able to:

• Develop advanced proficiency in computer applications and tools.
• Enhance their productivity and efficiency in day-to-day computer tasks.
• Learn advanced techniques for data management and analysis.
• Explore advanced features and functionalities of commonly used software.
• Develop skills in automating repetitive tasks and improving workflow.
• Enhance knowledge of cybersecurity best practices.
• Learn advanced techniques for creating professional presentations.
• Gain proficiency in project management and collaboration tools.
• Develop skills in multimedia creation and editing.
• Enhance problem-solving and troubleshooting skills related to computer applications.

Training Methodology

The course is designed to be highly interactive, challenging and stimulating. It will be an instructor led training and will be delivered using a blended learning approach comprising of presentations, discussions, guided sessions of practical exercise, case study review, web-based tutorials, group work, exploration of relevant issues collaborative strength training, performance measurement, and workshops of participants’ displays, all of which adhere to the highest standards of training. The training technique is built on learning by doing, with lecturers using a learner-centered approach to engage participants and provide tasks that allow them to apply what they’ve learned. Experiential knowledge is also given equal importance within the format of training. Our facilitators are seasoned industry professionals with years of expertise in their chosen fields. All facilitation and course materials will be offered in English.

Who Should Attend?

This Training Course in Advanced Microsoft Office Skills would be suitable for, but not limited to:

• Office Managers
• Administrative Assistants
• Data Analysts
• IT Professionals
• Project Managers
• Researchers
• Entrepreneurs
• Any other professional seeking to enhance their computer skills

Course Content

Module 1: Advanced Microsoft Excel Skills

• Auditing formulas
• Excel functions – VLOOKUP, HLOOKUP, and INDEX-MATCH
• Using pivot tables and pivot charts to summarize and analyze data
• Implementing macros and automation to streamline repetitive actions
• Complex data analysis and modeling when using data
• Data validation and conditional formatting
• Using array formulas and functions for multiple simultaneous calculations
• Transforming data using Power Query

Module 2: Advanced Microsoft Word skills

• Advanced formatting, such as styles and creating templates
• Personalizing communication using mail merge
• Creating table of contents, footnotes, endnotes, and bibliographies
• Customizing page layouts
• Collaborating on documents using whiteboards and tracking changes
• Using cross-references and bookmarks
• Automating tables of figures and indexes
• Using fields to insert dynamic content, like dates, automatically
• Creating interactive fields like dropdown menus and checkboxes
• Adding watermarks to documents
• Inserting files from other Office applications, such as an Excel spreadsheet

Advanced Microsoft PowerPoint skills

• Creating interactive presentations with hyperlinks and buttons
• Creating and using animations and transitions
• Customizing slide masters
• Designing custom motion paths for objects in slides
• Embedding multimedia elements, like audio, video, and quizzes
• Collaborative editing and comments
• Recording presentations with voiceover commentary

Advanced Microsoft Outlook skills

• Efficiently managing inboxes by creating advanced rules, filters, folders to organize emails by sender, subject, and other criteria
• Creating and using email templates
• Developing multiple email signatures for specific recipients and contexts
• Configuring out-of-office and automated responses
• Using Quick Steps to automate tasks, like email forwarding
• Effectively managing, sharing, and scheduling calendars
• Clearly organizing contacts and tasks
• Advanced email search
• Creating conditional formatting for email fonts and signatures based on certain conditions
• Collaborating using shared calendars, setting custom access permissions for colleagues

Advanced Microsoft Access skills

• Create complex databases and tables using relational database design principles such as normalization
• Develop fields, expressions, and conditional logic for data gathering
• Design and run advanced queries using SQL (Structured Query Language)
• Build relationships between tables
• Automate tasks with macros and triggering actions based on user inputs
• Create forms for data input
• Design custom reports and visualizations
• Build parameterized queries to collect user input
• Divide databases into two parts: a front-end for forms or reports and a back-end for tables

Advanced Microsoft OneNote skills

• Organize notes using custom notebooks, sections, and pages
• Create and use note templates
• Collaborate on and share notebooks
• Embedding files, images, and videos
• Tagging and categorizing notes
• Search and index content
• Link notes and create to-do lists
• Use math tools to develop and edit equations

Advanced Microsoft SharePoint skills

• Create and manage site structures, collections, and subsites, as well as document libraries and lists
• Develop custom site templates
• Design forms using ​​Microsoft InfoPath and using them within SharePoint
• Use versioning and document sets to manage documents
• Set up permissions and access controls
• Use SharePoint Designer to create custom workflows
• Integrating with other Office apps
• Create and customize web pages
• Collaborating on team sites and project management

Advanced Microsoft Teams skills

• Use advanced meeting options like breakout rooms and virtual lobbies
• Implement advanced settings like queues and attendants for inbound calls
• Pinning files and messages within Teams chat conversations
• Share images, code, and other multimedia and rich text formatting within Teams messages
• Use keyboard shortcuts to prompt certain actions
• Hosing large meetings or virtual events with audience management tools
• Create and manage channels with user permissions, names, descriptions, and pinned posts
• Implement Microsoft Bot Framework to create task automations within Teams
• Integrating with other Office apps
• Manage and integrate tasks with Microsoft Planner

Requirements

• Participants should be reasonably proficient in English.
• Applicants must live up to Phoenix Center for Policy, Research and Training admission criteria.

NOTE

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free
2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.
3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.
4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.
5. Approval of Course: Our Programs are NITA Participating organizations can therefore claim reimbursement on fees paid in accordance with NITARules.

Booking for Training

Simply send an email to the Training Officer on training@phoenixtrainingcenter.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254737566961

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Phoenix Center for Policy, Research and Training Limited should be paid in advance, 5 days to the training.
2. Invoice: We can send a bill directly to you or your company.
3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.
2. Participants may cancel attendance 14 days or more prior to the training commencement date.
3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor Made Courses

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location. For further inquiries, please contact us on Tel: +254720272325 / +254737566961 or Email training@phoenixtrainingcenter.com  

Accommodation

Accommodation is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@phoenixtrainingcenter.com or on Tel: +254720272325 / +254737566961