MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

The Ultimate Microsoft Office 2010 Training Bundle

Course Summary

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2010 Inside And Out—Quickly, No Travel or Classes.


  • +

    Course Syllabus

    • Learn Microsoft Excel 2010 Beginner Course
      • Introduction and Overview of Excel 2010 Course
      • Overview of the Excel Window
      • Working with the Mouse
      • Excel Options
      • Entering Text and Numbers
      • Creating Basic Formulas
      • Relative References
      • Order of Operations
      • Working withe Ranges
      • Working with Save and Save As Commands
      • File Extensions
      • Opening a File
      • Working with Larger Files
      • Freeze Panes Options
      • Split Screen Option
      • Page Setup Options
      • Headers and Footers
      • Print Titles
      • Comments
      • Fit to Print on One Page
      • Printing Workbooks
      • Adding and Deleting Rows, Columns, and Cells
      • Changing Column and Row Widths
      • Cut, Copy and Paste
      • Copying Formulas
      • Overview of Formulas
      • Create Formulas using Functions - Part 1
      • Create Formulas using Functions - Part 2
      • Absolute Values
      • Adding, Deleting and Renaming Sheets
      • Additional Sheet Tab Options
      • 3-D Formulas
      • Cell Formatting
      • Number Formatting
      • Borders and Shading
      • Format as Table
      • Using Styles
      • Using Format Painter
      • Protecting Sheets
      • Fill Handle and Custom Lists
      • Creating Charts
      • Types of Charts
      • Editing Charts
      • Using Graphics to Enhance Charts
      • Creating Range Names
      • Managing Names
      • Using Names in Formulas
      • Removing Duplicates
      • Sort Data
      • Filter Data
      • Advanced Filters
      • Creating an Outline - Part 1
      • Creating an Outline - Part 2
      • Subtotals
      • New Window Option
      • Arrange File Options
      • Creating a Workspace
      • Custom Views
      • Scenarios
      • Creating Formulas Between Files
      • Working with Links
      • IF Statement
      • VLookups
      • Consolidating Data
      • Data Validation
      • Formula Auditing
      • Comments
      • Goal Seeker
      • Text to Columns Option
      • Watch Window
      • Closing Video
      • Excel 2010 Quiz
    • Learn Microsoft Excel 2010 Advanced Course
      • Introduction to Advanced Excel 2010
      • Four Basic Steps When Creating Charts/Graphs
      • Additional Features to Help Create Charts/Graphs
      • Additional Features to Help Create Charts/Graphs Part 2
      • Detailed Formatting for Charts/Graphs
      • Formatting Legends within Charts/Graphs
      • Formatting Axes and Gridlines within Charts/Graphs
      • Trends within Charts and Graphs
      • Complex Trends within Charts and Graphs
      • Trends over Time within Charts and Graphs
      • Showing Differences Using Bar Charts
      • Showing Differences Using Pie Charts
      • Limitations with Pie Charts & How to Correct
      • Alternative Ways to Show Differences
      • Using Charts & Graphs to Show Relationships
      • Using Charts & Graphs to Show Relationships Part 2
      • Charting & Graphing Financial Information
      • Charting & Graphing Financial Information Part 2
      • Specific Charts for Finance Information
      • Setting Up Live Charts
      • Using Sparklines for Data Visualization
      • Using and Formatting Data Bars, Color Scales & Icon Sets
      • Setting Up Pivot Tables/Charts
      • Setting Up Pivot Tables/Charts Part 2
      • Filtering Pivot Tables/Charts
      • New Features for Pivot Tables/Charts
      • Graphics Tools
      • Graphics Tools Part 2
      • Exporting Charts and Graphs
      • Exporting Charts and Graphs Part 2
      • Excel 2010 Advanced Quiz
    • Learn Microsoft Word 2010
      • Getting Started in Word 2010
      • Learning the Workspace
      • Learning the Workspace Part 2
      • Create New Document, Using Templates, and Page Setup
      • Converting and Saving Documents
      • Selecting Text; Cut, Copy, Paste; Drag & Drop
      • Insert/Overtype; Navigation Pane; Find & Replace
      • Hyphenation, Auto-Correct, and Redo
      • Text Formatting
      • Paragraph Formatting Options
      • Formatting with Bullets, Indents, Borders, Shading
      • Creating/Saving New Template; Changing Styles
      • Managing, Modifying and Deleting New Styles
      • Working with/Using Themes
      • Inserting/Formatting ClipArt, Pictures
      • Using Picture Tools & New Features
      • Inserting Screenshots, Using WordArt
      • Using SmartArt, SmartArt Tools
      • Inserting Tables; Adding Text; Selecting Parts of Tables
      • Formatting Tables; Table Tools
      • Inserting Charts; Chart Tools
      • Creating Charts with Pre-existing Data
      • Desktop Publishing Adding Drop Caps, Watermarks, Borders, Page Colors
      • Using/Formatting Multi-Columns; Text Boxes
      • Inserting/Resizing Shapes
      • Stacking, Grouping Objects
      • Creating Outline, Sub-Documents
      • Expand/Collapse Sections; Document Properties; Cover Pages
      • Add Table of Contents: Header & Footer Tools; Quick Parts
      • Line-numbering, Adding Bibliography & Index
      • Understanding Formatting Marks; Sections Features
      • Inserting Symbols, Equations, Auto-Text, Building Blocks
      • Inserting Footnotes, Bookmarks, Cross-references
      • Setting up Mail Merge Using Wizard
      • Manual Mail Merge Set-up
      • Spelling/Grammar Check
      • Using Thesaurus, Research Option, Translate; Printing Document
      • Publishing to Web Publishing & Accessing Word Documents on Web
      • Using Document Inspector, Password Protect, Editing Restrictions
      • Reviewing & Sharing Reviewing, Sharing and Leaving/Adding Comments
      • Customizing Word Customizing with Word Options
      • Expanding Word Functionality; Using Macros
      • Importing/Exporting, Embedding Document to Other Programs
      • Check for Updates, Safe Mode
      • Word 2010 Quiz
    • Learn Microsoft Outlook 2010
      • Course Review
      • Getting Started
      • Overview of Calendar, Appointments, Contacts, Tasks, Notes
      • Adding New Accounts, Removing Accounts
      • Add Items, To-Do Options and Customization
      • Creating New Task, Modifying Details, Recurring Tasks
      • Calendar Displays, Set Up/Edit/Delete Appointments
      • Using Help Options; Add/Edit/Delete Contacts
      • Create, Edit, Forward Notes
      • Options, Create, Send Journal Entries
      • Customize Quick Access Toolbar & the Ribbon
      • Customizing Workspace Views Part 1
      • Customizing Workspace Views Part 2
      • Managing Data File Folders
      • Outlook Connector; Customizing Mail
      • Creating Rules for Sent/Incoming Emails
      • Formatting Email Messages
      • General Mail Options
      • Assigning/Completing Tasks
      • Forward/Edit/Group Contacts
      • Setting Up Meeting Requests; Calendar Options
      • Setup RSS Feeds
      • Organize RSS Feeds, New Social Connection
      • Junk Mail Options, Dealing with Junk Mail
      • Filtering Through & Searching for Specific Emails
      • Auto Archive Options & Manual Archive
      • Email Security & Maintenance
      • Outlook 2010 Quiz
    • Learn Microsoft PowerPoint 2010
      • Introduction
      • Introduction to PowerPoint 2010 Basics
      • Start and Exit
      • PowerPoint 2010 Window
      • The Ribbon
      • The Backstage: Open, Save, Close
      • Options
      • Different Views
      • Introduction to Working with Slides
      • Manage Slide Appearance
      • Working with Text
      • Outlining a Presentation
      • Slide Management
      • Working with Shapes
      • Working with Tables
      • Using SmartArt
      • Using Templates
      • Working with Themes
      • Introduction to Beyond Basics
      • Using Hyperlinks
      • Working with Clips, Pictures, & Screenshots
      • Multimedia: Audio & Video
      • Animation
      • Transitions
      • Compare & Merge Presentations
      • Sharing with Other Office 2010 Applications
      • Introduction to Presenting Your Presentations
      • Using Notes
      • Creating Handouts
      • Printing Presentations and Notes/Handouts
      • Automated Self-Running Slide Shows
      • Annotating While Presenting
      • Concluding the Course
      • PowerPoint 2010 Quiz
    • Learn Microsoft Access 2010 Beginner Course
      • Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
      • Start/Exit, Help Features, Shortcuts, Views, Templates
      • Understanding Database Components
      • Introduction to Design of a Database
      • Introduction to Building a Database
      • Creating Tables & Basic Setup of Relationships
      • Using Quick Parts to Setup New Table, Importing Spreadsheet
      • Entering Data Types into Tables
      • Changing Table Attributes, Copy, Rename, Delete Records
      • Table Structures
      • Table and Field Properties
      • Auto-Create Forms, Filtering & Searching
      • Types of Different Forms & Creating New
      • Improve Look, Style, & Feel of Forms
      • Adding Fields to Existing Form
      • Understanding and Setting Up the Expression Builder
      • Format Control on Forms/Reports
      • Sorting Single & Multiple Columns; Filter One Field Data Records
      • Sorting & Filtering Data in Form View; Find & Replace in Forms
      • Understanding Reports & Structure
      • Creating Reports; Using Print Preview to Check Report Outcome
      • Advanced Reporting; Formatting Reports
      • How to Improve Report Design, Add Existing Fields; Group/Sort
      • Select Queries; Sorting; Defined Criteria
      • Change Fields wthin Query; Specifying Criteria for Numbers/Text
      • Update Queries; Append Queries; Delete Queries
      • Inner/Outer Joins; Make Table Queries; Mail Merge
      • Securing Database and Views; New Features
      • Access 2010 Quiz
    • Learn Microsoft Access 2010 Advanced Training Course
      • Introduction to Advanced Access 2010
      • Working with Macros
      • AutoExec Macro
      • Database Options
      • More Database Options
      • Renaming Database Objects
      • Basics & Understanding Data Types
      • Table and Field Properties
      • Validation Rules & Text
      • Understanding & Using Keys and Indexes
      • Data Normalization
      • Types of Relationships
      • Maintaining Relationships
      • Using & Understanding Queries
      • Complex Queries
      • Creating Queries and Using Join & Sub-Queries
      • Datasheet View
      • Creating & Working with Forms
      • Using Forms to Maintain Data
      • Command Buttons
      • Command Buttons Part 2
      • Form Features that Need VBA Code
      • Understanding When & How to Use VBA
      • More about VBA and Using It to Improve Database
      • VBA Language Structure & Making a Switchboard
      • Error Handling
      • Cleaning Up Before Distribution16
      • Security Techniques
      • External Data & Importng/Exporting Data
      • Linking to Excel & Linking to Another Database
      • Separating/Splitting Up Forms, Reports, etc from Database
      • Options for Making Changes When Database is Multi-User
      • Advanced Features for Reports
      • Advanced Features for Reports Part 2
      • Distributing Application
      • Access 2010 Advanced Quiz


Course Fee:
USD 247

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top