SharePoint Designer 2010 Essentials Online Bundle, 5 Certificate Courses

Learn the Basic Features of SharePoint Designer 2010


NOW ONLY

£4343

Save £11151 (72%)
OFF RRP £15495
Get Info Pack

Get SharePoint Designer 2010 Essentials, Word 2010 Advanced, Word 2010 Essentials, Word 2010 Expert and Excel 2010 Essentials in this Bundle

1. SharePoint Designer 2010 Essentials: Learn the Basic Features of SharePoint Designer 2010

You can use SharePoint Designer 2010 to design, build, and customize Web sites running on SharePoint Foundation 2010 and Microsoft SharePoint Server 2010.

With SharePoint Designer 2010 you'll learn how to create data-rich Web pages, build powerful workflow-enabled solutions, and design the look and feel of your site. SharePoint Designer a great tool and this Essentials course will provide you with a solid foundation to start building your SharePoint skill set.

By the end of this SharePoint Designer 2010 Essentials Online Short Course, you will be able to:

  • SharePoint Designer is a powerful tool, but beware that even though you don’t need to know coding, you can break aspects of the site if you aren’t careful.
  • Get to know the different types of Summary pages so that you can learn how to change all of the settings for different types of items.
  • SharePoint Designer can control permissions, lists and libraries, pages, and content types.
  • Use the Master Pages functionality to create a consistent look and feel across all of your sites and sub-sites.
  • Create custom views to quickly obtain the information you need.
  • Workflows can automate many different types of business processes.

2. Word 2010 Advanced: Learn Advanced Skills in Word 2010

You will learn how to use the advanced features of Word 2010. This course is designed to teach you a basic understanding of Word 2010 in a practical way.

In this course, we’ll cover some of the more advanced tasks in Word 2010, like working with pictures and other objects, using generated tables of contents and indexes, and other research and review tasks.

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

  • Use Zoom
  • Understand Word Views
  • Split a Document
  • Use the Navigation Pane
  • Insert ClipArt, Pictures from Files, and Screen Shots
  • Move or Delete a Picture
  • Use the Picture Tools Tab
  • Remove a Picture’s Background
  • Adding Artistic Effects
  • Changing a Picture’s Layout
  • Use SmartArt
  • Work with Tables
  • Use the Table Tools Tab
  • Apply a Style to a Table
  • Add a Cover Page
  • Add Word Art
  • Draw Shapes
  • Add a Text Box
  • Add a Table of Contents
  • Manage Sources
  • Add Footnotes, Endnotes, and Citations
  • Insert a Bibliography
  • Create an Index
  • View Synonyms
  • Use the Research Task Pane
  • Use Translation ScreenTips
  • Set Your Language
  • Use Comments
  • Track and Review Changes
  • Compare Documents
  • Minimize the Ribbon
  • Customize the Quick Access Toolbar
  • Access Word Options

3. Word 2010 Essentials: Learn the Basic Features Word 2010

You will learn how to use the basic features of Word 2010. This course is designed to teach you a basic understanding of Word 2010 in a practical way.

Word is a powerful word processing application. However, it does much more than create simple documents. It includes several desktop publishing features to make your documents look great.

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

  • Open and close Word
  • Understand the Word 2010 interface
  • Use the backstage view to create a new blank document or a document from a template
  • Use the backstage view to open files and use the recent list
  • Save documents
  • Type, select, and edit text
  • Use page breaks to start a new page
  • Use cut, copy, and paste, as well as the Office Clipboard Task pane
  • Set default paste options
  • Undo and redo tasks
  • Find and replace text
  • Use the Selection pane to select pictures or objects
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Use borders and shading
  • Understand, create and use styles
  • Use themes
  • Add headers and footers
  • Format text as columns
  • Change page orientation
  • Add a page border or color
  • Use the page setup dialog
  • Check spelling
  • Preview, print, or email a document

4. Word 2010 Expert: Become an Expert with Word  2010

This course will help you unlock even more advanced tools and features to have you editing and developing documents like an expert.

In this Word 2010 Expert workshop, you will cover some of the more advanced tasks like Mail Merge, Tracking Documents, Working with Templates, Reusable and Linked Content, and other research and review tasks.

By the end of this Word 2010 Expert Online Short Course, you should be able to:

  • Understand document Information
  • Protect a document
  • Check for issues
  • Manage versions
  • Customize Word Options
  • Create and use customized building blocks and Autotext
  • Understand how to use, modify, create and manage templates
  • Apply a template to an existing document
  • Use sections
  • Customize page numbers in sections
  • Use multiple page formats in a document
  • Use different headers and footers in a document
  • Use text box links
  • Merge different versions of a document
  • Track comments in a combined document
  • Review comments in a combined document
  • Understand the different types of cross references
  • Insert a bookmark or cross reference
  • Update a cross reference
  • Format cross references using fields
  • Create a mail merge
  • Send personalized email messages to multiple recipients
  • Use other data sources for mail merge
  • Create labels
  • Create envelope and label forms
  • Create a master document
  • Insert or create a subdocument
  • Expand and collapse subdocuments
  • Unlink a subdocument
  • Merge and split subdocuments
  • Lock a master document
  • Record or run a macro
  • Apply macro security
  • Assign a macro to a command button or keyboard shortcut
  • Create a form
  • Use form controls
  • Lock and unlock a form
  • Add and remove fields

5. Excel 2010 Essentials: Learn the Basic Features of Excel 2010

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!

By the end of this Excel 2010 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

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.

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

The SharePoint Designer 2010 Essentials 5 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - SharePoint Designer 2010 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing SharePoint Designer

  • Lesson One: About SharePoint Designer 2010
  • Lesson Two: Opening SharePoint Designer
  • Lesson Three: Understanding the Interface
  • Lesson Four: Using Backstage View
  • Lesson Five: Closing SharePoint Designer

Module Three: Creating and Opening Sites

  • Lesson One: Opening a Site
  • Lesson Two: Creating a New Blank Web Site
  • Lesson Three: Creating a Site from a Template
  • Lesson Four: Saving Sites
  • Lesson Five: Closing a Site

Module Four: Working with Sites

  • Lesson One: Understanding the Site Tab
  • Lesson Two: Understanding the Site Summary Page
  • Lesson Three: Adding Users or Groups to Your Site
  • Lesson Four: Changing Site Permissions
  • Lesson Five: Editing or Deleting a Site

Module Five: Working with Lists and Libraries

  • Lesson One: About Lists and Libraries
  • Lesson Two: Working with Lists and Libraries
  • Lesson Three: Creating a New List or Library
  • Lesson Four: Working with Columns in Lists and Libraries

Module Six: Working with Site Pages and Master Pages

  • Lesson One: Working with Site Pages
  • Lesson Two: Working with Version History
  • Lesson Three: Editing a Page
  • Lesson Four: About Master Pages
  • Lesson Five: Working with Master Pages
  • Lesson Six: Working with Content Placeholders

Module Seven: Working with Content Types

  • Lesson One: Understanding Content Types
  • Lesson Two: Working with Content Types
  • Lesson Three: Creating a Content Type
  • Lesson Four: Editing a Content Type
  • Lesson Five: Deleting a Content Type
  • Lesson Six: Adding Columns to a Content Type

Module Eight: Working with Data Views and Forms

  • Lesson One: About Data Views and List Views
  • Lesson Two: About Data View/Form Web Parts
  • Lesson Three: Creating a View
  • Lesson Four: Creating a Data Form
  • Lesson Five: Editing a List Form
  • Lesson Six: Customizing Data Views and Forms

Module Nine: Working with Workflows

  • Lesson One: About Workflows
  • Lesson Two: Understanding the Workflow Tab and Summary Page
  • Lesson Three: About Workflow Customization
  • Lesson Four: Copying and Modifying a Workflow

Module Ten: Connecting to Data

  • Lesson One: Working with Data Sources
  • Lesson Two: Adding a Linked Data Source
  • Lesson Three: Copying and Modifying a Data Source

Module Eleven: Working with Templates

  • Lesson One: About Templates
  • Lesson Two: Saving a Site Template in the Solution Gallery
  • Lesson Three: Activating a Site Template in the Solution Gallery

Module Twelve: Wrapping Up

Course 2 - Word 2010 Advanced

Module One: Getting Started 

  • Course 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 

Module Three: Adding Pictures 

  • Inserting Clip Art
  • Inserting a Picture from a File 
  • Inserting a Screenshot
  • Moving or Deleting a Picture 

Module Four: Formatting Pictures 

  • Using the Picture Tools Tab 
  • Removing a Picture’s Background 
  • Adding Artistic Effects
  • Changing Picture Layout

Module Five: Adding SmartArt

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

Module Six: Adding Tables 

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

Module Seven: Inserting Special Objects 

  • Adding a Cover Page 
  • Adding WordArt
  • Drawing Shapes
  • Adding a Text Box 

Module Eight: Adding In Document References 

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

Module Nine: Advanced Research Tasks 

  • Viewing Synonyms
  • Using the Research Task Pane 
  • Using Translation ScreenTips
  • Setting the Language 

Module Ten: Reviewing a Document

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

Module Eleven: Customizing Word 

  • Minimizing the Ribbon 
  • Customizing the Quick Access Toolbar
  • Accessing Word’s Options
  • Changing Word’s Color Scheme

Module Twelve: Wrapping Up

Course 3 - Word 2010 Essentials

Module One: Getting Started  

  • Course Objectives 

Module Two: Opening and Closing Word  

  • Opening Word  
  • Understanding the Interface  
  • Using Backstage View   
  • Creating a Blank Document 
  • Closing Word  

Module Three: Working with Documents 

  • Saving Files 
  • Opening Files 
  • Closing Files 
  • Creating a Document from a Template  
  • Using the Recent List 

Module Four: Your First Document 

  • Typing Text 
  • Selecting Text with the Mouse or Keyboard  
  • Dragging and Dropping Text 
  • Starting a New Page  

Module Five: Basic Editing Tasks

  • Using Cut, Copy, and Paste  
  • Using the Office Clipboard  
  • Using Undo and Redo  
  • Finding and Replacing Text 
  • Setting Paste Options 
  • Using the Selection Pane  

Module Six: Basic Formatting Tasks 

  • Understanding Levels of Formatting 
  • Changing Font Face and Size  
  • Changing the Font Color 
  • Adding Font Enhancements 
  • Adding a Visual Effect 
  • Clearing Formatting 

Module Seven: Advanced Formatting Tasks 

  • Highlighting Text 
  • Changing Case  
  • Using the Format Painter 
  • Using the Font Dialog 
  • Setting Open Text Options 

Module Eight: Formatting Paragraphs 

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

Module Nine: Working with Styles 

  • About Styles 
  • Applying a Style  
  • Changing the Style Set 
  • Changing the Theme  
  • Changing Theme Elements 

Module Ten: Formatting the Page  

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

Module Eleven: Adding the Finishing Touches 

  • Checking Your Spelling 
  • Previewing Your Document 
  • Printing Your Document
  • E-Mailing Your Document 

Module Twelve: Wrapping Up

Course 4 - Word 2010 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Working with Document Information and Word Customization

  • Understanding Document Information
  • Password Protecting a Document
  • Checking for Issues
  • Managing Versions
  • Customizing Word Options

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: Working with Mail Merges

  • Creating a Mail Merge
  • Sending Personalized Email Messages to Multiple Recipients
  • About Other Data Sources for Mail Merge
  • Creating Labels
  • About Envelope and Label Forms

Module Nine: Working with Master Documents

  • Creating a Master Document
  • Creating Subdocuments
  • Inserting a Subdocument
  • Expanding and Collapsing Subdocuments
  • Unlinking a Subdocument
  • Merging and Splitting Subdocuments
  • 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

  • Creating a Form
  • Using Form Controls
  • Locking and Unlocking a Form
  • Adding and Removing Fields
  • Linking a Form to a Database

Module Twelve: Wrapping Up

Course 5 - Excel 2010 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

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

About this Course

Get SharePoint Designer 2010 Essentials, Word 2010 Advanced, Word 2010 Essentials, Word 2010 Expert and Excel 2010 Essentials in this Bundle

1. SharePoint Designer 2010 Essentials: Learn the Basic Features of SharePoint Designer 2010

You can use SharePoint Designer 2010 to design, build, and customize Web sites running on SharePoint Foundation 2010 and Microsoft SharePoint Server 2010.

With SharePoint Designer 2010 you'll learn how to create data-rich Web pages, build powerful workflow-enabled solutions, and design the look and feel of your site. SharePoint Designer a great tool and this Essentials course will provide you with a solid foundation to start building your SharePoint skill set.

By the end of this SharePoint Designer 2010 Essentials Online Short Course, you will be able to:

  • SharePoint Designer is a powerful tool, but beware that even though you don’t need to know coding, you can break aspects of the site if you aren’t careful.
  • Get to know the different types of Summary pages so that you can learn how to change all of the settings for different types of items.
  • SharePoint Designer can control permissions, lists and libraries, pages, and content types.
  • Use the Master Pages functionality to create a consistent look and feel across all of your sites and sub-sites.
  • Create custom views to quickly obtain the information you need.
  • Workflows can automate many different types of business processes.

2. Word 2010 Advanced: Learn Advanced Skills in Word 2010

You will learn how to use the advanced features of Word 2010. This course is designed to teach you a basic understanding of Word 2010 in a practical way.

In this course, we’ll cover some of the more advanced tasks in Word 2010, like working with pictures and other objects, using generated tables of contents and indexes, and other research and review tasks.

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

  • Use Zoom
  • Understand Word Views
  • Split a Document
  • Use the Navigation Pane
  • Insert ClipArt, Pictures from Files, and Screen Shots
  • Move or Delete a Picture
  • Use the Picture Tools Tab
  • Remove a Picture’s Background
  • Adding Artistic Effects
  • Changing a Picture’s Layout
  • Use SmartArt
  • Work with Tables
  • Use the Table Tools Tab
  • Apply a Style to a Table
  • Add a Cover Page
  • Add Word Art
  • Draw Shapes
  • Add a Text Box
  • Add a Table of Contents
  • Manage Sources
  • Add Footnotes, Endnotes, and Citations
  • Insert a Bibliography
  • Create an Index
  • View Synonyms
  • Use the Research Task Pane
  • Use Translation ScreenTips
  • Set Your Language
  • Use Comments
  • Track and Review Changes
  • Compare Documents
  • Minimize the Ribbon
  • Customize the Quick Access Toolbar
  • Access Word Options

3. Word 2010 Essentials: Learn the Basic Features Word 2010

You will learn how to use the basic features of Word 2010. This course is designed to teach you a basic understanding of Word 2010 in a practical way.

Word is a powerful word processing application. However, it does much more than create simple documents. It includes several desktop publishing features to make your documents look great.

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

  • Open and close Word
  • Understand the Word 2010 interface
  • Use the backstage view to create a new blank document or a document from a template
  • Use the backstage view to open files and use the recent list
  • Save documents
  • Type, select, and edit text
  • Use page breaks to start a new page
  • Use cut, copy, and paste, as well as the Office Clipboard Task pane
  • Set default paste options
  • Undo and redo tasks
  • Find and replace text
  • Use the Selection pane to select pictures or objects
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Use borders and shading
  • Understand, create and use styles
  • Use themes
  • Add headers and footers
  • Format text as columns
  • Change page orientation
  • Add a page border or color
  • Use the page setup dialog
  • Check spelling
  • Preview, print, or email a document

4. Word 2010 Expert: Become an Expert with Word  2010

This course will help you unlock even more advanced tools and features to have you editing and developing documents like an expert.

In this Word 2010 Expert workshop, you will cover some of the more advanced tasks like Mail Merge, Tracking Documents, Working with Templates, Reusable and Linked Content, and other research and review tasks.

By the end of this Word 2010 Expert Online Short Course, you should be able to:

  • Understand document Information
  • Protect a document
  • Check for issues
  • Manage versions
  • Customize Word Options
  • Create and use customized building blocks and Autotext
  • Understand how to use, modify, create and manage templates
  • Apply a template to an existing document
  • Use sections
  • Customize page numbers in sections
  • Use multiple page formats in a document
  • Use different headers and footers in a document
  • Use text box links
  • Merge different versions of a document
  • Track comments in a combined document
  • Review comments in a combined document
  • Understand the different types of cross references
  • Insert a bookmark or cross reference
  • Update a cross reference
  • Format cross references using fields
  • Create a mail merge
  • Send personalized email messages to multiple recipients
  • Use other data sources for mail merge
  • Create labels
  • Create envelope and label forms
  • Create a master document
  • Insert or create a subdocument
  • Expand and collapse subdocuments
  • Unlink a subdocument
  • Merge and split subdocuments
  • Lock a master document
  • Record or run a macro
  • Apply macro security
  • Assign a macro to a command button or keyboard shortcut
  • Create a form
  • Use form controls
  • Lock and unlock a form
  • Add and remove fields

5. Excel 2010 Essentials: Learn the Basic Features of Excel 2010

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!

By the end of this Excel 2010 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

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.

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

The SharePoint Designer 2010 Essentials 5 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - SharePoint Designer 2010 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing SharePoint Designer

  • Lesson One: About SharePoint Designer 2010
  • Lesson Two: Opening SharePoint Designer
  • Lesson Three: Understanding the Interface
  • Lesson Four: Using Backstage View
  • Lesson Five: Closing SharePoint Designer

Module Three: Creating and Opening Sites

  • Lesson One: Opening a Site
  • Lesson Two: Creating a New Blank Web Site
  • Lesson Three: Creating a Site from a Template
  • Lesson Four: Saving Sites
  • Lesson Five: Closing a Site

Module Four: Working with Sites

  • Lesson One: Understanding the Site Tab
  • Lesson Two: Understanding the Site Summary Page
  • Lesson Three: Adding Users or Groups to Your Site
  • Lesson Four: Changing Site Permissions
  • Lesson Five: Editing or Deleting a Site

Module Five: Working with Lists and Libraries

  • Lesson One: About Lists and Libraries
  • Lesson Two: Working with Lists and Libraries
  • Lesson Three: Creating a New List or Library
  • Lesson Four: Working with Columns in Lists and Libraries

Module Six: Working with Site Pages and Master Pages

  • Lesson One: Working with Site Pages
  • Lesson Two: Working with Version History
  • Lesson Three: Editing a Page
  • Lesson Four: About Master Pages
  • Lesson Five: Working with Master Pages
  • Lesson Six: Working with Content Placeholders

Module Seven: Working with Content Types

  • Lesson One: Understanding Content Types
  • Lesson Two: Working with Content Types
  • Lesson Three: Creating a Content Type
  • Lesson Four: Editing a Content Type
  • Lesson Five: Deleting a Content Type
  • Lesson Six: Adding Columns to a Content Type

Module Eight: Working with Data Views and Forms

  • Lesson One: About Data Views and List Views
  • Lesson Two: About Data View/Form Web Parts
  • Lesson Three: Creating a View
  • Lesson Four: Creating a Data Form
  • Lesson Five: Editing a List Form
  • Lesson Six: Customizing Data Views and Forms

Module Nine: Working with Workflows

  • Lesson One: About Workflows
  • Lesson Two: Understanding the Workflow Tab and Summary Page
  • Lesson Three: About Workflow Customization
  • Lesson Four: Copying and Modifying a Workflow

Module Ten: Connecting to Data

  • Lesson One: Working with Data Sources
  • Lesson Two: Adding a Linked Data Source
  • Lesson Three: Copying and Modifying a Data Source

Module Eleven: Working with Templates

  • Lesson One: About Templates
  • Lesson Two: Saving a Site Template in the Solution Gallery
  • Lesson Three: Activating a Site Template in the Solution Gallery

Module Twelve: Wrapping Up

Course 2 - Word 2010 Advanced

Module One: Getting Started 

  • Course 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 

Module Three: Adding Pictures 

  • Inserting Clip Art
  • Inserting a Picture from a File 
  • Inserting a Screenshot
  • Moving or Deleting a Picture 

Module Four: Formatting Pictures 

  • Using the Picture Tools Tab 
  • Removing a Picture’s Background 
  • Adding Artistic Effects
  • Changing Picture Layout

Module Five: Adding SmartArt

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

Module Six: Adding Tables 

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

Module Seven: Inserting Special Objects 

  • Adding a Cover Page 
  • Adding WordArt
  • Drawing Shapes
  • Adding a Text Box 

Module Eight: Adding In Document References 

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

Module Nine: Advanced Research Tasks 

  • Viewing Synonyms
  • Using the Research Task Pane 
  • Using Translation ScreenTips
  • Setting the Language 

Module Ten: Reviewing a Document

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

Module Eleven: Customizing Word 

  • Minimizing the Ribbon 
  • Customizing the Quick Access Toolbar
  • Accessing Word’s Options
  • Changing Word’s Color Scheme

Module Twelve: Wrapping Up

Course 3 - Word 2010 Essentials

Module One: Getting Started  

  • Course Objectives 

Module Two: Opening and Closing Word  

  • Opening Word  
  • Understanding the Interface  
  • Using Backstage View   
  • Creating a Blank Document 
  • Closing Word  

Module Three: Working with Documents 

  • Saving Files 
  • Opening Files 
  • Closing Files 
  • Creating a Document from a Template  
  • Using the Recent List 

Module Four: Your First Document 

  • Typing Text 
  • Selecting Text with the Mouse or Keyboard  
  • Dragging and Dropping Text 
  • Starting a New Page  

Module Five: Basic Editing Tasks

  • Using Cut, Copy, and Paste  
  • Using the Office Clipboard  
  • Using Undo and Redo  
  • Finding and Replacing Text 
  • Setting Paste Options 
  • Using the Selection Pane  

Module Six: Basic Formatting Tasks 

  • Understanding Levels of Formatting 
  • Changing Font Face and Size  
  • Changing the Font Color 
  • Adding Font Enhancements 
  • Adding a Visual Effect 
  • Clearing Formatting 

Module Seven: Advanced Formatting Tasks 

  • Highlighting Text 
  • Changing Case  
  • Using the Format Painter 
  • Using the Font Dialog 
  • Setting Open Text Options 

Module Eight: Formatting Paragraphs 

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

Module Nine: Working with Styles 

  • About Styles 
  • Applying a Style  
  • Changing the Style Set 
  • Changing the Theme  
  • Changing Theme Elements 

Module Ten: Formatting the Page  

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

Module Eleven: Adding the Finishing Touches 

  • Checking Your Spelling 
  • Previewing Your Document 
  • Printing Your Document
  • E-Mailing Your Document 

Module Twelve: Wrapping Up

Course 4 - Word 2010 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Working with Document Information and Word Customization

  • Understanding Document Information
  • Password Protecting a Document
  • Checking for Issues
  • Managing Versions
  • Customizing Word Options

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: Working with Mail Merges

  • Creating a Mail Merge
  • Sending Personalized Email Messages to Multiple Recipients
  • About Other Data Sources for Mail Merge
  • Creating Labels
  • About Envelope and Label Forms

Module Nine: Working with Master Documents

  • Creating a Master Document
  • Creating Subdocuments
  • Inserting a Subdocument
  • Expanding and Collapsing Subdocuments
  • Unlinking a Subdocument
  • Merging and Splitting Subdocuments
  • 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

  • Creating a Form
  • Using Form Controls
  • Locking and Unlocking a Form
  • Adding and Removing Fields
  • Linking a Form to a Database

Module Twelve: Wrapping Up

Course 5 - Excel 2010 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

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

We provide a 7 Day Money Back Refund on all Courses

Now Only £4343 Save £11151 (72%)
OFF RRP £15495
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value £7,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.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 020SPD10ES5CB
Delivery Mode: Online
Course Access: Unlimited lifetime access to course material
Time required: Study at your own pace
Course Duration: 30-48 Hours
Assessments: Yes
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles