Ultimate Microsoft Office And Access 2013 Expert Bundle, 10 Certificate Courses

Gain Skills to Become an Expert in Access 2013

Ultimate Microsoft Office And Access 2013 Expert Bundle, 10 Certificate Courses

NOW ONLY

£339

Save £1919 (85%)
OFF RRP £2258
Get Info Pack

Get Access 2013 Expert, Access 2013 Advanced, Access 2013 Essentials, Excel 2013 Essentials, Excel 2013 Advanced, Excel 2013 Expert, Business Writing, Word 2013 Essentials, Word 2013 Advanced and Word 2013 Expert in this Bundle

1. Access 2013 Expert: Gain Skills to Become an Expert in Access 2013

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. This course is designed for the advanced users of Access 2013.

Access 2013 features a new framework that is designed for one purpose, to enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier for you.

This course covers everything from customizing your apps, to expert-level table, query, form, and report tasks. By the time you finish this course, you will be able to make the most out of Access 2013.

By the end of this course, you will be able to:

  • Create a custom app and use custom actions
  • Use macros in a custom app
  • Use validation rules and messages
  • Use macros in desktop databases
  • Perform advanced query tasks
  • Design custom forms
  • Perform advanced reporting tasks
  • Use advanced database tools
  • Customize the Access environment

2. Access 2013 Advanced: Get Ahead with Advanced Skills in Access 2013

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. You will learn how to use the advance features of Access to help you better manage a database.

This course is meant to provide a safe learning environment where you can practice and learn Access 2013 Advanced functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose?enable users to create data-centric web applications. Taking the time to learn the advanced features of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

This course will teach you how to customize your apps, as well as help you become an advanced user of desktop databases.

By the end of this Access 2013 Advanced Online Short Course, you will be able to:

  • Use Views in Your Apps
  • Customize Your Apps with Actions and Controls
  • Perform advanced record tasks
  • Add advanced types of fields
  • Use Field Validation options and other advanced field tasks
  • Use Table Design View
  • Use External Data

3. Access 2013 Essentials: Learn the Basic Features of Access 2013

Access is the world’s premier database software. You can use Access to create and edit databases, just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access.

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. You will learn how to use the basic features of Access to help better manage a database.

Access 2013 features a new framework that is designed for one purpos, to enable users to create data-centric web applications. Taking the time to learn the basic features of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier.

By the end of this Access 2013 Essentials Online Short Course, you will be able to:

  • Use the Access interface and understand security warnings
  • Understand database terms, tables, relationships, and other Access terms
  • Share data using apps
  • Work in an App
  • Understand desktop database basics
  • Perform basic table tasks
  • Work with fields and records
  • Perform basic tasks for queries, forms, and reports
  • Protect database data

4. Excel 2013 Essentials: Learn the Basic Features of Excel 2013

You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making!

By the end of this Excel 2013 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

5. Excel 2013 Advanced: Get Ahead with Advanced Skills in Excel 2013

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making!

Learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013.

At the end of this Excel 2013 Advanced Online Short Course, you will be able to:

  • Use SmartArt and other objects in worksheets
  • Trace precedent cells and dependent cells, as well as use other auditing tools
  • Create and work with charts
  • Create Pivot Tables and Pivot Charts
  • Record and run macros
  • Solve formula errors
  • Use What If Analysis tools
  • Use tools to manage rows, columns, duplicates, and validation
  • Group and outline data

6. Excel 2013 Expert: Acquire Expert Skills in Excel 2013

You will learn how to use the advanced features of Excel 2013. This course is designed to provide an in-depth understanding of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making!

At the end of this Excel 2013 Expert Online Short Course, you will be able to:

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables

7. Business Writing: Become an Expert at Writing Effective Emails, Letters, Reports and More

We all know that writing is one of the most important methods of business communication for most people, whether its e-mails, memos, proposals, or major reports. Lots of people struggle with the composition of these. Sometimes it's because they don't have to do it very often so, therefore, it doesn't flow as easily as they would like, sometimes because they are new to a role, or just because it's not their favorite thing.

This Business Writing Online Short Course will provide:

  • A quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) the things that we often miss especially when completing work under pressure; and
  • An overview of some the typical business documents, letters, reports, proposals that you may have to deal with, with tips on structure, style etc.

Course Topics:

  • Spelling
  • Punctuation
  • Writing the Letter
  • Proposals Key Info

By the end of the Business Writing Online Short Course, you will be able to:

  • Understand the function/purpose of all of the above.
  • Utilize the tips and techniques provided here to determine an appropriate structure to use for your business artifacts in different situations.
  • Define proofreading and understand the techniques in improving proofreading skills.
  • Define peer review and list ways peer review can help improve business writing skills.
  • Notice (and correct) common spelling and grammar issues in business writing.
  • List guidelines in printing and publishing business writing

8. Word 2013 Essentials: Learn the Basic Features of Word 2013

You will learn how to use the basic features of Word 2013. This course is designed to get into the standard features of Word 2013. You will get a chance to experience some of the new features that are offered in Word 2013.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

At the end of this Word 2013 Essentials Online Short Course, you should be able to:

  • Open and Close Word and Word files
  • Understand the interface, including the ribbon, the status bar, and the Backstage view
  • Create and save documents
  • Insert and work with text, symbols and numbers
  • Perform basic editing tasks
  • Format fonts, including face, size, color, enhancements, and case
  • Format paragraphs, including spacing, alignment, indents, tabs, bullets and numbering
  • Use more advanced formatting, including the font and paragraph dialog boxes
  • Use Styles and Themes
  • Format the page
  • Preview, print, share, or email document

9. Word 2013 Advanced: Learn Advanced Skills in Word 2013

In this course, we’ll cover some of the more advanced tasks in Word 2013. In addition to advanced editing and formatting tasks, you’ll learn how to really give your documents some flair with pictures and other objects. You’ll also learn about using generated tables of contents and indexes, and other research and review tasks.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

By the end of this Word 2013 Advanced Online Short Course, you will be able to:

  • Understand and use views and Word window tasks
  • Perform advanced editing and formatting tasks
  • Insert and format illustrations and pictures
  • Use SmartArt
  • Use tables and special objects such as cover pages and text boxes
  • Use different types of document references, such as an index or table of contents
  • Use translation, language and other review tasks

10. Word 2013 Expert: Become an Expert in Word 2013

This course will help you unlock even more advanced tools and features to have you editing and developing documents like an expert. This course is designed to get into the more in-depth features of Word 2013. You will get a chance to experience some of the new features that are offered in Word 2013.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

At the end of this Word 2013 Expert Online Short Course, you will be able to:

  • Customize Word
  • Create reusable content
  • Develop and use templates
  • Use sections
  • Use cross References
  • Create mail merges
  • Use master documents and subdocuments
  • Record and use macros
  • Develop forms

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Download printer friendly course content
  8. Certificates (IAOTS Accredited)

Course Delivery

Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device.

Recognition & Accreditation

These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Learn the Basic Features of Excel 2013

You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making!

By the end of this Excel 2013 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates 

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review at any time.

Ultimate Microsoft Office And Access 2013 Expert Bundle, 10 Courses includes the following courses, below is a summary of each course: 

Course 1 - Access 2013 Expert 

Module One: Getting Started

By the end of this course, you will be able to:

  • Create a custom app and use custom actions
  • Use macros in a custom app
  • Use validation rules and messages
  • Use macros in desktop databases
  • Perform advanced query tasks
  • Design custom forms
  • Perform advanced reporting tasks
  • Use advanced database tools
  • Customize the Access environment

Module Two: Creating a Custom App

  • Lesson One: Creating a Custom Web App
  • Lesson Two: Adding a Template Table
  • Lesson Three: Adding a Blank Table
  • Lesson Four: Importing Access 2010 Tables

Module Three: Customizing App Actions

  • Lesson One: Adding a Custom Action
  • Lesson Two: Editing an Action
  • Lesson Three: Deleting a Custom Action

Module Four: Customizing Your App Views with Macros

  • Lesson One: About User Interface Macros
  • Lesson Two: Creating an Embedded Macro
  • Lesson Three: Creating a Standalone Macro
  • Lesson Four: Saving Your App as a Package

Module Five: Working with Validation Rules and Messages

  • Lesson One: About Restricting Data Input
  • Lesson Two: Creating a Field Validation Rule
  • Lesson Three: Creating a Record Validation Rule
  • Lesson Four: Testing Validation Rules

Module Six: Working with Macros

  • Lesson One: Creating Data Macros
  • Lesson Two: Creating a Named Macro
  • Lesson Three: Renaming or Deleting Macros
  • Lesson Four: Creating an AutoExec Macro

Module Seven: Advanced Query Tasks

  • Lesson One: Creating an Update Query
  • Lesson Two: Creating a Parameter Query
  • Lesson Three: About Joining Data Sources in a Query

Module Eight: Designing Forms

  • Lesson One: Modifying Your Form in Design View
  • Lesson Two: Working with Form Controls
  • Lesson Three: Using the Property Sheet
  • Lesson Four: Adding Header and Footer Elements

Module Nine: Advanced Reporting Tasks

  • Lesson One: Using Report Design View
  • Lesson Two: Using Conditional Formatting
  • Lesson Three: Using the Group, Sort, and Total Pane
  • Lesson Four: Adding Calculated Controls
  • Lesson Five: Creating Labels

Module Ten: Advanced Database Tools

  • Lesson One: Using the Database Documenter
  • Lesson Two: Analyzing Table Performance
  • Lesson Three: Analyzing Database Performance
  • Lesson Four: Compacting and Repairing a Database

Module Eleven:  Working with the Access Environment 

  • Lesson One: Working with Database Properties
  • Lesson Two: Encrypting a Database with a Password
  • Lesson Three: Using Save Object As
  • Lesson Four: Setting Access Options

Module Twelve: Wrapping Up

Course 2 - Access 2013 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: Using App Views

  • Lesson One: Adding a New View
  • Lesson Two: Editing a View
  • Lesson Three: Adding a Popup View
  • Lesson Four: Deleting a View

Module Three: Customizing Apps, Part One

  • Lesson One: Opening a Table for Editing
  • Lesson Two: Modifying the Action Bar
  • Lesson Three: Formatting Controls
  • Lesson Four: Moving, Resizing, or Deleting Controls

Module Four: Customizing Apps, Part Two

  • Lesson One: Adding Controls from the Ribbon
  • Lesson Two: Adding Controls from the Field List
  • Lesson Three: Changing Control Properties

Module Five: Working with More Record Tasks

  • Lesson One: Adjusting Row Height and Width
  • Lesson Two: Hiding and Unhiding Fields
  • Lesson Three: Freezing and Unfreezing Fields
  • Lesson Four: Adding From Outlook
  • Lesson Five: Saving a Record as an Outlook Contact

Module Six: Using Advanced Field Tasks

  • Lesson One: Showing Totals
  • Lesson Two: Working with Required Fields and Unique Fields
  • Lesson Three: Working with Indexing
  • Lesson Four: Adding Lookup and Relationship Fields

Module Seven: Working in Table Design View

  • Lesson One: Opening Design View
  • Lesson Two: Setting the Primary Key
  • Lesson Three: Working with Field Properties

Module Eight: Working with the Expression Builder

  • Lesson One: Setting the Field Default Value
  • Lesson Two: Using the Expression Builder
  • Lesson Three: Adding the Calculated Fields

Module Nine: Working with External Data

  • Lesson One: Linking Data
  • Lesson Two: Importing Data
  • Lesson Three: About Exporting Data
  • Lesson Four: Exporting Data to Excel

Module Ten: Creating Queries

  • Lesson One: Creating a Select Query
  • Lesson Two: Creating a Make Table Query
  • Lesson Three: Creating an Append Query
  • Lesson Four: Creating a Cross Tab Query
  • Lesson Five: Showing and Removing Tables

Module Eleven: Creating Forms and Reports

  • Lesson One: Creating a Form with the Form Wizard
  • Lesson Two: Creating a Report with the Report Wizard
  • Lesson Three: Modifying Form Layout
  • Lesson Four: Key Features on the Report Tools Tab

Module Twelve: Wrapping Up

Course 3 - Access 2013 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Access

  • Lesson One: Opening Access
  • Lesson Two: Using the Recent List and Opening Files
  • Lesson Three: About Your Account
  • Lesson Four: Closing Files vs. Closing Access

Module Three: An Introduction to Databases

  • Lesson One: About Common Database Terms
  • Lesson Two: Using the Navigation Pane
  • Lesson Three: Understanding Tables and Table Relationships
  • Lesson Four: Understanding Queries
  • Lesson Five: Closing Database Objects

Module Four: Sharing Data Using Apps

  • Lesson One: Creating a New App Using a Template
  • Lesson Two: Select a Table Template
  • Lesson Three: Creating a Table By Importing Data
  • Lesson Four: Launching the App

Module Five: Working in Your App

  • Lesson One: Using the Search Box
  • Lesson Two: Using the Action Bar for Predefined Actions
  • Lesson Three: Working with Related Items and AutoComplete
  • Lesson Four: Grouping Data

Module Six: An Introduction to Desktop Databases

  • Lesson One: Working with a Table in Datasheet View
  • Lesson Two: About Keys, Data Types and Fields
  • Lesson Three: Searching for Records
  • Lesson Four: Deleting Records

Module Seven: Performing Basic Table Tasks

  • Lesson One: Entering and Editing Data
  • Lesson Two: Using the Clipboard
  • Lesson Three: Formatting Text
  • Lesson Four: Finding and Replacing Text

Module Eight: Working with Fields

  • Lesson One: Adding a Field by Entering Data
  • Lesson Two: Adding a Specific Type of Field
  • Lesson Three: Changing Field Name, Caption, or Description
  • Lesson Four: Changing the Data Type
  • Lesson Five: Changing Field Format
  • Lesson Six: Deleting a Field

Module Nine: Working with Table Relationships

  • Lesson One: Types of Relationships
  • Lesson Two: Viewing Relationships
  • Lesson Three: Ediiting Relationships
  • Lesson Four: Establising Referential Integrity

Module Ten: An Introduction to Queries, Forms, and Reports

  • Lesson One: Types of Queries
  • Lesson Two: Creating a Query with the Wizard
  • Lesson Three: Executing a Query
  • Lesson Four: Understanding Forms
  • Lesson Five: Understanding Reports

Module Eleven: Protecting Your Data

  • Lesson One: Planning Backups
  • Lesson Two: Backing Up a Database
  • Lesson Three: Restoring a Database
  • Lesson Four: Restoring Objects in a Database

Module Twelve: Module Twelve: Wrapping Up

Course 4 - Excel 2013 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Using Excel Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Using the Status Bar to Perform Calculations
  • Understanding the New Function Names

Module Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

Course 5 - Excel 2013 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: SmartArt and Objects

  • Inserting SmartArt
  • Editing the Diagram
  • Adding Pictures
  • Adding Textboxes
  • Drawing Shapes
  • About the Contextual Tabs

Module Three: Auditing

  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts

  • Using Recommended Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding Chart Elements
  • Resizing and Moving the Chart

Module Five: Working with Charts

  • Using Chart Elements
  • Using Chart Styles and Colors
  • Using Chart Filters
  • Working with Data Labels

Module Six: Creating Pivot Tables and Pivot Charts

  • Inserting a PivotTable using Excel Recommendations
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs
  • Changing the Data Displayed and Refreshing the PivotTable
  • Creating a Pivot Chart from a Pivot Table or Data
  • Some Real-life Examples

Module Seven: Macros

  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Using Error Checking
  • Using the Trace Errors Commands
  • Evaluating Formulas

Module Nine: Using What If Analysis

  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table
  • Using a Two Input Data Table

Module Ten: Managing Your Data

  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Creating Data Validation Rules
  • Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Course 6 - Excel 2013 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Working with Permissions and Options

  • Marking a Workbook as Final
  • Encrypting with a Password
  • Protecting the Current Sheet or the Workbook Structure
  • Adding a Digital Signature
  • Setting Excel Options
  • Managing Versions
  • Saving a Workbook as an Excel Template

Module Three: Sharing Workbooks

  • Inspecting a Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook

Module Four: Performing Advanced Formula and Function Tasks

  • Using the Watch Window
  • About the Excel Calculation Process
  • Setting Calculation Options
  • Enabling or Disabling Automatic Workbook Calculations
  • Using the IFERROR Function to Evaluate Formulas

Module Five: Working with Array Formulas

  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array

Module Six: Working With Macros

  • Assigning a Macro to a Command Button
  • Running a Macro by Clicking an Area of a Graphic Object
  • Configuring a Macro to Run Automatically Upon Opening the Workbook

Module Seven: Working With Forms

  • About Excel Forms, Form Controls, and Active X Controls
  • Using a Data Form
  • Using a List Box Control
  • Using a Combo Box Control
  • Using a Spin Button Control
  • Using a Scroll Bar Control

Module Eight: Applying Advanced Chart Features

  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Nine:  Working With Slicers and Timelines

  • About Slicers and Timelines
  • Creating a Slicer in an Existing Table
  • Formatting a Slicer
  • Using a Timeline

Module Ten: Working With Multiple Tables, Relationships and External Data

  • Connecting to a New External Data Source
  • Creating a PivotTable Using an External Data Connection
  • Working with PivotTables Based on Multiple Tables

Module Eleven: Working With PowerView

  • About Power View
  • Creating a Power View Sheet
  • Add a Table to the Data Model
  • Adding a Map to a Power View Report

Module Twelve: Wrapping Up

Course 7 - Business Writing

PART ONE – THE BUILDING BLOCKS

Section One: Getting Started

  • a quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) – the things that we often miss especially when completing work under pressure; and
  • an overview of some the typical business documents – letters, reports, proposals – that you may have to deal with, with tips on structure, style etc. 

Section Two: Spelling and Grammar

  • Spelling
  • Grammar

Section Three: Language and tone

  • Clarity
  • Conciseness
  • Formality
  • Focus
  • Tone

Section Four: Sentences and Paragraphs

  • Parts of a Sentence
  • Sentence Length
  • Punctuation
  • Paragraphs

Section Five: Organization and Structure

  • Organisation Approach

Section Six: Tools and Techniques

  • The Reader
  • The Requirement
  • Write faster – effective writing
  • Templates
  • Proofreading
  • Review/Peer Review
  • The Appearance - Printing and Publishing

PART TWO – THE DOCUMENTS

Section Seven: Meeting Agendas

  • The Basic Structure

Section Eight: E-mails

  • Addressing your mails
  • Brevity
  • Formality
  • Attachments
  • Forwarding/replying

Section Nine: Business Letters

  • The Basic Structure
  • Writing the Letter

Section Ten: Proposals

  • The Basic Outline
  • Key information
  • Sequence
  • Choosing a Format
  • Proposal Structure and Content
  • Executive Summaries

Section Eleven: Reports

  • Report Structure and format

Section Twelve: Requests for Proposal

  • Requests for Proposals

Section Thirteen: Business Cases

  • Business Cases

Section Fourteen: General Documentation

  • General Documentation

Section Fifteen: Wrapping Up

Course 8 - Word 2013 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening Word

  • Opening Word
  • Using the Recent List
  • Opening Files
  • Creating a Blank Document
  • Creating a Document From a Template

Module Three: Working with the Interface

  • Understanding the Interface
  • About Your Account and Feedback
  • An Introduction to Backstage View
  • Saving Files
  • Closing Files vs. Closing Word

Module Four: Your First Document

  • Typing Text
  • Selecting Text with the Mouse or Keyboard
  • Editing and Deleting Text
  • Dragging and Dropping Text
  • Inserting a Symbol or Number
  • Starting a New Page

Module Five: Basic Editing Tasks

  • Using Cut, Copy, and Paste
  • Using Undo and Redo
  • Finding and Replacing Text
  • Setting Paste Options
  • Checking Your Spelling

Module Six: Basic Formatting Tasks

  • Understanding Levels of Formatting
  • Changing Font Face and Size
  • Changing the Font Color
  • Highlighting Text
  • Adding Font Enhancements
  • Clearing Formatting

Module Seven: Formatting Paragraphs

  • Changing Spacing
  • Setting the Alignment
  • Using Indents and Tabs
  • Adding Bullets and Numbering
  • Adding Borders and Shading

Module Eight: Advanced Formatting Tasks

  • Changing Case
  • Using the Format Painter
  • Creating Multilevel Lists
  • Using the Font Dialog
  • Using the Paragraph Dialog

Module Nine: Working with Styles

  • About Styles
  • Applying a Style
  • Changing the Theme
  • Changing the Style Set
  • Changing Theme Colors and Fonts

Module Ten: Formatting the Page

  • Formatting Text as Columns
  • Changing Page Orientation
  • Changing the Page Color
  • Adding a Page Border
  • Adding Headers and Footers

Module Eleven: Sharing Your Document

  • Previewing and Printing Your Document
  • Sharing Your Document
  • E-Mailing Your Document

Module Twelve: Wrapping Up

Course 9 - Word 2013 Advanced

Module One: Getting Started

  • Coursae  Objectives

Module Two: Working with the Word Window

  • Using Zoom
  • An Overview of Word’s Views
  • Arranging Windows
  • Splitting a Document
  • Using the Navigation Pane
  • Customizing the Ribbon and the Quick Access Toolbar

Module Three: Advanced Editing and Formatting Tasks

  • Using the Office Clipboard
  • Using the Phonetic Guide
  • Using Character Borders and Shading
  • Enclosing Characters
  • Using Text Effects

Module Four: Working with Illustrations

  • Inserting a Picture from a File
  • Inserting an Online Picture
  • Adding WordArt
  • Drawing Shapes
  • Inserting a Screenshot
  • Moving or Deleting a Picture

Module Five: Formatting Pictures

  • Using the Picture Tools Tab
  • Adding a Border
  • Removing a Picture’s Background
  • Adding Artistic Effects
  • Positioning Pictures and Wrapping Text
  • Using the Selection Pane

Module Six: Adding SmartArt

  • Inserting SmartArt
  • Adding Text to SmartArt
  • Using the SmartArt Tools Tabs
  • Moving and Deleting SmartArt
  • Using SmartArt Layout and Style Options

Module Seven: Adding Tables

  • Inserting a Table
  • Adding Text to a Table
  • About the Table Tools Tabs
  • Altering Rows and Columns
  • Applying a Table Style
  • About Quick Tables

Module Eight: Inserting Special Objects

  • Adding a Cover Page
  • Inserting a Text Box
  • Inserting an App
  • Inserting Online Media
  • Inserting a Database

Module Nine: Working with Document References

  • Inserting a Caption
  • Adding a Table of Contents
  • Adding Footnotes, Endnotes, and Citations
  • Managing Sources
  • Inserting a Bibliography
  • Creating an Index

Module Ten: Reviewing Your Document

  • Using Define, Thesaurus and Word Count
  • Using Translation Tools
  • Setting Proofing Language and Language Preferences

Module Eleven:Using Comments and Tracking

  • Adding a Comment
  • Reviewing Comments
  • Tracking Changes
  • Reviewing Changes
  • Comparing and Combining Documents

Module Twelve: Wrapping Up

Course 10 - Word 2013 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Customizing Word

  • Setting Word Options
  • Protecting a Document
  • Checking for Issues
  • Managing Versions
  • Working with Properties

Module Three: Working with Reusable Content

  • Saving Selection as Autotext
  • Inserting a Quick Part
  • Creating Customized Building Blocks
  • Editing a Building Block

Module Four: Working with Templates

  • About Templates
  • Modifying an Existing Template
  • Creating a New Template
  • Applying a Template to an Existing Document
  • Managing Templates

Module Five: Working with Sections and Linked Content

  • Using Sections
  • Customizing Page Numbers in Sections
  • Using Multiple Page Formats in a Document
  • Using Different Headers and Footers in a Document
  • Linking and Breaking Links for Text Boxes

Module Six: Managing Versions and Tracking Documents

  • Merging Different Versions of a Document
  • Tracking Comments in a Combined Document
  • Reviewing Comments in a Combined Document

Module Seven: Using Cross References

  • Types of Cross References
  • Inserting a Bookmark
  • Inserting a Cross Reference
  • Updating a Cross Reference
  • Formatting Cross References Using Fields

Module Eight: Creating Mail Merges and Labels

  • Creating a Mail Merge
  • Creating Barcodes
  • Creating Return Address Labels
  • Using Avery Label Templates

Module Nine: Working with Master Documents

  • Creating a Master Document
  • Creating Subdocuments
  • Inserting a Subdocument
  • Expanding and Collapsing Subdocuments
  • Merging and Splitting Subdocuments
  • Unlinking a Subdocument
  • Locking a Master Document

Module Ten: Working with Macros

  • Recording a Macro
  • Running a Macro
  • Applying Macro Security
  • Assigning a Macro to a Command Button or Shortcut Key

Module Eleven: Working with Forms

  • Displaying the Developer Tab
  • Using Form Controls
  • Locking and Unlocking a Form
  • Adding and Removing Fields
  • Linking a Form to a Database

Module Twelve: Wrapping Up

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

About this Course

Get Access 2013 Expert, Access 2013 Advanced, Access 2013 Essentials, Excel 2013 Essentials, Excel 2013 Advanced, Excel 2013 Expert, Business Writing, Word 2013 Essentials, Word 2013 Advanced and Word 2013 Expert in this Bundle

1. Access 2013 Expert: Gain Skills to Become an Expert in Access 2013

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. This course is designed for the advanced users of Access 2013.

Access 2013 features a new framework that is designed for one purpose, to enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier for you.

This course covers everything from customizing your apps, to expert-level table, query, form, and report tasks. By the time you finish this course, you will be able to make the most out of Access 2013.

By the end of this course, you will be able to:

  • Create a custom app and use custom actions
  • Use macros in a custom app
  • Use validation rules and messages
  • Use macros in desktop databases
  • Perform advanced query tasks
  • Design custom forms
  • Perform advanced reporting tasks
  • Use advanced database tools
  • Customize the Access environment

2. Access 2013 Advanced: Get Ahead with Advanced Skills in Access 2013

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. You will learn how to use the advance features of Access to help you better manage a database.

This course is meant to provide a safe learning environment where you can practice and learn Access 2013 Advanced functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose?enable users to create data-centric web applications. Taking the time to learn the advanced features of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

This course will teach you how to customize your apps, as well as help you become an advanced user of desktop databases.

By the end of this Access 2013 Advanced Online Short Course, you will be able to:

  • Use Views in Your Apps
  • Customize Your Apps with Actions and Controls
  • Perform advanced record tasks
  • Add advanced types of fields
  • Use Field Validation options and other advanced field tasks
  • Use Table Design View
  • Use External Data

3. Access 2013 Essentials: Learn the Basic Features of Access 2013

Access is the world’s premier database software. You can use Access to create and edit databases, just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access.

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. You will learn how to use the basic features of Access to help better manage a database.

Access 2013 features a new framework that is designed for one purpos, to enable users to create data-centric web applications. Taking the time to learn the basic features of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier.

By the end of this Access 2013 Essentials Online Short Course, you will be able to:

  • Use the Access interface and understand security warnings
  • Understand database terms, tables, relationships, and other Access terms
  • Share data using apps
  • Work in an App
  • Understand desktop database basics
  • Perform basic table tasks
  • Work with fields and records
  • Perform basic tasks for queries, forms, and reports
  • Protect database data

4. Excel 2013 Essentials: Learn the Basic Features of Excel 2013

You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making!

By the end of this Excel 2013 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

5. Excel 2013 Advanced: Get Ahead with Advanced Skills in Excel 2013

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making!

Learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013.

At the end of this Excel 2013 Advanced Online Short Course, you will be able to:

  • Use SmartArt and other objects in worksheets
  • Trace precedent cells and dependent cells, as well as use other auditing tools
  • Create and work with charts
  • Create Pivot Tables and Pivot Charts
  • Record and run macros
  • Solve formula errors
  • Use What If Analysis tools
  • Use tools to manage rows, columns, duplicates, and validation
  • Group and outline data

6. Excel 2013 Expert: Acquire Expert Skills in Excel 2013

You will learn how to use the advanced features of Excel 2013. This course is designed to provide an in-depth understanding of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making!

At the end of this Excel 2013 Expert Online Short Course, you will be able to:

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables

7. Business Writing: Become an Expert at Writing Effective Emails, Letters, Reports and More

We all know that writing is one of the most important methods of business communication for most people, whether its e-mails, memos, proposals, or major reports. Lots of people struggle with the composition of these. Sometimes it's because they don't have to do it very often so, therefore, it doesn't flow as easily as they would like, sometimes because they are new to a role, or just because it's not their favorite thing.

This Business Writing Online Short Course will provide:

  • A quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) the things that we often miss especially when completing work under pressure; and
  • An overview of some the typical business documents, letters, reports, proposals that you may have to deal with, with tips on structure, style etc.

Course Topics:

  • Spelling
  • Punctuation
  • Writing the Letter
  • Proposals Key Info

By the end of the Business Writing Online Short Course, you will be able to:

  • Understand the function/purpose of all of the above.
  • Utilize the tips and techniques provided here to determine an appropriate structure to use for your business artifacts in different situations.
  • Define proofreading and understand the techniques in improving proofreading skills.
  • Define peer review and list ways peer review can help improve business writing skills.
  • Notice (and correct) common spelling and grammar issues in business writing.
  • List guidelines in printing and publishing business writing

8. Word 2013 Essentials: Learn the Basic Features of Word 2013

You will learn how to use the basic features of Word 2013. This course is designed to get into the standard features of Word 2013. You will get a chance to experience some of the new features that are offered in Word 2013.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

At the end of this Word 2013 Essentials Online Short Course, you should be able to:

  • Open and Close Word and Word files
  • Understand the interface, including the ribbon, the status bar, and the Backstage view
  • Create and save documents
  • Insert and work with text, symbols and numbers
  • Perform basic editing tasks
  • Format fonts, including face, size, color, enhancements, and case
  • Format paragraphs, including spacing, alignment, indents, tabs, bullets and numbering
  • Use more advanced formatting, including the font and paragraph dialog boxes
  • Use Styles and Themes
  • Format the page
  • Preview, print, share, or email document

9. Word 2013 Advanced: Learn Advanced Skills in Word 2013

In this course, we’ll cover some of the more advanced tasks in Word 2013. In addition to advanced editing and formatting tasks, you’ll learn how to really give your documents some flair with pictures and other objects. You’ll also learn about using generated tables of contents and indexes, and other research and review tasks.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

By the end of this Word 2013 Advanced Online Short Course, you will be able to:

  • Understand and use views and Word window tasks
  • Perform advanced editing and formatting tasks
  • Insert and format illustrations and pictures
  • Use SmartArt
  • Use tables and special objects such as cover pages and text boxes
  • Use different types of document references, such as an index or table of contents
  • Use translation, language and other review tasks

10. Word 2013 Expert: Become an Expert in Word 2013

This course will help you unlock even more advanced tools and features to have you editing and developing documents like an expert. This course is designed to get into the more in-depth features of Word 2013. You will get a chance to experience some of the new features that are offered in Word 2013.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

At the end of this Word 2013 Expert Online Short Course, you will be able to:

  • Customize Word
  • Create reusable content
  • Develop and use templates
  • Use sections
  • Use cross References
  • Create mail merges
  • Use master documents and subdocuments
  • Record and use macros
  • Develop forms

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Download printer friendly course content
  8. Certificates (IAOTS Accredited)

Course Delivery

Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device.

Recognition & Accreditation

These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Learn the Basic Features of Excel 2013

You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making!

By the end of this Excel 2013 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates 

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review at any time.

Ultimate Microsoft Office And Access 2013 Expert Bundle, 10 Courses includes the following courses, below is a summary of each course: 

Course 1 - Access 2013 Expert 

Module One: Getting Started

By the end of this course, you will be able to:

  • Create a custom app and use custom actions
  • Use macros in a custom app
  • Use validation rules and messages
  • Use macros in desktop databases
  • Perform advanced query tasks
  • Design custom forms
  • Perform advanced reporting tasks
  • Use advanced database tools
  • Customize the Access environment

Module Two: Creating a Custom App

  • Lesson One: Creating a Custom Web App
  • Lesson Two: Adding a Template Table
  • Lesson Three: Adding a Blank Table
  • Lesson Four: Importing Access 2010 Tables

Module Three: Customizing App Actions

  • Lesson One: Adding a Custom Action
  • Lesson Two: Editing an Action
  • Lesson Three: Deleting a Custom Action

Module Four: Customizing Your App Views with Macros

  • Lesson One: About User Interface Macros
  • Lesson Two: Creating an Embedded Macro
  • Lesson Three: Creating a Standalone Macro
  • Lesson Four: Saving Your App as a Package

Module Five: Working with Validation Rules and Messages

  • Lesson One: About Restricting Data Input
  • Lesson Two: Creating a Field Validation Rule
  • Lesson Three: Creating a Record Validation Rule
  • Lesson Four: Testing Validation Rules

Module Six: Working with Macros

  • Lesson One: Creating Data Macros
  • Lesson Two: Creating a Named Macro
  • Lesson Three: Renaming or Deleting Macros
  • Lesson Four: Creating an AutoExec Macro

Module Seven: Advanced Query Tasks

  • Lesson One: Creating an Update Query
  • Lesson Two: Creating a Parameter Query
  • Lesson Three: About Joining Data Sources in a Query

Module Eight: Designing Forms

  • Lesson One: Modifying Your Form in Design View
  • Lesson Two: Working with Form Controls
  • Lesson Three: Using the Property Sheet
  • Lesson Four: Adding Header and Footer Elements

Module Nine: Advanced Reporting Tasks

  • Lesson One: Using Report Design View
  • Lesson Two: Using Conditional Formatting
  • Lesson Three: Using the Group, Sort, and Total Pane
  • Lesson Four: Adding Calculated Controls
  • Lesson Five: Creating Labels

Module Ten: Advanced Database Tools

  • Lesson One: Using the Database Documenter
  • Lesson Two: Analyzing Table Performance
  • Lesson Three: Analyzing Database Performance
  • Lesson Four: Compacting and Repairing a Database

Module Eleven:  Working with the Access Environment 

  • Lesson One: Working with Database Properties
  • Lesson Two: Encrypting a Database with a Password
  • Lesson Three: Using Save Object As
  • Lesson Four: Setting Access Options

Module Twelve: Wrapping Up

Course 2 - Access 2013 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: Using App Views

  • Lesson One: Adding a New View
  • Lesson Two: Editing a View
  • Lesson Three: Adding a Popup View
  • Lesson Four: Deleting a View

Module Three: Customizing Apps, Part One

  • Lesson One: Opening a Table for Editing
  • Lesson Two: Modifying the Action Bar
  • Lesson Three: Formatting Controls
  • Lesson Four: Moving, Resizing, or Deleting Controls

Module Four: Customizing Apps, Part Two

  • Lesson One: Adding Controls from the Ribbon
  • Lesson Two: Adding Controls from the Field List
  • Lesson Three: Changing Control Properties

Module Five: Working with More Record Tasks

  • Lesson One: Adjusting Row Height and Width
  • Lesson Two: Hiding and Unhiding Fields
  • Lesson Three: Freezing and Unfreezing Fields
  • Lesson Four: Adding From Outlook
  • Lesson Five: Saving a Record as an Outlook Contact

Module Six: Using Advanced Field Tasks

  • Lesson One: Showing Totals
  • Lesson Two: Working with Required Fields and Unique Fields
  • Lesson Three: Working with Indexing
  • Lesson Four: Adding Lookup and Relationship Fields

Module Seven: Working in Table Design View

  • Lesson One: Opening Design View
  • Lesson Two: Setting the Primary Key
  • Lesson Three: Working with Field Properties

Module Eight: Working with the Expression Builder

  • Lesson One: Setting the Field Default Value
  • Lesson Two: Using the Expression Builder
  • Lesson Three: Adding the Calculated Fields

Module Nine: Working with External Data

  • Lesson One: Linking Data
  • Lesson Two: Importing Data
  • Lesson Three: About Exporting Data
  • Lesson Four: Exporting Data to Excel

Module Ten: Creating Queries

  • Lesson One: Creating a Select Query
  • Lesson Two: Creating a Make Table Query
  • Lesson Three: Creating an Append Query
  • Lesson Four: Creating a Cross Tab Query
  • Lesson Five: Showing and Removing Tables

Module Eleven: Creating Forms and Reports

  • Lesson One: Creating a Form with the Form Wizard
  • Lesson Two: Creating a Report with the Report Wizard
  • Lesson Three: Modifying Form Layout
  • Lesson Four: Key Features on the Report Tools Tab

Module Twelve: Wrapping Up

Course 3 - Access 2013 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Access

  • Lesson One: Opening Access
  • Lesson Two: Using the Recent List and Opening Files
  • Lesson Three: About Your Account
  • Lesson Four: Closing Files vs. Closing Access

Module Three: An Introduction to Databases

  • Lesson One: About Common Database Terms
  • Lesson Two: Using the Navigation Pane
  • Lesson Three: Understanding Tables and Table Relationships
  • Lesson Four: Understanding Queries
  • Lesson Five: Closing Database Objects

Module Four: Sharing Data Using Apps

  • Lesson One: Creating a New App Using a Template
  • Lesson Two: Select a Table Template
  • Lesson Three: Creating a Table By Importing Data
  • Lesson Four: Launching the App

Module Five: Working in Your App

  • Lesson One: Using the Search Box
  • Lesson Two: Using the Action Bar for Predefined Actions
  • Lesson Three: Working with Related Items and AutoComplete
  • Lesson Four: Grouping Data

Module Six: An Introduction to Desktop Databases

  • Lesson One: Working with a Table in Datasheet View
  • Lesson Two: About Keys, Data Types and Fields
  • Lesson Three: Searching for Records
  • Lesson Four: Deleting Records

Module Seven: Performing Basic Table Tasks

  • Lesson One: Entering and Editing Data
  • Lesson Two: Using the Clipboard
  • Lesson Three: Formatting Text
  • Lesson Four: Finding and Replacing Text

Module Eight: Working with Fields

  • Lesson One: Adding a Field by Entering Data
  • Lesson Two: Adding a Specific Type of Field
  • Lesson Three: Changing Field Name, Caption, or Description
  • Lesson Four: Changing the Data Type
  • Lesson Five: Changing Field Format
  • Lesson Six: Deleting a Field

Module Nine: Working with Table Relationships

  • Lesson One: Types of Relationships
  • Lesson Two: Viewing Relationships
  • Lesson Three: Ediiting Relationships
  • Lesson Four: Establising Referential Integrity

Module Ten: An Introduction to Queries, Forms, and Reports

  • Lesson One: Types of Queries
  • Lesson Two: Creating a Query with the Wizard
  • Lesson Three: Executing a Query
  • Lesson Four: Understanding Forms
  • Lesson Five: Understanding Reports

Module Eleven: Protecting Your Data

  • Lesson One: Planning Backups
  • Lesson Two: Backing Up a Database
  • Lesson Three: Restoring a Database
  • Lesson Four: Restoring Objects in a Database

Module Twelve: Module Twelve: Wrapping Up

Course 4 - Excel 2013 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Using Excel Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Using the Status Bar to Perform Calculations
  • Understanding the New Function Names

Module Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

Course 5 - Excel 2013 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: SmartArt and Objects

  • Inserting SmartArt
  • Editing the Diagram
  • Adding Pictures
  • Adding Textboxes
  • Drawing Shapes
  • About the Contextual Tabs

Module Three: Auditing

  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts

  • Using Recommended Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding Chart Elements
  • Resizing and Moving the Chart

Module Five: Working with Charts

  • Using Chart Elements
  • Using Chart Styles and Colors
  • Using Chart Filters
  • Working with Data Labels

Module Six: Creating Pivot Tables and Pivot Charts

  • Inserting a PivotTable using Excel Recommendations
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs
  • Changing the Data Displayed and Refreshing the PivotTable
  • Creating a Pivot Chart from a Pivot Table or Data
  • Some Real-life Examples

Module Seven: Macros

  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Using Error Checking
  • Using the Trace Errors Commands
  • Evaluating Formulas

Module Nine: Using What If Analysis

  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table
  • Using a Two Input Data Table

Module Ten: Managing Your Data

  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Creating Data Validation Rules
  • Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Course 6 - Excel 2013 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Working with Permissions and Options

  • Marking a Workbook as Final
  • Encrypting with a Password
  • Protecting the Current Sheet or the Workbook Structure
  • Adding a Digital Signature
  • Setting Excel Options
  • Managing Versions
  • Saving a Workbook as an Excel Template

Module Three: Sharing Workbooks

  • Inspecting a Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook

Module Four: Performing Advanced Formula and Function Tasks

  • Using the Watch Window
  • About the Excel Calculation Process
  • Setting Calculation Options
  • Enabling or Disabling Automatic Workbook Calculations
  • Using the IFERROR Function to Evaluate Formulas

Module Five: Working with Array Formulas

  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array

Module Six: Working With Macros

  • Assigning a Macro to a Command Button
  • Running a Macro by Clicking an Area of a Graphic Object
  • Configuring a Macro to Run Automatically Upon Opening the Workbook

Module Seven: Working With Forms

  • About Excel Forms, Form Controls, and Active X Controls
  • Using a Data Form
  • Using a List Box Control
  • Using a Combo Box Control
  • Using a Spin Button Control
  • Using a Scroll Bar Control

Module Eight: Applying Advanced Chart Features

  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Nine:  Working With Slicers and Timelines

  • About Slicers and Timelines
  • Creating a Slicer in an Existing Table
  • Formatting a Slicer
  • Using a Timeline

Module Ten: Working With Multiple Tables, Relationships and External Data

  • Connecting to a New External Data Source
  • Creating a PivotTable Using an External Data Connection
  • Working with PivotTables Based on Multiple Tables

Module Eleven: Working With PowerView

  • About Power View
  • Creating a Power View Sheet
  • Add a Table to the Data Model
  • Adding a Map to a Power View Report

Module Twelve: Wrapping Up

Course 7 - Business Writing

PART ONE – THE BUILDING BLOCKS

Section One: Getting Started

  • a quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) – the things that we often miss especially when completing work under pressure; and
  • an overview of some the typical business documents – letters, reports, proposals – that you may have to deal with, with tips on structure, style etc. 

Section Two: Spelling and Grammar

  • Spelling
  • Grammar

Section Three: Language and tone

  • Clarity
  • Conciseness
  • Formality
  • Focus
  • Tone

Section Four: Sentences and Paragraphs

  • Parts of a Sentence
  • Sentence Length
  • Punctuation
  • Paragraphs

Section Five: Organization and Structure

  • Organisation Approach

Section Six: Tools and Techniques

  • The Reader
  • The Requirement
  • Write faster – effective writing
  • Templates
  • Proofreading
  • Review/Peer Review
  • The Appearance - Printing and Publishing

PART TWO – THE DOCUMENTS

Section Seven: Meeting Agendas

  • The Basic Structure

Section Eight: E-mails

  • Addressing your mails
  • Brevity
  • Formality
  • Attachments
  • Forwarding/replying

Section Nine: Business Letters

  • The Basic Structure
  • Writing the Letter

Section Ten: Proposals

  • The Basic Outline
  • Key information
  • Sequence
  • Choosing a Format
  • Proposal Structure and Content
  • Executive Summaries

Section Eleven: Reports

  • Report Structure and format

Section Twelve: Requests for Proposal

  • Requests for Proposals

Section Thirteen: Business Cases

  • Business Cases

Section Fourteen: General Documentation

  • General Documentation

Section Fifteen: Wrapping Up

Course 8 - Word 2013 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening Word

  • Opening Word
  • Using the Recent List
  • Opening Files
  • Creating a Blank Document
  • Creating a Document From a Template

Module Three: Working with the Interface

  • Understanding the Interface
  • About Your Account and Feedback
  • An Introduction to Backstage View
  • Saving Files
  • Closing Files vs. Closing Word

Module Four: Your First Document

  • Typing Text
  • Selecting Text with the Mouse or Keyboard
  • Editing and Deleting Text
  • Dragging and Dropping Text
  • Inserting a Symbol or Number
  • Starting a New Page

Module Five: Basic Editing Tasks

  • Using Cut, Copy, and Paste
  • Using Undo and Redo
  • Finding and Replacing Text
  • Setting Paste Options
  • Checking Your Spelling

Module Six: Basic Formatting Tasks

  • Understanding Levels of Formatting
  • Changing Font Face and Size
  • Changing the Font Color
  • Highlighting Text
  • Adding Font Enhancements
  • Clearing Formatting

Module Seven: Formatting Paragraphs

  • Changing Spacing
  • Setting the Alignment
  • Using Indents and Tabs
  • Adding Bullets and Numbering
  • Adding Borders and Shading

Module Eight: Advanced Formatting Tasks

  • Changing Case
  • Using the Format Painter
  • Creating Multilevel Lists
  • Using the Font Dialog
  • Using the Paragraph Dialog

Module Nine: Working with Styles

  • About Styles
  • Applying a Style
  • Changing the Theme
  • Changing the Style Set
  • Changing Theme Colors and Fonts

Module Ten: Formatting the Page

  • Formatting Text as Columns
  • Changing Page Orientation
  • Changing the Page Color
  • Adding a Page Border
  • Adding Headers and Footers

Module Eleven: Sharing Your Document

  • Previewing and Printing Your Document
  • Sharing Your Document
  • E-Mailing Your Document

Module Twelve: Wrapping Up

Course 9 - Word 2013 Advanced

Module One: Getting Started

  • Coursae  Objectives

Module Two: Working with the Word Window

  • Using Zoom
  • An Overview of Word’s Views
  • Arranging Windows
  • Splitting a Document
  • Using the Navigation Pane
  • Customizing the Ribbon and the Quick Access Toolbar

Module Three: Advanced Editing and Formatting Tasks

  • Using the Office Clipboard
  • Using the Phonetic Guide
  • Using Character Borders and Shading
  • Enclosing Characters
  • Using Text Effects

Module Four: Working with Illustrations

  • Inserting a Picture from a File
  • Inserting an Online Picture
  • Adding WordArt
  • Drawing Shapes
  • Inserting a Screenshot
  • Moving or Deleting a Picture

Module Five: Formatting Pictures

  • Using the Picture Tools Tab
  • Adding a Border
  • Removing a Picture’s Background
  • Adding Artistic Effects
  • Positioning Pictures and Wrapping Text
  • Using the Selection Pane

Module Six: Adding SmartArt

  • Inserting SmartArt
  • Adding Text to SmartArt
  • Using the SmartArt Tools Tabs
  • Moving and Deleting SmartArt
  • Using SmartArt Layout and Style Options

Module Seven: Adding Tables

  • Inserting a Table
  • Adding Text to a Table
  • About the Table Tools Tabs
  • Altering Rows and Columns
  • Applying a Table Style
  • About Quick Tables

Module Eight: Inserting Special Objects

  • Adding a Cover Page
  • Inserting a Text Box
  • Inserting an App
  • Inserting Online Media
  • Inserting a Database

Module Nine: Working with Document References

  • Inserting a Caption
  • Adding a Table of Contents
  • Adding Footnotes, Endnotes, and Citations
  • Managing Sources
  • Inserting a Bibliography
  • Creating an Index

Module Ten: Reviewing Your Document

  • Using Define, Thesaurus and Word Count
  • Using Translation Tools
  • Setting Proofing Language and Language Preferences

Module Eleven:Using Comments and Tracking

  • Adding a Comment
  • Reviewing Comments
  • Tracking Changes
  • Reviewing Changes
  • Comparing and Combining Documents

Module Twelve: Wrapping Up

Course 10 - Word 2013 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Customizing Word

  • Setting Word Options
  • Protecting a Document
  • Checking for Issues
  • Managing Versions
  • Working with Properties

Module Three: Working with Reusable Content

  • Saving Selection as Autotext
  • Inserting a Quick Part
  • Creating Customized Building Blocks
  • Editing a Building Block

Module Four: Working with Templates

  • About Templates
  • Modifying an Existing Template
  • Creating a New Template
  • Applying a Template to an Existing Document
  • Managing Templates

Module Five: Working with Sections and Linked Content

  • Using Sections
  • Customizing Page Numbers in Sections
  • Using Multiple Page Formats in a Document
  • Using Different Headers and Footers in a Document
  • Linking and Breaking Links for Text Boxes

Module Six: Managing Versions and Tracking Documents

  • Merging Different Versions of a Document
  • Tracking Comments in a Combined Document
  • Reviewing Comments in a Combined Document

Module Seven: Using Cross References

  • Types of Cross References
  • Inserting a Bookmark
  • Inserting a Cross Reference
  • Updating a Cross Reference
  • Formatting Cross References Using Fields

Module Eight: Creating Mail Merges and Labels

  • Creating a Mail Merge
  • Creating Barcodes
  • Creating Return Address Labels
  • Using Avery Label Templates

Module Nine: Working with Master Documents

  • Creating a Master Document
  • Creating Subdocuments
  • Inserting a Subdocument
  • Expanding and Collapsing Subdocuments
  • Merging and Splitting Subdocuments
  • Unlinking a Subdocument
  • Locking a Master Document

Module Ten: Working with Macros

  • Recording a Macro
  • Running a Macro
  • Applying Macro Security
  • Assigning a Macro to a Command Button or Shortcut Key

Module Eleven: Working with Forms

  • Displaying the Developer Tab
  • Using Form Controls
  • Locking and Unlocking a Form
  • Adding and Removing Fields
  • Linking a Form to a Database

Module Twelve: Wrapping Up

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

We provide a 7 Day Money Back Refund on all Courses

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value £300)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Training 2 Or More People?


Empower your business with access to 500+ job & soft skills online training courses.

SUCCESS PRO - For Business

Course Summary

Course ID: CFS02A13EX10CB
Delivery Mode: Online
Access: Unlimited lifetime access to course material
Time: Study at your own pace
Duration: 60-80 Hours for total bundle
Assessments: Yes
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner