Learning Outcomes

Who is an Administrative Professional?

The Administrative Professional Document

Manage Text with Microsoft Word

Manage Content with Microsoft Word

Manage Pages with Microsoft Word

Mail Merge Feature

Lesson Summary

In this module, you will explore the essential features of Microsoft Word for Administrative Professionals. In addition, the module includes basic explanations and step-by-step tutorials.

Microsoft Word for Administrative Professionals - Assessment

Learn how to use Microsoft Word to improve productivity as an administrator in this free online office admin course.

Microsoft Word for Administrative Professionals

This Microsoft Word tutorial shows you how to use MS Word to perform administrative tasks. We cover the word processor’s basic features that allow you to manage text and page content as well as insert ‘mail merge’ features into documents. We also examine various important documents and templates frequently used by administrators. Sign up to acquire useful MS Word skills that boost your productivity and efficiency as an office administrator.

Welcome and Overview

QuickBooks Online Subscriptions

QuickBooks Online & Mobile Devices

Get introduced to the QuickBooks Online accounting software in this module. You will learn how to select the right subscription plan for your business needs, the functions of the software, and how QuickBooks Online works with mobile devices.

Accessing QuickBooks Online Sample Files

Setting Up A New Company File

Uploading QuickBooks Desktop Files to the Online Version

Overview of the User Interface

Learn about how to set up and navigate through a QuickBooks Online account from this module. You will also discuss how to upload desktop files to the online version and the elements of the QuickBooks Online user interface.

The Gear Menu

Customizing Your Company File

Customizing Your Company File - Part 2

Managing Users

Chart of Accounts - Part 1

Chart of Accounts - Part 2

Learn about various options for customizing your company files on QuickBooks Online. You will discuss the tools and settings in the gear menu, the ways of managing user access rights, and setting up the Chart of Accounts.

Customer List

Adding Customers

Adding Sub-Customers

Editing Customer

Making Customers Inactive

Importing Customers

Learn about handling customers and customer information in QuickBooks Online from this module. You will discuss how to create a customer or a sub-customer, along with ways to edit, make inactive, and import customers.

Sales Overview

Sales Receipts

Invoicing Customers

Recording Customer Payments

Make Deposits

Credit Memos

Refunds

Statements

Customer & Sales Reports

Learn about recording and generating reports on sales transactions on QuickBooks Online from this module. You will discuss how to record sales and payments, issuing credit memos and statements to customers, and different types of sales and customer report.

Overview of Products & Services

Adding New Products & Services

Adding Inventory Products

Purchase Orders

Receiving Products Into Inventory

Product & Service Reports

Learn about different processes and reports related to products and services on QuickBooks Online. You will discuss various types of products and services, setting up purchase orders, and receiving products into your business inventory.

Introduction to QuickBooks Online - Course Assessment

Learn how to set up and use Intuit QuickBooks Online to handle business transactions with this free online course.

Introduction to QuickBooks Online

This training course guides you step-by-step through the process of using Intuit QuickBooks Online accounting software to meet your business needs. We show you how to create and customize company files and manage users and customers. We cover how to handle sales transactions and manage your products and services while you generate reports with QuickBooks. Sign up to quickly polish your accounting software skills.

Gmail Settings, Sending Emails and Conversations

Email Features, Gmail Labels and Message Filters

In this module, you will learn many features that are crucial to becoming a skilled Gmail operator. These include applying Labels to your messages and creating filters around them. You will also be guided on the Undo, Send, and Cancellation period Gmail features. Using Google Drive to send large files in Gmail gets covered as well.

Efficiency and Productivity Tips

Access Control, Shortcuts and General Tips

This module presents you with general email tips that allow you to be more effective working with Gmail. We will also present productivity tips that go over key points that provide for an optimized Gmail experience. Conducting email Searches, using Aliases, and creating Canned Responses are covered by the material as well.

Gmail - Maximize your Email Productivity - Course Assessment

Learn various features and emailing tips that will maximize your productivity using Gmail with this free online course.

Gmail - Maximize your Email Productivity

In this course, you will learn various Gmail features, including using Google Drive to send large files and applying labels to messages and creating filters around them. Scheduling emails to automatically send and Granting Access to your account are also covered in this course. You will be getting general productivity tips as well. These serve to boost your efficiency further and enable you to achieve more with Gmail in less time.

Introduction

Beginner Formatting

Working With Information: Basics

Essential Formatting and Analysis Tricks

In this module, learn how to create new documents from scratch or via the default templates in the gallery. A simple walkthrough of Google sheets, including how to organize your spreadsheets in Google Drive, will be presented. Then, you will discern how to work with numbers and basic functions.

Intermediate Google Sheets

Real Life Application of Google Sheets

In this module, study the methods for creating and using multi-tab formulas, and vital functions like the Count, CountA, SumIf, etc. The concatenation and vertical lookup functions will be explained. Discern how to visualize your data via charts, graphs and pivot tables. Then, the real-world applications of Google sheets will be demonstrated.

Google Sheets for Home and Business - Course Assessment

Master the use of Google spreadsheets for statistical analysis and data visualizations in this free online course.

Google Sheets for Home and Business

In this free online course, learn how to create, view, and edit Google spreadsheets. Study how to perform basic and advanced tasks with Google spreadsheets, including data formatting and modifications, arithmetic and stats operations, as well as the capabilities for data analysis, information customization, and data visualization. The tasks to be taught will range from beginner to advanced levels for a wider reach to ensure proficiency.

Does IT Matter?

Competitive Advantage

Information Systems for Competitive Advantage

This module explains more on Information Systems and Strategy. It consists of topics that cover the following aspects: Contribution of IT to organizational productivity, competitive advantage using IT in an organization, Porter’s value chain, Primary and support activities for the creation of a product or a service, Porter’s five forces framework and Strategic information systems.

What Is a Business Process?

ERP Systems

Business Process Reengineering

This module describes business processes and the concept of business process reengineering. It covers the following:  business processes and documentation, managing business process documentation, ERP systems and business process management, benefits of business process management, redesigning organizational processes and ISO Certification.

Elements of the Value Chain

From the Value Chain to Best Value Supply Chains

The Purpose of Five Forces Analysis

The Threat of Potential New Entrants to an Industry

The Power of Suppliers and Buyers to an Industry

This module examines strategies, an organization’s resources and capabilities alongside consideration of its value chain. It covers the following concepts: Elements of the value chain, Value chain primary and secondary activities, The relationship between value chain and supply chain, purpose of Porter's five forces analysis, Rivalry among competitors in an industry, threat of potential new entrants to an industry, power of suppliers to an industry and the limitations of five forces analysis.

Creators of Information Systems

Information-Systems Operations and Administration

Organizing the Information-Systems Function

This module discusses people in information systems. It consists of topics that cover the following: Creators of Information Systems, information-systems operations and administration, career paths in information systems, organizing the information-systems function, IT outsourcing, new networked-based organizational structure and various information systems users/adopters.

Programming

Programming Languages

Programming Tools

Build vs. Buy

Implementation Methodologies

This module explains the process of Information Systems Development in an organization. It consists of topics that cover the following aspects: Programming and software development methodologies, the quality triangle, evolution and development of programming languages, classification of programming languages, programming tools and implementation methodologies.

What Is Globalization?

The Global Firm

The Digital Divide

Information Systems Ethics

Intellectual Property

Patents and Trademarks

Privacy

This module explains Information Systems in Society. It consists of topics that cover the following aspects: Globalization, impacts of globalization to organizations, the digital divide, ACM Code of Ethics and Professional Conduct, Information Systems Ethics, intellectual property and copyright in digital technologies, intellectual property protections, patents and trademarks and information systems privacy.

Global, Social and Personal

Mobile, Wearable and Collaborative Technology

The Internet of Things

This module looks into the future of management information systems. It consists of topics that cover the following aspects: Current trends in information systems with key emphasis on global, social and global interactions, mobile, wearable and collaborative technology, current trends on the Internet of Things (IOT) and autonomous technologies.

Information Systems and Organization Strategy - Course assessment

This free online course shows you how the implementation of information systems affects organizational strategy.

Diploma in Information Systems and Organization Strategy

This free online data science course discusses the relationship between information systems and organizational strategy. Every institution or business maps out its future and we explore the role of information systems in keeping data safe, relevant and flowing between relevant stakeholders. This course can enrich your understanding of information management and boost your value in the workplace.

Google Sheets – Introduction

Google Sheets – Start It

Google Sheets – Insert It

Google Sheets – Organize It

Google Sheets – Work With It

Google Sheets has utilities beyond data and tables. This module will teach you the ins and outs of Google Sheets as you learn to access it in more than one way. The hands-on style of instruction will focus on presenting data in an engaging and presentable form by learning to format, insert, organize and analyze.

Course assessment

Learn how to use open-source Google Sheets to organize, analyze and present data in this free online spreadsheet course.

Basics of Google Sheets

This Google Sheets tutorial helps you to make the most of the platform’s abilities that go beyond simple tables. We explain how to start a project from scratch and insert checkboxes, notes, comments, images, drawings and videos to create an impressive digital asset. We explore the ‘format’ menu to let you organize your data before you start working. Google Sheets is more than ‘free Excel’ so sign up to learn how to use it to advance your career.