Office 365 Master eLearning Bundle Course



Course Details:

Length: 18 courses

Access Length: 6 months

Price: $900/person (USD)

Bulk Pricing: 10+ Contact Us

Course Features:

Instant Access After Purchase

Lecture by Recorded Video

Stop and Start as Needed

Certificate of Completion

Software Lab Included?: Yes

Delivery Method:

Self-Paced Online

Individuals and Groups
@ Your Location

 


Course Overview

Unleash Your Productivity Powerhouse: The Office 365 Master eLearning Bundle - Master the essential Microsoft Office 365 tools and become a productivity champion!

This comprehensive eLearning bundle equips you with the skills to conquer every task, from crafting stunning presentations to automating complex workflows.

What's inside?

  • 14 in-depth courses: Dive into Excel, Word, PowerPoint, Access, Outlook, and the Outlook Web App, mastering both foundational and advanced concepts.
  • 55+ hours of expert-led video training: Learn at your own pace with clear explanations, step-by-step demonstrations, and engaging examples.
  • Real-world skills you can use immediately: No fluff, practical knowledge to boost your efficiency and effectiveness in any work environment.

Here's a sneak peek of what you'll achieve:

  • Access: Build powerful databases, manage information efficiently, and create custom reports to gain valuable insights.
  • Excel: Become a spreadsheet wizard, manipulating data, crafting insightful charts, and automating tasks with ease.
  • Outlook: Master your email organization, leverage calendar tools, and explore advanced features for ultimate control.
  • Outlook Web App: Work flawlessly on any device, accessing your email, calendar, and contacts with the web app's convenient features.
  • PowerPoint: Design presentations that impress, utilizing animations, transitions, and advanced graphic features.
  • Word: Write captivating documents, format like a pro, and collaborate seamlessly with colleagues.

Benefits you can't ignore:

  • Save time and money: Learn at your own pace, avoiding expensive in-person training.
  • Boost your career: Equip yourself with in-demand skills that impress employers.
  • Gain confidence: Conquer any task with your newfound Office 365 expertise.

Ready to unlock your full potential? Enroll today and experience the power of the Office 365 Master eLearning Bundle!

Also Included - 4 Courses: An Essential Career Skills Pack with 4 courses in key areas for career management and growth, including Time Management, Digital Skills, Creativity and Soft Skills.

 


Course Notes


Important Course Information
Course Taught with: Microsoft Office 365 for Windows ().
Versions that Can Attend: Desktop and Online Versions of Office 365 for Windows () or Macintosh (Mac) - iOS ().

eLearning Training Delivery Method

How It Works

This self-paced online course lets you learn independently at your own pace through Certstaffix Training's easy-to-use platform.

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screenshots
  • 6-month subscription length
  • Instant Access After Purchase

Have more than 10 students needing this course? Contact Us for bulk pricing.

Suggested Prerequisites
Prerequisites:

To ensure your success in this course, you should have end-user skills with any current version of Windows, including starting programs, switching between programs, locating saved files, closing programs, and using a browser to access websites. You can obtain this level of skills and knowledge by taking either the Windows 10 eLearning Bundle or the Windows 11 eLearning Bundle.

Learning Objectives:
  • Gain proficient skills in all major Office 365 applications: Excel, Word, PowerPoint, Access, Outlook, and the Outlook Web App.
  • Master both foundational and advanced concepts: Move beyond basic functionality and unlock the full potential of each application.
  • Optimize personal productivity: Learn to automate tasks, manage information efficiently, and work smarter, not harder.
  • Enhance career prospects: Equip yourself with in-demand skills relevant to various workplace settings.
  • Build confidence and mastery: Become comfortable and independent navigating Office 365 tools.
Target Audience

Professionals seeking to upskill or reskill:

  • Individuals looking to refresh their existing Office 365 knowledge or learn new applications from scratch.
  • Career changers or job seekers aiming to add valuable skills to their resume.
  • Employees interested in boosting their productivity and gaining recognition in their current roles.

Students preparing for academic or professional careers:

  • College students seeking practical skills for internships, projects, or future jobs.
  • High school students preparing for college or entry-level positions.
  • Individuals in vocational training programs requiring strong Office 365 proficiency.
Key Features
  • Audio Narration
  • Video
  • Inline Activities
  • Exercises
  • Supplemental Resources
  • Assessment
Languages
  • Audio/Video/Course Text: American English.
  • Subtitles (Closed Caption): American English, Arabic, Brazilian Portuguese, Canadian French, Chinese (Simplified), Chinese (Traditional), Dutch, French, German, Hindi, Indonesian, Italian, Japanese, Korean, Latin American Spanish, Russian, Spanish, Thai, Turkish, and Vietnamese.
Course Duration
  • Office 365 Master Bundle: 56 hrs 52 min
  • Essential Career Skills Pack: 2 hrs 23 min

 


Course Topics

Access 365: Beginner

Course Duration - 4 hrs 40 min

This course is an introduction to Microsoft Access 365. Students will become familiar with various database components, concepts, and terminology in this course. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course.

Course Objectives:
Course Objectives:
  • Master the foundations of databases: Understand core concepts and terminology like database structures, tables, fields, and record relationships.
  • Navigate the Access 365 interface confidently: Familiarity with ribbons, objects, views, and navigation tools for efficient operation.
  • Design and create databases: Implement database design principles to build effective databases with appropriate tables and structures.
  • Work with tables efficiently: Manipulate table data through editing, sorting, filtering, and utilizing sub datasheets for better organization and analysis.
  • Understand and write basic queries: Craft simple queries to retrieve specific data from tables based on various criteria and operators like AND/OR, wildcards, and keywords.
  • Work with calculated fields: Add functionality to tables by creating calculated fields for performing calculations on existing data.
  • Master reporting features: Explore different report types, understand design principles, and utilize tools like AutoReport and Report Wizard to create visually appealing reports.
  • Design and manage forms: Understand form types, create effective forms for data entry and editing, and utilize controls and layout tools for user-friendly interfaces.
  • Leverage advanced features: Utilize lookup wizards for data lookup across tables, implement indexes for optimized data retrieval, and explore more complex query-building techniques.
  • Prepare for intermediate learning: Build a solid foundation in Access 365 concepts and skills, preparing for further progress in the intermediate course.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Getting Started with Access
  • What is a Database
  • Understanding Database Terminology
  • Navigating the Access Interface
  • Understanding Table Relationships
  • Relating Tables
Working with Data
  • Working with Tables
  • Navigating Tables
  • Editing Data
  • Sorting and Filtering Records
  • Using Subdatasheets
Creating Databases and Objects
  • Understanding Database Design Principles
  • Creating Tables
  • Using Table Data Sheet View
  • Using Table Design View
  • Working with Field Data Types
  • Using Calculated Fields
  • Calculating Numbers
  • Calculating Dates
  • Calculating Strings
  • Using the Lookup Wizard
  • Lookup Wizard Linking Tables
  • Using Indexes
Working with Select Queries
  • What Are Queries
  • Creating Simple Queries
  • Entering Criteria - Exact Match and Range Operators
  • Understanding AND Versus OR
  • Using Wild Cards
  • Using Key Words
  • Creating a Calculated Field in a Query
Working with Reports
  • What Are Reports
  • Understanding Report Types
  • Building Good Reports
  • Using AutoReport
  • Understanding the Report Wizard
  • Using the Report Design View
  • Printing Reports
  • Creating Labels
Working with Forms
  • What Are Forms
  • Understanding Form Types
  • Creating Forms
  • Navigating Forms
  • Editing Data in Forms
  • Understanding the Form Wizard
  • Using the Form Design View
  • Working with Controls
  • Using Form Layout View
Conclusion


 

Access 365: Intermediate

Course Duration - 4 hrs 15 min

This course is designed to teach students intermediate-level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.

Course Objectives:
Course Objectives:
  • Design & optimize tables for accurate data entry: Master table design principles, set field sizes, formats, and captions, control data entry with validation rules and input masks.
  • Share data across applications: Seamlessly export tables and queries to Excel, SharePoint lists, external data sources, and use Word Merge for efficient document generation.
  • Leverage the power of Action Queries: Understand their purpose, create Update, Append, Delete, and Make Table queries to manipulate data efficiently.
  • Master advanced query techniques: Modify query joins, use self-joins for data analysis, create Find Unmatched and Find Duplicate queries, build Parameter queries for dynamic search, and explore Top X and Crosstab queries.
  • Automate tasks with Macros: Gain foundational knowledge of Macros, automate form opening based on records, validate data entry, and design macros for automatic data entry tasks.
  • Enhance user experience with advanced forms: Utilize conditional formatting, manage label names, organize fields with tab controls, create option groups and combo boxes, and integrate subforms for related data display.
  • Craft professional reports: Add charts, present data in columns, insert subreports for detailed information, configure reports with parameters, and learn how to send reports directly.
  • Build a foundation for Advanced Access 365: This course prepares you for further learning in advanced topics like data analysis, automation, and complex database applications.
  • Develop problem-solving skills: The course emphasizes practical applications and scenarios, enabling you to analyze problems and apply learned techniques to solve real-world data management challenges.
  • Boost productivity and efficiency: By automating tasks, optimizing data entry, and designing informative reports, you'll significantly improve your workflow and data handling proficiency.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Designing Tables for Better Data Entry
  • Reviewing Table Design Principles
  • Setting Field Size, Formats, and Captions
  • Setting Default Values and Required Fields
  • Restricting Data Entry - Validation Rules
  • Restricting Data Entry - Input Masks
  • Sharing Data with Other Applications
    • Exporting Tables and Queries to Excel
    • Exporting Data to a Sharepoint List
    • Importing Data from Excel
    • Importing Data from a Sharepoint List
    • Linking External Data Sources
    • Using Word Merge
Working with Action Queries
  • What Are Action Queries
  • Creating an Update Query
  • Creating an Append Query
  • Creating a Delete Query
  • Creating a Make Table Query
  • Changing Start Number of an Auto Number Field
Advanced Query Technique
  • Modifying Query Joins
  • Using Self Joins to Combine Data
  • Creating Find Unmatched and Find Duplicate Queries
  • Creating Parameter Queries
  • Creating a Top X Query
  • Reviewing Calculated Query Fields
  • Summarizing Query Data with Totals
  • Creating a Crosstab Query
Automating Processes with Macros
  • Understanding Macro Basics
  • Creating Macros to Open Forms by Record
  • Validating Data Entry with Macros
  • Creating a Macro to Automate Data Entry
  • Advanced Data Entry Using Macros and Dlookup Functions
Advanced Form Techniques
  • Using Conditional Formatting
  • Working with the New Label Name Property
  • Organizing Form Fields with Tab Controls
  • Creating an Option Group Control
  • Creating a Combo Box Control
  • Configuring a Combo Box Control to Show Search Results
  • Using a Subform to Show Data from a Related Table
Advanced Report Techniques
  • Inserting a Chart on a Report
  • Showing Data in Columns
  • Inserting a Subreport
  • Configuring Reports with Parameter Queries
  • Sending Reports
Conclusion


 

Access 365: Advanced

Course Duration - 1 hr 43 min

Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.

Course Objectives:
Course Objectives:
  • Optimize Database Structure: Utilize the Table Analyzer Wizard, append queries, and junction tables to enhance data organization and efficiency.
  • Implement Effective Database Maintenance: Master backup procedures, database compaction and repair, object dependencies, documentation, and performance analysis.
  • Craft Intuitive Navigation: Design and adapt Navigation Forms to guide users effortlessly through your database.
  • Secure Multi-User Access: Employ the Database Splitter, configure trusted locations, and implement password protection for databases and modules.
  • Automate Repetitive Tasks: Leverage VBA (Visual Basic for Applications) to write code and automate routine processes, maximizing your productivity.
  • Gain Control with Table Events: Understand and utilize Before Change and After Update events to manipulate data and customize user interaction.
  • Export Data with Versatility: Use VBA to export tables and queries to other applications or formats, increasing data availability and sharing.
  • Enhance Security with ACCDE Files: Convert your database to an ACCDE file to encrypt the VBA code and protect intellectual property.
  • Master VBA Control Flow: Explore advanced variables and control flow statements like loops and IF statements to build complex automated functions.
  • Develop Custom Functionality: Translate existing macros into VBA code, unlocking the full potential of custom functions and user interface enhancements.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Improving the Structure of a Database
  • Using the Table Analyzer Wizard
  • Append Querying to Normalize a Table
  • Creating a Junction Table
Maintaining a Database
  • Backing Up a Database
  • Using the Compact and Repair Database Tool
  • Using the Object Dependencies Tool
  • Using the Database Documenter Tool
  • Using the Analyze Performance Tool
Working with Navigation Forms and Startup Options
  • Creating a Navigation Form
  • Modifying a Navigation Form
  • Setting the Startup Options
Configuring Access for Multiple Users
  • Using the Database Splitter
  • Configuring Trusted Locations
  • Password Protecting a Database
  • Password Protecting Modules
  • Converting a Database to an ACCDE File
Automating Processes
  • Understanding VBA Basics
  • Exploring Variables and Control Flow Statements
  • Exporting a Table or Query with VBA
  • Converting a Macro to VBA
Using Table Events
  • Understanding Table Events
  • Using the Before Change Event Command
  • Using the After Update Event Command
Conclusion


 

Excel 365: Beginner

Course Duration - 4 hrs 46 min

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. This course gives an introduction to Excel via the Office 365 Suite. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Course Objectives:
Course Objectives:
  • Learn the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets
  • Enter data, format spreadsheets, manipulate columns and rows, add headers and footers
  • Use page setup options to prepare them for printing
  • Handle large worksheets or multiple workbooks
  • Use styles and themes, and insert various graphic objects
  • Learn the options for proofing your workbooks
Detailed Course Outline:
Detailed Course Outline:
Introduction

Getting Started with Excel
  • What is Microsoft Excel
  • Opening Excel
  • Navigating the Interface and Using the Ribbon
  • Understanding the Excel Worksheet Components
  • Defining Worksheet Dimensions
  • Using the Backstage View
Creating Workbooks and Using Templates
  • Creating a New Workbook
  • Saving an Excel Workbook
Entering Data
  • Navigating a Worksheet by Mouse or Keyboard
  • Understanding Excel Data Types
  • Understanding Cell and Range Addressing
  • Using Various Data Selection Techniques
  • Working with Common Excel Commands
  • Copying, Moving, and Pasting Data
  • Copying, Moving, and Pasting Data
  • Using Flash Fill
  • Using Autofill
Excel Formula Basics
  • Understanding Formulae and Functions
  • Understanding the Structure of a Formula
  • Understanding Calculation Hierarchy and the Order of Operations
  • Creating Basic Formulae
Managing Columns and Rows
  • Modifying Columns and Rows
  • Hiding and Unhiding Columns and Rows
Formatting Cells
  • Formatting and Aligning Data
  • Merging Data
  • Wrapping Text and Adjusting Orientation
  • Formatting Numbers
  • Using the Format Painter
  • Removing Formatting Quickly
Using Cell Styles and Themes
  • Using Cell Styles
  • Using Themes
Inserting Objects and Graphics
  • Inserting and Formatting Images
  • Inserting and Formatting Smartart
  • Working with Icons
  • Inserting Hyperlinks
  • Inserting Symbols and Equations
  • Inserting Wordart and Text Boxes
  • Inserting 3d Models
  • Arranging Objects
Proofing a Workbook
  • Using Find and Replace
  • Using Go to and Go to Special
  • Using the Spell Checker
  • Using the Thesaurus and Translation Features
  • Using the Resolve Feature
  • Using the Accessibility Checker
Printing an Excel Workbook
  • Printing and Previewing Excel Files
  • Creating Custom Margins and Scaling
  • Adding Headers and Footers
  • Formatting a Page with the Page Layout Tab
  • Printing Titles and Specific Worksheet Areas
  • Exporting to Pdf and Xps
Managing Worksheets
  • Renaming and Coloring Worksheet Tabs
  • Adding, Deleting, and Navigating Worksheets
  • Hiding and Unhiding Worksheets
Navigating and Viewing Excel Files
  • Viewing Workbooks
  • Using Zoom Tools
  • Configuring Sheet Options
  • Using the Freeze Panes and Split Commands
  • Adjusting Workbook Properties
  • Viewing Workbook Statistics
Conclusion


 

Excel 365: Intermediate

Course Duration - 4 hrs 31 min

In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.

Course Objectives:
Course Objectives:
  • Link workbooks and worksheets: Work with range names
  • Sort and filter range data, and analyze and organize with tables
  • Apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines
  • Use PivotTables, PivotCharts, and slicers
  • Work with advanced PivotTables and PowerPivot features
Detailed Course Outline:
Detailed Course Outline:
Introduction

Working with Range Names
  • Linking Workbooks and Worksheets
  • Linking Worksheets with 3d References
  • Understanding the Consolidate Feature
Working with Range Names
  • What Are Range Names
  • Creating Range Names Using the Name Box and Define Name
  • Creating Range Names Using Create from Selection
Sorting, Filtering, and Subtotaling
  • Understanding the Differences Between Sorting and Filtering
  • Sorting Lists
  • Filtering Lists
  • Creating Subtotals
Analyzing and Organizing with Tables
  • Creating Tables and Understanding the Benefits
  • Understanding the Elements of a Table
  • Formatting a Table
  • Sorting and Filtering Tables
  • Filtering with Slicers
  • Calculating with Tables
  • Removing Erroneous Table Data
  • Exporting, Refreshing, and Converting Tables
Using Conditional Formatting
  • What is Conditional Formatting
  • Conditional Formatting-highlight Cells and Top Bottom Rules
  • Conditional Formatting-data Bars, Icon Sets, and Color Scales
  • Using Custom Fonts and Colors
  • Using Custom Conditional Formatting
  • Modifying or Removing Conditional Formatting
Displaying Data Graphically
  • What Are Charts
  • Creating Charts
  • Understanding Chart Elements
  • Modifying Chart Elements
  • Changing and Moving Charts
  • Filtering a Chart
  • Formatting Charts
  • Creating Dual Axis Charts
  • Forecasting with Trendlines
  • Creating a Chart Template
  • Displaying Trends with Sparklines
Understanding PivotTables, PivotCharts, and Slicers
  • What is a Pivottable
  • Creating a Pivottable
  • Working with the Pivottable Fields Pane
  • Basic Data Organization and Analysis with Pivottables
  • Formatting Pivottables
  • Creating a Pivotchart
  • Modifying and Formatting a Pivotchart
  • Adding Slicers and Timeline Slicers
  • Formatting Slicers
  • Using the Analyze Data Feature
Working with Advanced PivotTables and PowerPivot Features
  • Using the Pivottable and Pivotchart Wizard
  • Adding a Calculated Field
  • Adding a Calculated Item
  • Applying Conditional Formatting to a Pivottable
  • Creating Filter Pages for a Pivottable
  • Analyzing Multiple Tables with a Pivottable
Conclusion


 

Excel 365: Advanced

Course Duration - 4 hrs 20 min

This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Course Objectives:
Course Objectives:
  • Define advanced concepts and formulas and collaboration features of Excel 365
  • Use functions such as SUMIF, AVERAGEIF, and COUNTIF
  • Explore advanced lookup functions, and complex logical and text functions
  • Experiment with auditing formulas and error checking
  • Use the What-If Analysis tools
  • Identify the options for worksheet and workbook protection
  • Review advanced use of PivotTables and PowerPivot add-in
  • Ensure data integrity in worksheets and workbooks
Detailed Course Outline:
Detailed Course Outline:
Introduction

Customizing the Excel Environment
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar
  • Customizing the General and Formula Options
  • Customizing the Autocorrect Options
  • Customizing the Save Defaults
  • Customizing Advanced Excel Options
Analyzing Data with Logical Functions
  • Working with the Most Common Logical Functions
  • Summarizing Data with Countif
  • Summarizing Data with Maxifs and Minifs
  • Using the Iferror Function
  • Understanding the if Function
  • Evaluating Data with the and Function
  • Evaluating Data with the or Function
  • Creating a Nested if Formula
  • Using the Ifs Functions
  • Nesting and and or Inside an if Function
  • Summarizing Data with Sumif
  • Summarizing Data with Averageif
Working with Lookup Functions
  • What Are Lookup Functions
  • Comparing Two Lists with Vlookup and Isna
  • Using Vlookup
  • Using Hlookup
  • Using Vlookup with True
  • Using Hlookup with True
  • Using the Index Function
  • Using the Match Function
  • Combining Index and Match
  • Comparing Two Lists with Vlookup
Using Text Functions
  • What Are Text Functions
  • Using Concat, Concatenate, and Textjoin
  • Using Text to Columns
  • Using Left, Right, and Mid Functions
  • Using Upper, Lower, and Proper Functions
  • Using the Len Function
  • Using the Trim Function
  • Using the Substitute Function
Working with Date and Time Functions
  • What Are Date and Time Functions
  • Using Today, Now, and Day Functions
  • Using Networkdays and Yearfrac Functions
  • Using the Datevalue Function to Convert Text Dates
Formula Auditing
  • Showing Formulas
  • Tracing Precedents and Dependants
  • Adding a Watch Window
  • Error Checking
What-IF Analysis
  • Using the Scenario Manager
  • Using Goal Seek
  • Analyzing with Data Tables
Worksheet and Workbook Protection
  • Understanding Protection
  • Encrypting Files with Passwords
  • Allowing Specific Worksheet Changes
  • Adding Protection to Selected Cells
  • Additional Protection Features
  • Protecting the Structure of an Entire Workbook
Automating with Macros
  • What Are Macros
  • Displaying the Developer Tab
  • Creating a Basic Formatting Macro
  • Running a Macro
  • Assigning a Macro to a Button
  • Creating Complex Macros
  • Viewing and Editing the Vba Code
Enhancing a Worksheet with Form Controls
  • What Are Form Controls
  • Adding Spinners and Check Boxes
  • Adding a Combo Box
Validating Data
  • What is Data Validation
  • Restricting Data Entry to Whole Numbers
  • Restricting Data Entry to a List
  • Restricting Data Entry to a Date
  • Restricting Data Entry to Specific Text Lengths
  • Finding Invalid Data
  • Editing and Deleting Data Validation Rules
Collaborating in Excel
  • Working with Comments
  • Printing Comments and Errors
  • Sharing a Workbook
  • Tracking Changes in a Workbook
  • Working with Versions
  • Sharing Files Via Email
Importing and Exporting Data
  • Importing a Text File
  • Exporting Data to a Text File
Conclusion


 

Outlook 365: Beginner

Course Duration - 3 hrs 38 min

This course is designed to teach students the basics of Microsoft Outlook 365 and help them gain familiarity with the Outlook environment and basic functionality. Students will learn the basics of email, how to use the Help feature, create and send messages, and work with attachments. Students will also learn organizational techniques through the use of folders, views, categories, flags, and searching. Additionally, students will review printing options, automatic replies, contact creation and management, calendar use and management, task and note creation and management, message options, and email signatures.

Course Objectives:
Course Objectives:
  • Navigate and understand the Outlook 365 interface.
  • Create and send basic email messages in Outlook.
  • Compose emails using dictation and format them effectively.
  • Respond to emails with various options like forwarding, replying, and marking importance.
  • Attach files to emails, proofread messages, and print them when needed.
  • Organize your inbox using folders, favorites, filters, and categories.
  • Create and manage appointments and meetings in the calendar, including responses and cancellations.
  • Create and edit contacts, manage contact groups, and add contacts from various sources.
  • Work with tasks and notes to manage your to-do list and reminders.
  • Increase your efficiency with features like Focused Inbox, signatures, quick steps, email scheduling, search, and Read Aloud.
Detailed Course Outline:
Detailed Course Outline:
Introduction
  • Introduction
A First Look at Outlook
  • Getting Started with Outlook
  • Navigating and Understanding Outlook
  • Opening Messages
  • Adjusting Reading Options
  • Using Conversation View
Creating and Sending Messages
  • Creating a Basic Email
  • Creating an Email Using Dictation
  • Formatting an Email
  • Mentioning in Outlook
  • Responding to Emails
  • Alternate Replies to Emails
  • Marking Importance
  • Working with Attachments
  • Proofing Emails
  • Printing Messages
  • Recall A Sent Email
Managing and Organizing the Outlook Mailbox
  • Working with Folders
  • Creating and Editing Favorites
  • Filtering and Sorting Messages
  • Organizing Emails with Color Categories and Flags
  • Deleting and Recovering Messages
Managing the Calendar
  • Navigating the Calendar
  • Working with Appointments and Meetings
  • Managing Meeting Responses
  • Cancelling Meetings
Managing People and Contacts
  • Creating and Editing Contacts
  • Creating and Working with Contact Groups
  • Adding Contacts from Meetings and Messages
Managing Tasks and Notes
  • Working with Tasks
  • Working with Notes
Increasing Efficiency with Outlook
  • Using Focused Inbox
  • Creating and Using Signatures
  • Out of Office Replies
  • Using Read Aloud
  • Using the Search and Command Bar
  • Using Quick Steps
  • Scheduling Emails
Conclusion
  • Recap


 

Outlook 365: Advanced

Course Duration - 2 hrs 13 min

In this course, students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 365. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data.

Course Objectives:
Course Objectives:
  • Modify and manage advanced message options, including tracking, delivery, and voting.
  • Leverage contact options effectively for improved organization and communication.
  • Optimize calendar features for advanced scheduling and management.
  • Create and utilize email templates for efficient communication.
  • Automate tasks using Quick Parts and advanced rule creation.
  • Implement advanced search techniques for finding specific information efficiently.
  • Master advanced graphic options for visually engaging emails.
  • Effectively configure junk mail options to combat unwanted messages.
  • Import and export data seamlessly to manage Outlook information.
  • Develop a comprehensive backup strategy to protect your Outlook data.
Detailed Course Outline:
Detailed Course Outline:
Introduction
  • Introduction
Customizing the Outlook Experience
  • Modifying View Settings
  • Modifying Mail Options
  • Using Voting Options
  • Modifying Contact Options
  • Using the Weather Bar
Rules and Automation
  • Creating Email Templates
  • Automating with Quick Parts
  • Creating and Managing Rules
  • Modifying Desktop Alerts
  • Advanced Search Options
Advanced Outlook Options
  • Inserting Tables
  • Inserting SmartArt
  • Inserting Hyperlinks
  • Inserting Symbols and Lines
  • Advanced Customization and Working with Data Files
Maintaining Your Outlook Environment
  • Cleaning up the Mailbox
  • Backing Up Data
  • Configuring Junk Mail Options
Conclusion
  • Conclusion


 

Microsoft 365 Outlook Web App: Beginner

Course Duration - 2 hrs 42 min

This comprehensive course teaches you how to use the Office 365 Outlook Web App and covers both basic functions and more advanced features. Once you’ve familiarized yourself with the Outlook web environment, you’ll review the basics of Outlook email, including attaching files, formatting text, and working with the conversation view. Next, you’ll learn how to manage your mailbox by using Sweep and creating and editing rules that automate actions. You’ll explore effective ways of organizing your mail by using folders and the Clutter feature and gain tips on managing your contacts and customizing your Outlook web environment. You'll also learn about creating meetings and working with shared calendars.

Course Objectives:
Course Objectives:
  • Navigate the Outlook Web App interface: Learn the various views and functionalities within the application.
  • Compose and manage emails: Create, format, reply to, delete, and schedule emails with attachments.
  • Master inbox organization: Utilize Sweep, flags, rules, folders, Focused Inbox, and Groups to manage your emails efficiently.
  • Customize your workspace: Modify the app environment to suit your preferences, including BCC visibility and read receipts.
  • Collaborate effectively: Manage contacts, create and attend meetings, and share calendars.
  • Schedule and manage tasks: Utilize the "To Do" feature to create and track tasks.
  • Automate actions: Set up rules to streamline email management based on pre-defined criteria.
  • Utilize advanced features: Explore functionalities like "recall sent message" and "printing emails."
  • Gain proficiency in conversation view: Effectively track email threads and respond efficiently.
  • Set up and manage the "Out of Office" feature: Inform others of your absence and automate responses.
Detailed Course Outline:
Detailed Course Outline:
Introduction
  • Getting Started with Outlook Online
Getting Started with Outlook Online
  • Navigating the Outlook Views
  • Working with the My Day View
  • Creating a New Email Message and Attaching Files
  • Pinning a Message
  • Showing BCC and Using Read Receipts
Working with Email
  • Replying to and Deleting Emails
  • Formatting Email Text
  • Working with Conversation View
  • Working With Unread Email
  • Printing Emails
  • Recall a Sent Message
  • Scheduling Emails
Managing the Outlook Mailbox
  • Using Sweep
  • Flagging Emails
  • Creating and Editing Rules
Organizing Mail
  • Creating and Moving Folders
  • Working With Folders
  • Searching for Emails
  • Using the Focused Inbox
  • Using Groups
Customizing Outlook
  • Customizing the Environment
  • Setting Out of Office
Working with Contacts
  • Working With Contacts
Exploring the Calendar
  • Exploring the Calendar View
  • Adding a Calendar Appointment or Meeting
  • Searching and Adding Calendars
  • Sharing and working with a Shared Calendar
Working with Tasks
  • Working with To Do
Conclusion


 

PowerPoint 365: Beginner

Course Duration - 4 hrs 38 min

In this course, students will get started with PowerPoint 365 and become familiar with the Ribbon, interface, and navigation options. Additionally, students will create a presentation and work with various features and commands to make it easier to work in PowerPoint. Students will also review presentation editing options, text formatting options, graphic options, insertion methods, how to add, edit, and format tables and charts in a presentation, and various presentation preparation and delivery options.

Course Objectives:
Course Objectives:
  • Master the Basics: Get comfortable with the PowerPoint 365 interface, Ribbon, and navigation options.
  • Craft Compelling Presentations: Learn how to build presentations from scratch, adding text, slides, and themes.
  • Enhance Slide Text: Discover techniques for formatting text with character styles, paragraphs, and numbered lists.
  • Work with Visuals: Master picture insertion, resizing, arranging, effects, and shape management.
  • Present Data Effectively: Add, edit, and format tables and charts to illustrate information clearly.
  • Polish Your Work: Explore editing options like moving and copying slides and content.
  • Deliver with Confidence: Learn presentation proofing, printing, and delivery techniques, including Presenter View.
  • Navigate PowerPoint Views: Understand different views like Normal, Outline, Slide Sorter, and Notes Page.
  • Utilize Format Painter: Quickly apply formatting from one element to another for efficient styling.
  • Save and Share: Master presentation saving and explore various sharing options for your creations.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Getting Started with PowerPoint
  • Opening PowerPoint
  • Touring the Interface
  • Using the Ribbon
  • Navigating PowerPoint Views
Creating a Presentation
  • Adding Text and Slides
  • Working with Bulleted Lists
  • Applying a Theme
  • Saving a Presentation
Formatting Slide Text
  • Using Character Formatting
  • Working with Paragraph Formatting
  • Using Format Painter
  • Working with Numbered Lists
Editing a Presentation
  • Moving and Copying Slides
  • Cutting and Copying Slide Content
Working with Graphics
  • Inserting Pictures
  • Resizing and Arranging Pictures
  • Working with Picture Effects and Styles
  • Adding and Working with Shapes
  • Aligning and Arranging Shapes
  • Formatting Shapes
Preparing and Delivering a Presentation
  • Proofing a Presentation
  • Printing a Presentation
  • Delivering a Presentation
  • Using Presenter View
Conclusion


 

PowerPoint 365: Advanced

Course Duration - 2 hrs 59 min

In this course, students will learn the various collaboration tools in Microsoft PowerPoint 365, such as reusing slides, creating slides from Word, and working with Excel. Students will learn to utilize the power of Slide Masters, create custom themes, and design custom templates. In addition, students will learn to create exciting presentations by animating text and objects, adding slide transitions, and using advanced graphic features, including SmartArt and audio and video. Finally, students will present like pros by using advanced presentation features, including annotations, hyperlinks and action buttons, timings, recordings, creating videos, and reviewing additional advanced slideshow options.

Course Objectives:
Course Objectives:
  • Master Collaboration: Learn to reuse slides, work with colleagues on presentations, and utilize comments for effective feedback.
  • Design Stunning Presentations: Utilize Slide Masters for consistent branding, create custom themes, and design unique templates.
  • Bring Content to Life: Animate text and objects, add impactful transitions, and leverage advanced graphic features like SmartArt, audio, and video.
  • Deliver Pro-Level Presentations: Master techniques like annotations, hyperlinks, action buttons, and timings to engage your audience.
  • Record and Refine: Explore advanced slideshow options like recording slide timings, configuring self-running presentations, and creating videos.
  • Leverage Word and Excel: Seamlessly integrate elements from Word outlines and Excel data into your presentations.
  • Customize Your Slides: Fine-tune your presentation experience by adding footers, modifying notes, handing out masters, and working with multiple Slide Masters.
  • Control Animation Precisely: Tailor animation effects, create motion paths, configure timing and start options, and even manage animation across elements.
  • Enhance Storytelling with SmartArt: Master creation, text integration, and customization of SmartArt graphics for impactful visuals.
  • Package and Prepare: Learn to share your presentations effectively through packaging and utilizing advanced options like digital ink drawings.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Collaborating in PowerPoint
  • Reusing Slides from an Existing Presentation
  • Creating Slides from a Word Outline
  • Using Excel Data in PowerPoint
  • Co-Authoring with PowerPoint
  • Using Comments
  • Comparing and Merging Presentations
Working with Masters, Themes, and Templates
  • Understanding the Slide Master
  • Making Global Changes with the Master
  • Creating and Editing Layout Masters
  • Adding an Image to the Master
  • Adding Footers to Slides
  • Customizing and Saving a Theme
  • Creating a Template
  • Modifying Notes and Handout Masters
  • Working with Multiple Slide Masters
Working with Animation and Transitions
  • Adding Animation
  • Customizing Animation Effect Options
  • Creating a Motion Path
  • Configuring Animation Timing and Start Options
  • Reordering and Copying Animation
  • Using Animation Painter
  • Animating Bulleted Lists, Charts, and SmartArt
  • Adding Slide Transitions
  • Customizing Slide Transitions
Advanced Graphic and Media Features
  • Creating SmartArt
  • Working with SmartArt, Text, and Bullets
  • Customizing SmartArt
  • Inserting Audio
  • Configuring Audio Playback Options
  • Inserting Video
  • Configuring Video Playback Options
  • Customizing Video Style Options
  • Inserting a Screen Recording
Advanced Presentation Features
  • Adding Hyperlinks
  • Using Action Buttons in PowerPoint
  • Creating a Custom Slide Show
  • Creating and Working with Sections
Advanced Slide Show Options
  • Adding Annotations to Slides
  • Working with Hidden Slides
  • Recording Slide Timings
  • Configuring a Self-Running Presentation
  • Drawing and Writing with Digital Ink
  • Creating a Video from a Presentation
  • Packaging a Presentation
Conclusion


 

Word 365: Beginner

Course Duration - 4 hrs 22 min

This course is designed to introduce students to the basic functionality and user interface of Microsoft Word 365. In this course, students will learn the basics of saving and opening documents and review the interface. Students will practice text navigation, selection, entry, and other text formatting and editing commands and features. Additionally, students will work with bulleted and numbered lists, tables, and their various features and options. Students will also work with graphics and the multiple tools available in Word 365 to format and edit them. Lastly, this course will cover various options for viewing documents, proofing options for documents, and settings to prepare documents for distribution and publication.

Course Objectives:
Course Objectives:
  • Demonstrate proficiency in navigating the Word 365 interface, including opening, saving, and managing documents.
  • Efficiently create, enter, and edit text within Word documents.
  • Apply fundamental text formatting and editing commands, such as font styles, sizes, colors, alignment, and indentation.
  • Construct and modify bulleted and numbered lists to organize content.
  • Insert, format, and manipulate tables to present data effectively.
  • Incorporate and enhance graphics within documents using Word’s formatting and editing tools.
  • Utilize various viewing options to optimize document readability and accessibility.
  • Implement proofing tools to ensure document accuracy and consistency.
  • Prepare documents for distribution and publication by adjusting margins, headers, footers, page orientation, and hyphenation.
  • Save and distribute documents in appropriate formats, including PDF and XPS.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Getting Started with Word
  • Understanding the Interface
  • Using the Backstage View
  • Opening Documents
  • Navigating Documents
  • Creating Documents
  • Entering Text
  • Selecting Text
  • Saving Documents
  • Using the Accessibility Checker
  • Converting to Updated File Format
  • Understanding Document Properties
  • Sharing and Co-Authoring
  • Using Versions
Editing and Formatting Documents
  • Using the Inking Tools
  • Moving and Copying Text
  • Using Undo and Redo
  • Opening and Editing a PDF
  • Overview of Formatting
  • Applying Character Formatting
  • Applying Paragraph Formatting
  • Showing Hidden Characters
  • Applying Formatting to Multiple Items
  • Using Format Painter
  • Using Word Styles
  • Applying a Style Set
  • Applying a Theme
Enhancing Documents
  • Inserting Blank and Cover Pages
  • Inserting or Removing Breaks
  • Applying Drop Caps
  • Inserting the Date and Time
  • Inserting Special Characters
  • Inserting a Picture
  • Working with Icons
  • Using Text Wrapping and Positioning
  • Resizing, Rotating and Cropping
  • Removing a Background
  • Adjusting Images
  • Applying Artistic Effects
  • Compressing a Picture
  • Applying Image Styles
  • Replacing an Image
  • Adding Watermarks
  • Applying Color and Page Borders
Proofing and Viewing
  • Using Find and Replace and the Go To Function
  • Proofing a Document
  • Translating and Proofing Languages
  • Using Read Mode
  • Using Immersive Reader
  • Viewing a Page Side by Side
  • Custom Viewing of Documents
Finalizing Documents
  • Adjusting Document Margins
  • Working with Headers and Footers
  • Changing Page Orientation
  • Controlling Hyphenation
  • Creating a PDF or XPS File
  • Emailing Documents
  • Printing Documents
Conclusion


 

Word 365: Intermediate

Course Duration - 6 hrs 25 min

This is the intermediate course in the Microsoft Word 365 series. This course expands upon the topics covered in the Word 365 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Students will then review advanced document layout options in Word and various collaboration tools. Lastly, students will work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Additional graphic element features such as grouping, layering, and moving objects will also be covered.

Course Objectives:
Course Objectives:
  • Effectively apply, create, manage, and customize styles within Word documents.
  • Proficiently create and manipulate various types of lists and tables to organize and present data.
  • Integrate and work with data from external sources, including Excel, within Word documents.
  • Utilize advanced document layout options to enhance document structure and visual appeal.
  • Collaborate effectively with others using Word's commenting, track changes, and markup features.
  • Effectively insert, format, and manipulate graphic elements to enhance visual communication.
  • Create and customize charts to visually represent data within Word documents.
  • Customize document design and formatting using themes and templates.
  • Integrate special graphics to enhance visual and technical content.
  • Employ advanced techniques for working with shapes and drawing tools.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Working with Styles
  • Using Styles
  • Creating a Style Based on Text
  • Modifying a Style
  • Managing and Exporting Styles
  • Using Styles to Navigate or Reorder Text
  • Working with Style Sets
  • Creating and Applying Font and Color Sets
  • Working with Themes
  • What are Templates?
  • Creating a Template
  • Modifying Templates
  • Changing the Custom Office Template Location
Working with Lists and Tables
  • Creating a Bulleted List
  • Creating a Numbered List
  • Creating a Multilevel List
  • Sorting a List
  • Creating a Table
  • Formatting Text in a Table
  • Adding and Deleting Rows and Columns
  • Adjusting Row and Column Width and Height
  • Merging and Splitting Cells
  • Sorting Table Items
  • Aligning Table Text
  • Changing Text Direction in a Table
  • Adjusting Cell Margins
  • Adding Styles, Borders and Shading
  • Converting Text to Table
Working with Data in Word
  • Repeating Table Header Rows and Setting Page Breaks
  • Working with Calculations in a Table
  • Working with Excel Data in Word
  • Copying, Pasting and Linking Excel Data
  • Creating a Chart in Word
  • Editing Chart Data
  • Formatting a Chart
Advanced Document Layout
  • Controlling Page Breaks
  • Working with Section Breaks
  • Using Section Breaks with Margins and Page Orientation
  • Applying Columns
  • Modifying Columns
  • Adding Borders and Shading
  • Applying Different Headers or Footers
  • Creating a Signature Line
Collaborating in Word
  • Working with Comments
  • Using Track Changes
  • Reviewing and Accepting Changes
  • Customizing Markups
  • Comparing and Merging Two Documents
  • Combining Documents
Working with Pictures, Shapes and Drawing Tools
  • Applying a Picture Style and Effects
  • Adjusting a Picture
  • Removing a Picture Background
  • Inserting a Text Box from the Gallery
  • Drawing and Formatting a Text Box
  • Adding, Selecting, and Deleting Shapes
  • Resizing, Rotating, and Replacing Shapes
  • Using the Selection Pane
  • Copying or Duplicating a Shape
  • Customizing Fill Color and Outline for a Shape
  • Using a Drawing Canvas
  • Positioning & Moving Shapes or Objects
  • Using Text Wrapping
  • Grouping and Layering Objects
  • Aligning Objects
Inserting Special Characters
  • Creating SmartArt
  • Formatting and Customizing SmartArt
  • Working with Text & Typography Effects
  • Creating and Modifying WordArt
  • Inserting a 3-D Model
  • Working with Equations
Conclusion


 

Word 365: Advanced

Course Duration - 5 hrs 40 min

In this course, students will automate with Microsoft Word 365 through the use of building blocks, Quick Parts, fields, and Macros. Students will also utilize reference tools such as bookmarks, hyperlinks, cross-references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage lengthy documents through a table of contents, indexing, and captions. Students will also work with Outline View and master documents, Mail Merge, and forms.

Course Objectives:
Course Objectives:
  • Automate document creation and formatting with building blocks, Quick Parts, fields, and macros.
  • Utilize bookmarks, hyperlinks, cross-references, footnotes, endnotes, and bibliographies to enhance document organization and navigation.
  • Master advanced techniques for managing long documents, including tables of contents, indexing, and captions.
  • Leverage Outline View and master documents to efficiently structure and manage complex documents.
  • Design and execute professional mail merge campaigns, including recipient list management, field insertion, and output customization.
  • Create interactive forms in Word using field labels, controls, and protection features.
  • Gain comprehensive understanding of field codes and metadata insertion for dynamic document content.
  • Effectively employ hyperlinking to connect your documents to various online and offline resources.
  • Develop proficiency in customizing footnotes, endnotes, and bibliographies for accurate and consistent referencing.
  • Navigate and edit documents efficiently using advanced features of Outline View.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Automating Word
  • Using Building Blocks and Quick Parts
  • Creating Building Blocks and Quick Parts
  • Creating AutoText
  • Deleting Building Blocks and Quick Parts
  • Creating a Building Block Category
  • Editing Building Blocks and Quick Parts
  • Inserting Metadata Using Field Codes
  • Inserting Document Properties
  • Recording and Working with Macros
  • Creating and Formatting Macros
  • Assigning Macros to the Toolbar
  • Deleting a Macro
  • Creating a Custom Document Property
  • Inserting Field Codes
  • Inserting a Linked Field
  • Updating Fields
Utilizing Reference Tools
  • Adding and Using Bookmarks
  • Displaying Bookmarks
  • Working with Hyperlinks
  • Hyperlinking to a Web Page or Email
  • Hyperlinking with Headings and Bookmarks
  • Hyperlinking to Another File
  • Editing a Hyperlink
  • Creating a Cross-Reference
  • Inserting a Footnote or Endnote
  • Changing a Footnote or Endnote Location
  • Editing or Moving a Footnote or Endnote
  • Customizing Footnotes or Endnotes
  • Using Citations and Bibliographies
  • Adding a Source
  • Inserting a Placeholder
  • Inserting a Bibliography
Managing Long Documents
  • Creating a Table of Contents
  • Customizing a Table of Contents
  • Modifying a Table of Contents
  • Creating an Index
  • Updating an Index
  • Creating an Index Using a Concordance File
  • Inserting Captions
  • Generating a Table of Figures
Working with the Outline View
  • Working in Outline View
  • Changing Levels in Outline View
  • Editing in Outline View
  • Moving Text in Outline View
  • Working with Master Documents
  • Inserting Subdocuments
  • Expanding and Collapsing Subdocuments
  • Updating a Master Document
  • Unlinking and Deleting Subdocuments
  • Splitting Subdocuments
  • Merging Subdocuments
  • Creating New Subdocuments
  • Adding a Cover Page to a Master Document
  • Controlling Page Numbers on a Master Document
  • Creating a Table of Contents and Index for a Master Document
  • Printing a Master Document
Working with Mail Merge
  • Understanding Mail Merge
  • Setting Up a Recipient List in Excel
  • Setting Up an Outlook Contacts Recipient List
  • Creating a Recipient List
  • Sorting and Filtering Recipient Lists
  • Adding Merge Fields
  • Completing a Merge
  • Preparing Mailing Labels
  • Configuring Envelopes
  • Creating Merge Rules
  • Using Match Field
Creating Forms
  • Creating Forms in Word
  • Adding Field Labels and Controls
  • Editing Text or Content Controls
  • Locking Content Controls and Protecting Forms
  • Entering Data in a Form
Conclusion

 


 


Essential Career Skills Pack


Productivity and Time Management

Course Duration - 30 min

It seems that there is never enough time in the day. But, since we all get the same 24 hours, why is it that some people achieve so much more with their time than others? This course will explain how to plan and prioritize tasks, so that we can make the most of the limited time we have. By using the time-management techniques in this course, you can improve your ability to function more effectively – even when time is tight and pressures are high. So, by the end of the course you will have the knowledge, skills and confidence to be an effective manager of your time.

Course Objectives:
Course Objectives:
  • Set your priorities to better manage your time
  • Improve your productivity by sharpening your focus and multitasking effectively
Detailed Course Outline:
Detailed Course Outline:
  • Productiity & Time Management
  • Prioritization
  • Getting Things Done
  • Procrastination
  • Multitasking & Focus
  • Summary


 

Basic Digital Skills

Course Duration - 13 min

With the rise of digital transformation and technology, having a basic digital literacy is essential for all types of jobs, regardless of the industry. To stay competitive and be successful in the workplace, enhancing your digital skills should be a top priority.

Course Objectives:
Course Objectives:
  • Recall the essential digital skills framework
  • Elaborate on the toolkit of essential digital skills
  • Identify how to develop or improve your digital skills
Detailed Course Outline:
Detailed Course Outline:
  • The Essential Digital Skills Framework
  • The Toolkit of Essential Digital Skills
  • Developing Digital Skills
  • Summary


 

4 Ways to Boost Creativity

Course Duration - 30 min

The digital economy is opening up ways for everyone to be creative. It doesn’t just mean being artistic – it’s more about ideas, solutions, alternatives, incremental improvements. Peter Quarry and Eve Ash discuss ways that mental capacity can be developed, perspectives changed, group power leveraged and making things actually happen.

Course Objectives:
Course Objectives:
  • Define creativity
  • Think outside the box
  • Develop the right mental attitude
  • Leverage the power of groups
  • Ensure managers make it happen
Detailed Course Outline:
Detailed Course Outline:
  • What is Creativity at Work?
  • Learn to Think Outside the box
  • Develop the Right Mental Capacity
  • Laverage the Power of Groups
  • Ensure Managers Make It Happen
  • Summary


 

The 11 Essential Career Soft Skills

Course Duration - 1 hr 10 min

Soft Skills are the traits, characteristics, habits, and skills needed to survive and thrive in the modern work world. Soft skills aren't usually taught in school, but you will learn them all here in this course. Are you someone that other people in your organization and industry like to work with, collaborate with and partner with? Are you seen as a valuable asset to any new project that comes along?

This soft skills training course will teach you how to develop the skills that can make the difference between a lackluster career that tops out at middle management versus one that lands you in the executive suite. Or to wherever you define career success. So many soft skills seem like common sense at first glance, but they are not commonly applied by most workers. This soft skills training course will give you an edge over your competitors. It will also make your job, your career and your life more rewarding and enjoyable.

Course Objectives:
Course Objectives:
  • Understand how to be a great communicator
  • Become a stronger listene
  • Appear professional to co-workers and bosses of all ages
  • Avoid common career blunders that often end careers
  • Manage expectations for bosses and colleagues
  • Position yourself for promotions
  • Make technology your asset, even if you are afraid of technology
  • Avoid the Not My Job Syndrome
  • Develop EQ to Match Your IQ
  • Develop leadership qualities
Detailed Course Outline:
Detailed Course Outline:
  • Introduction
  • The Soft Tech Savvy Way to Always Be Essential
  • Not My Job, And I Am Happy to Do It
  • You Can Become a Master Communicator
  • Feedback Video for The 11 Essential Career Soft Skills
  • Become a Leader Without the Title or Formal Authority
  • Your EQ Will Beat a Higher IQ
  • Building Your Winning Team
  • Make Every One of Your Seconds Count
  • Unleash Your Inner Anthony Robbins
  • Avoid Being Uncool
  • Clothes Can Still Make or Break Your Career
  • Conclusion The 11 Essential Career Soft Skills
  • Extra: Developing Your Career Secret Sauce

 



 


Related Microsoft Office Information:

How Much Do Microsoft Office Training Courses Cost?

Public instructor-led Microsoft Office course prices start at $275 per student. Group training discounts are available.

Self-Paced Microsoft Office eLearning courses cost $125 at the starting point per student. Group purchase discounts are available.

What Microsoft Office Skills Should I Learn?

A: If you are wondering what Microsoft Office skills are important to learn, we've written a Microsoft Office Skills and Learning Guide that maps out Microsoft Office skills that are key to master and which of our courses teaches each skill.

Read Our Microsoft Office Skills and Learning Guide

Microsoft Office Suite Training by Certstaffix Training

Certstaffix Training offers three dynamic approaches to mastering Microsoft Office skills through our comprehensive Microsoft Office class. Our Microsoft 365 classes can be taken live online with expert instructors guiding you. For those who prefer to learn at their own pace, we offer Microsoft online courses which allow for self-paced eLearning. If you have a group of students, we offer a opportunity for corporate groups who want in-person onsite trainings through our mobile Microsoft Office 365 training center, brought to your office. We accommodate Microsoft 365 courses for every learning style and experience level, making us the ideal choice for Microsoft courses for beginners. Through our Microsoft training classes, you'll gain the competence needed to effectively navigate the Microsoft Office suite. Our Microsoft Office suite training is designed to equip you with the tools and knowledge necessary for business success.

Why Invest in Employee Training for HR Professionals?

A: Investing in employee training for professionals in human resource management (HRM) can be as important as obtaining training for your general workforce. In some ways, it can be even more imperative, as a fully functional and competent HR department can facilitate productivity among your staff. HR professionals can benefit from taking a number of courses, such as those that teach them how to work with common office software like Microsoft Office or skills like customer service. Adequate training for HR professionals can aid them in better identifying and addressing the needs of your employees.

More Information on Employee Training for HR Professionals

Why Take Microsoft Office Training Classes From Home?

A: Taking Microsoft Office courses online from home can be a convenient and easy solution to employee training needs when time, money, and space are limited in a physical work environment. These classes have the benefit of being tailored to different programs and skill levels, making it easy to choose which concepts you need to focus on. Choose live instruction and log into your course from anywhere, or opt for a class that's self-paced so you can complete it at your leisure. Either way, you'll get hands-on training that can help employees get the skills they need and even prepare for certification exams.

More Information on the Benefits of Taking Microsoft Office Training Classes From Home

How and Why Should I Get Microsoft-Certified?

A: In today's offices and work spaces, earning one or more Microsoft certifications can be essential for showcasing your skills, increasing your salary, and progressing in your career. The process of earning a certification, however, can vary depending on your existing knowledge of relevant software, your work experience, and the particular certification pathway. While each certification pathway can differ in duration, generally, employees may earn certifications within a few months. For some individuals, signing up for training courses can significantly reduce the amount of time that it takes to prepare for Microsoft's certification exams.

More Information on Getting Microsoft-Certified

What Are Some Useful Microsoft Project Tips?

A: The sheer number of features and functions available in Microsoft Project can often intimidate someone who isn't fluent in the program. However, using certain tips can simply project management processes and streamline tasks. Using pen and paper to plan out your project, creating baselines, auto-scheduling tasks, and choosing the right View to assess your project's status can create an efficient and productive digital environment in which to work. To learn more tips and get the most out of MS Project, sign up for instructor-led Microsoft Project courses.

More Information on What Are Some Useful Microsoft Project Tips?

What is the best way to learn Microsoft Office?

A: There is no one-size-fits-all answer to this question, as the best way to learn Microsoft Office will vary depending on your level of experience and expertise. However, some general tips can help you get the most out of your learning experience.

If you are a beginner, it is important to start with the basics. There are many resources available online and in libraries that can help you get started with the basics of Microsoft Office. For many beginners, taking a formal Microsoft Office course is the best route, as it offers a structured learning format with set topics. Once you have a good understanding of the basics, you can move on to more advanced topics.

If you are already familiar with Microsoft Office but want to improve your skills, there are also many resources available to help you do this. You can find targeted and smaller online courses, tutorials, and tips from experts to help you make the most of your already existing Microsoft Office skills.

Whatever your level of experience, taking the time to learn Microsoft Office can be a valuable investment. With so many resources available, there is no excuse not to get started today!

What is a Microsoft Office course?

A: A Microsoft Office course is a type of educational training that covers the various aspects of using the Microsoft Office software suite. This type of coursework can help users learn how to use the different features and applications within Microsoft Office, as well as how to optimize their workflows by integrating the tools in the suite. Microsoft Office courses can be taken online or in person, and typically cover the following topics:

  • Microsoft Word: Users learn how to create, format, and edit text documents using Microsoft Word.
  • Microsoft Excel: Users learn how to create and work with spreadsheets in Microsoft Excel.
  • Microsoft PowerPoint: Users learn how to create presentations and slideshows using Microsoft PowerPoint.
  • Microsoft Outlook: Users learn how to manage their email, calendar, and contacts using Microsoft Outlook.

Microsoft Office courses can be beneficial for both beginners who are new to the software suite and experienced users who want to learn more about how to use the tools effectively. The courses can also be customized to fit the needs of any user, whether they are looking for a general overview of the software or more specific training on one particular application.

How can I improve my Microsoft Office skills?

A: If you're looking to improve your Microsoft Office skills, there are a few avenues you can explore. One option is to find online tutorials or courses that can help you learn the specific features and functions you're interested in. Another possibility is to seek out books or other resources that offer step-by-step instructions for using Microsoft Office applications. Finally, you could consider attending a formal Microsoft Office training class or workshop to get hands-on experience and guidance from an expert.

The route you choose depends on your experience level and learning preferences. Whichever route you choose, with a little effort you can soon be on your way to becoming a Microsoft Office pro!

What is the fastest way to learn Microsoft Office?

A: There is no single answer to this question as everyone learns at a different pace. However, some general tips can help you learn Microsoft Office quickly and effectively.

First, it is important to have a clear understanding of what you want to achieve with Microsoft Office. Whether you want to use it for work or personal purposes, it is important to set some goals so that you can focus on your learning.

Next, make use of all the resources available to you. Formal Microsoft Office classes are available online or in-person for groups by Certstaffix Training that start at 1 day in length. There are also many self-teaching methods such as tutorials and guides available online, as well as books and other materials. Utilize these resources to learn at your own pace and in a way that suits your learning style.

Finally, practice, practice, practice! The more you use Microsoft Office, the more comfortable and confident you will become using it. Do not be afraid to experiment and explore all the features and functions available; this is the best way to learn.

By following these tips, you can learn Microsoft Office quickly and effectively.

What are options for Microsoft Office training near me?

Are you looking to enhance your skills in Microsoft Office? Do you want to learn more about the various tools and features within this popular software suite? Look no further, as we have compiled a list of resources for Microsoft classes near me that will meet your training needs.

Finding the Right Training

When it comes to finding the right Microsoft training near me, there are a few factors to consider. First, you should think about what specific skills or tools you want to focus on. Are you interested in learning more about Excel functions or creating engaging presentations with PowerPoint? Once you have identified your training needs, it's time to research different options for in-person Microsoft Office training near me.

In-Person vs. Online Training

For some, attending a physical classroom setting for training may be the preferred method. Fortunately, there are many resources available for in person Microsoft Office training near me. These classes allow you to learn from an instructor face-to-face and interact with other students in real time.

On the other hand, online training options offer flexibility and convenience for those with busy schedules. Many online platforms offer Microsoft Office workshops near me that can be completed online either at your own pace or a public live schedule to register from. There 2 options for online training - 1.) Live Online and 2.) Self-paced.

Live Online

Live Online features a set date and time to attend like an in-person class. A live teacher leads the class with lecture and hands-on exercises to reinforce the lecture.

Self-Paced Online

Self-paced online is often called eLearning. You view recorded video lectures and often have hands-on assignments you can complete to reinforce the video lecture.

Microsoft 365 and Office 365 Training

As Microsoft continues to evolve its software offerings, it's important to stay up-to-date on the latest updates and features. This is where Microsoft 365 training near me and Office 365 training near me come into play. These courses are specifically tailored to teach users about the newest versions of Microsoft Office and how to effectively use them in your day-to-day tasks.

Classes for Microsoft Office Near Me

In addition to traditional classroom settings, there are many classes for Microsoft Office near me offered by local organizations and universities. These classes may vary in length and intensity, so be sure to research which option best fits your learning style and needs. Some classes may also offer certification upon completion, which can be a valuable addition to your resume.

Conclusion

In summary, there are plenty of resources available for MS Office course near me that will allow you to enhance your skills and become more proficient in using Microsoft Office. Whether you prefer in-person or online training, there is an option out there for you. Take the time to research and find the right training that will help you reach your professional goals.

Certstaffix Training offers 3 options to learn Microsoft Office training near me:

Reach out to us for more information, a quote or register on our website for a live online or self-paced class today!

What are options to learn Microsoft Office?

Microsoft Office is a suite of applications that are essential for any business, school, or individual. Many people use these applications on a daily basis but may not be utilizing all of their features and capabilities. That's why it's important to invest in training courses to become proficient in using Microsoft Office.

Benefits of Microsoft Office Training

There are several benefits to attending Microsoft Office training. The most obvious one is that you will become more efficient and productive in using the applications, which can greatly benefit your work or studies. By learning from a certified instructor, you will be able to fully understand the features and functions of each application, allowing you to use them to their full potential.

Types of Microsoft Office Training

There are various types of training for individuals and businesses alike. In-person training is a popular option, where participants attend classes physically and learn from an instructor in person. This type of training allows for hands-on experience and immediate feedback from the instructor. Live online instructor-led format is also very popular and is often the most available in your area. You attend a set date and time, like in-person, but you attend online from you location and interact with the instructor and other students live just like in person.

For those who prefer to learn at their own schedule, self-paced online Office classes are also available. These courses provide flexibility as they can be accessed anytime, anywhere. However, they may not offer the same level of interaction and practical experience as in-person or live online training.

Advanced Microsoft Office Training

While most individuals are familiar with the basics of using Microsoft Office, there is always room for improvement and learning advanced features. Advanced MS Office training teaches attendees how to use these applications at an expert level, allowing them to create professional and complex documents, spreadsheets, presentations, and more.

Microsoft Classes for Adults

Microsoft Office classes are not just for students or professionals. There are also courses specifically designed for adults who may want to learn how to use the applications for personal use. These classes can teach individuals how to organize their finances with Excel, create invitations and flyers with Publisher, or manage their schedule with Outlook.

Microsoft Office Classes in Person

For those who prefer a more traditional approach, in-person Microsoft Office training is available. These classes are led by certified instructors and offer hands-on experience with the applications. Participants can ask questions, receive immediate feedback, and network with other individuals attending the class.

Start Learning Office 365 Today

Investing in Microsoft Office training can greatly improve your proficiency and productivity in using these essential applications. Whether you prefer in-person classes or online courses, there are plenty of options available to suit your learning style. Don't miss out on the opportunity to enhance your skills and become an expert at using Microsoft Office.

It is always recommended to take up some sort of Microsoft training. With the availability of various types such as Microsoft in person training, Microsoft instructor led courses and online Office classes, it has never been more convenient to improve your skills.

Certstaffix Training offers live online, in person (corporate groups only) and self-paced Excel training formats. Sign up for a class today and take the first step towards becoming a Microsoft Office pro!

What are the top Microsoft Office skills?

A: To be proficient in Microsoft Office, there are certain skills you need to master. These skills include:

Top Microsoft Office Skills

1. Knowing how to use the various features in each of the programs.

2. Being able to create and edit documents, spreadsheets, and presentations.

3. Knowing how to manage files and folders.

4. Being able to collaborate with others using the various tools available.

5. Having a good understanding of how to troubleshoot problems that may occur.

6. Knowing how to customize the various settings to better suit your needs.

7. being able to use the different keyboard shortcuts available in each program.

8. Knowing how to use the various templates that are available.

9. Being able to create macros to automate tasks.

10. Knowing how to use the different add-ins that are available for the various programs.

These are just some of the skills that you need to master to be proficient in Microsoft Office. By taking the time to learn these skills, you will be able to use the programs to their full potential and get the most out of them.

Where Can I Learn More About Microsoft Office?

Microsoft Office Blogs

Microsoft Office User Groups

Microsoft Office Online Forums

Explore Microsoft Office Training Near Me:

Certstaffix Training provides Microsoft Office classes near me or online, depending on the number of students involved. We offer online courses for individual learners, as well as in person classes at your office for corporate groups. Our trainers are highly experienced professionals with the expertise necessary to help you gain a thorough understanding of Office 365 concepts and tools. With our courses available online for individuals or in person for corporate groups, it's easy to develop your Microsoft Office skills. Start learning today and see how Certstaffix Training can help you reach your goals.







Registration:

Have a Group?
Request Private Training


Online Class

Self-Paced eLearning

Start your training today!