Course Curriculum and FAQs: Excel | Word | PowerPoint | Access | Office for the Workplace | Got a Question? Check out these FAQs.
Available courses
Excel for the Workplace - Advance in your Career
A self-paced course on using Microsoft Excel in the workplace.
What you will learn:
- Master Microsoft Excel from Beginner level to Intermediate level.
- Learn the most commonly used Excel functions in today’s business environment.
- Master unique tips and concepts that you won’t find in other courses.
- Build a solid understanding of the basics of Microsoft Excel to increase your proficiency at work.
- Create dynamic charts and data analysis using IF, VLOOKUP, and PivotTables.
- Access to a Professional Trainer with 15+ years of Excel and IT experience.
- Get lifetime access to the quizzes, exercises and new updates.
Requirements
- Install Microsoft Office: Excel 2016, 2013 or 2010. The course is designed using Excel 2016.
- No previous knowledge is required!
- Great for students or employees who want to learn at their own pace
Certificate
A Verifiable Certificate of Completion is presented to all students who request it upon completion of this course.
Application
This course is suitable for individuals without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used the business environment.
This course is perfect employee training for small and midsize businesses and for individuals such as students, entry-level finance, Business and Marketing professionals who would like to grow faster than their peers.
- Executive Assistant
- Office Clerk
- Auditor
- Accountant
- Business Analyst
- Financial Analyst
- Credit Counselor
- Sales Representative
- Sales Manager
- Financial Manager
- Investment Banker
- Real Estate Agent
- Market Research Analyst
- Financial Advisor
- Business Operations Manager
- Entrepreneur
- Someone who is involved with a business and would like to be successful
- Students
Please don’t forget that the course comes with an unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Unit Sections and Objectives
Lesson 1: Getting Started with Excel – General Concepts
- Getting started with Excel
- General interface
- The Office Ribbon
- General concepts on using Excel and Spreadsheets
Lesson 2: Calculating the SUM, AVERAGE etc. in Excel
- How to use Excel basic features
- How to enter a formula in Excel
- How to calculate the sum of a series of cells
- How to calculate the average of a series of cells
- How to calculate the Max of a series of cells
- How to calculate the Min of a series of cells
- How to calculate the count function in a series of cells
- How to use the Autofill feature in Excel
Lesson 3: Basic Formulas: Multiplying, Division and Subtraction in Excel
- Basic arithmetic functions in Excel
- Subtraction
- Multiplying
- Dividing using formulas
Lesson 4: Absolute, Relative and Mixed References
- How and when to use different types of references in formulas in Excel.
- Difference between absolute and relative references
- Mixed references
Lesson 5: Using Conditional Formatting and Data Analysis in Excel
- How to apply formatting styles to the data in a spreadsheet.
- How to apply conditional formatting to selected data
- How to use Data Analysis in Excel
Lesson 6: Data Sorting and Filtering in Excel
- How to sort data in Excel
- How to filter data based on various criteria
- How to customize the filters
- How to clear the filters
- How to use sorting and filtering by right clicking
Lesson 7: Calculating Percentages in Excel
- How to calculate percentages using a formula in Excel
Lesson 8: Creating and Customizing Charts in Excel
- How to create various types of charts in Excel
- How to customize the charts
- Which types of charts to use for certain types of data
Lesson 9: Cross-Sheet Calculations in Excel
- How to use formulas to perform cross-sheet calculations in Excel
- How to enter the value from a formula in a previous sheet in a new worksheet.
Lesson 10: Using the IF Function in Excel
- How to use the IF Statement or function in a variety of ways in Excel 2013 via a formula
Lesson 11: Using Named References in Excel
- How to define Named References in Excel.
- How to apply Named References and how to use this important feature in Excel.
Lesson 12: Using Data Validation and Dropdown Lists in Excel
- How and why use data validation in Excel
- How to define data validation rules and criteria.
- How to apply data validation lists and drop-down lists
Lesson 13: Using Pivot Tables in Excel
- How to setup the data to use it with Pivot Tables.
- How to create pivot tables in Excel
- How to customize the pivot tables using various criteria.
Lesson 14: Setting the Print Area in Excel
- Setting and clearing the print area.
- Headers and footers
Lesson 15: Linking Data from Excel with Word for Reports
- How to link data from Excel into Word for reports etc. using Paste Special.
- Update the data in your Excel spreadsheet and have that data updated automatically in Word.
Lesson 16: Importing and Exporting Data in .csv Files in Excel to Transfer Data Between Systems
- Understanding .csv files and their usage.
- How to import .csv files in Excel
- How to export an Excel file to .csv format.
Lesson 17: Sharing and Saving Data in PDF Format
- How to share data files in Excel.
- How to export data in PDF format directly from Excel
Lesson 18: Creating a Mail Merge using Excel
- How to perform a mail merge using an Excel Data File
Lesson 19: Using VLOOKUP in Excel with 5 examples
User Comments:
“This is the best tutorial that I ever encountered on web and thousand times better then any college or university instruction that I came across. The beauty of this tutorial is that you can really learn and master information on your own convenience and time and your own pace. I am so amazed at the wonderful job that the instructor performs making excel so easy to understand and have a very valuable learning experience for which it is an incredible gift from this great deal of information. Thank you much Sali Kaceli, you are the best instructor I ever come across. You are so awesome. Thank you so much!!!!” Anna CP
Questions?
See also these FAQs.
Bulk Enrollments/Licensing
If you are a business owner and would like bulk enrollments/licensing, please contact us. Bulk discounts are available.
Microsoft Access for the Workplace Made Easy
Microsoft Access 2016: Beginner to Advanced
Quickly learn how Access 2016 can make your life easier and more productive!
What you’ll learn
- Understand how Access and databases function and how to use the major objects within it.
- Be confident in moving around within Access and be able to build effective database solutions for your unique data needs.
- How to create an Access Database from scratch
- Build an efficient database table design
- Enter and view records in a more organized layout using Forms
- Design and present dynamic queries and reports.
- Generate very detailed, professional looking Reports
Requirements
- Microsoft Access 2016, 2013 or 2010 installed. If you do not want to practice hands-on, then no need to have it installed.
- This course was created with Access 2016. But, all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007
- No prior knowledge required
- Willingness to learn.
This course is perfect employee training for small and midsize businesses and for individuals such as students, entry-level finance, Business and Marketing professionals who would like to grow faster than their peers.
- Executive Assistant
- Office Clerk
- Auditor
- Accountant
- Business Analyst
- Financial Analyst
- Credit Counselor
- Sales Representative
- Sales Manager
- Financial Manager
- Investment Banker
- Real Estate Agent
- Market Research Analyst
- Financial Advisor
- Business Operations Manager
- Entrepreneur
- Someone who is involved with a business and would like to be successful
- Students
Please don’t forget that the course comes with an unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Bulk Enrollments/Licensing
If you are a business owner and would like bulk enrollments/licensing, please contact us. Bulk discounts are available.
PowerPoint for the Workplace - Advance in your Career
Learn and Master PowerPoint to increase productivity and advance in your career. Create professional presentations for the workplace.
What you’ll learn
- Create a PowerPoint presentation from scratch
- Add animation to text, shapes and pictures
- Create a fully-animated and transition-filled business presentations
- Minimize text quantity on presentations by using graphs and images.
- Rapidly improve your workflow and design skills
Requirements
- PowerPoint 2010 / 2013 / 2016
- Willingness to learn
Application
This course is suitable for individuals without any previous experience in PowerPoint. We will start from the very basics and will gradually move on to some of the more advanced features often used the business environment.
This course is perfect employee training for small and midsize businesses and for individuals such as students, professionals who would like to create outstanding presentations in an easy way.
Please don’t forget that the course comes with an unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Questions?
See also these FAQs.
Bulk Enrollments/Licensing
If you are a business owner and would like bulk enrollments/licensing, please contact us. Bulk discounts are available.
Microsoft Word for the Workplace
Learn and master the most popular word processing tool, Microsoft Word 2016, Word 2013, Word 2010.
What you’ll learn
- You will learn how to take full advantage of Microsoft Word
- Begin with the basics of creating Microsoft Word documents
- Various techniques to create dynamic layouts
- Format documents effectively using Microsoft Word Styles
- Create and Manage Table Layouts
- Control page formatting and flow with sections and page breaks
- Perform Mail and Email Merges to create Mailing Labels and Form Letters and Emails
- Track and Accept/Reject Changes to a Document
Requirements
- This course was created with Word 2016. But all features will work in Word 2010, 2013, 2016, 2019 & 365 and most in 2007
- Microsoft Word 2010, Word 2013 or Word 2016 installed on your computer
- No prior Microsoft Word knowledge is needed
- Willingness to Learn
Description
At completion of this course you will have mastered the most popular and sought after Microsoft Word tools and come away with confidence to complete many Word tasks with efficiency enabling you to advance in your productivity and career. Below are just a few of the topics you will master:
- Creating Dynamic Microsoft Word Documents
- Effectively Formatting a Document with Styles
- Prepare Documents for Printing and Exporting
- Working with Page and Section Breaks
- Control Page Orientation
- Create and Manage Table Layouts
- Insert Media and Images
- Perform Mail and Email Merges to create Mailing Labels and Form Letters and Automated Emails
- Manage Templates
- Protect Documents from Edits
- Track and Accept/Reject Changes to a Document
- Build Dynamic Table of Contents
- and much, much more…
A Verifiable Certificate of Completion is presented to all students who undertake this course.
Please don’t forget that the course comes with an unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Why is this important?
You can include the course certificate on your resume. This will be valuable confirmation indicating you are familiar with the program and that you would not need tutoring in your first days on the job.
What makes this course different from the rest of the courses are out there?
- High quality of production – Full HD video along with embedded quizzes to reinforce the concepts.
- Knowledgeable instructor with 15+ years of experience in IT and training.
- Bite-sized learning – Our lectures are brief and to the point. We want your attention throughout the whole course
- Excellent support: If you don’t understand a concept, or would like to ask us a question, you’ll receive an answer within 24 hours
- Dynamic: We don’t want to waste your time! The instructor keeps up a very good pace throughout the whole course
Who this course is for:
- This course is intended for students and employees who wish to expand their skill set within Microsoft Word
Questions?
See also these FAQs.
Bulk Enrollments/Licensing
If you are a business owner and would like bulk enrollments/licensing, please contact us. Bulk discounts are available.
Microsoft Outlook for the Workplace
Master Microsoft Outlook for the workplace (corporate or education environment) with 30 lessons. Excellent course for those considering a new job or excelling in their career.
What you’ll learn
- Configure a personal or corporate account in Outlook
- Create and send email messages
- Create, categorize and organize Contacts
- Schedule and organize Events and Appointments
- Schedule Meetings, track replies and send updates
- Create, update and completing Tasks
Requirements
- This course was created with Outlook 2016. But most features will work in Outlook 2010, 2013, 2016, 2019 & 365..
- You will need Outlook loaded on your computer in order to follow along and practice.
Office for Professionals: Excel, Word, PowerPoint
Course includes: Excel for Workplace, PowerPoint for the Workplace and Microsoft Word. All three courses in one for a better price than the individual courses.
Demo Module - Sample Course
A couple sample modules as to what the actual course would look like. Click on enroll. It is free to access. Other courses are very similar.