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

Microsoft Office 2010 - The Ultimate MS Office 2010 Bundle

Course Summary

Master Microsoft Word, Excel, PowerPoint, and Access 2010 in easy steps with this comprehensive course on Office 2010


  • +

    Course Syllabus

    • Microsoft Excel 2010 - Beginners
      • Introduction 2010
      • Excel Chart Concepts
      • Chart Concepts 2010 With Solution (DOWNLOAD)
      • Creating Basic Charts
      • Chart Building 2010 Without Solution (DOWNLOAD)
      • Chart Building 2010 With Solution (DOWNLOAD)
      • Fine-tuning of charts in excel
      • Chart Options 1 and 2
      • Chart Options 3 and 4
      • Chart Options 2010 Without Solution (DOWNLOAD)
      • Chart Options 2010 With Solution (DOWNLOAD)
      • Format Tab Options
      • Column and Line Chart
      • Pie Diagram
      • Area Chart
      • Doughnut Bubble and Radar Chart
      • Specific Chart Types 2010 Without Solution (DOWNLOAD)
      • Specific Chart Types 2010 With Solution (DOWNLOAD)
      • Paste Chart Data
      • Multiple Source Data and Chart Table
      • Basic Dynamic Chart
      • Chart Sources 2010 Without Solution (DOWNLOAD)
      • Chart Sources 2010 With Solution (DOWNLOAD)
      • Dynamic Chart with Check boxes
      • Dynamic Pie Chart
      • Pareto Chart
      • Chart Filter
      • Advance Dynamic Chart
      • Calculator Chart
      • Pivot Chart
      • Specialized Charts & Graphs 2010 Without Solution (DOWNLOAD)
      • Specialized Charts & Graphs 2010 With Solution (DOWNLOAD)
    • Microsoft Excel 2010 - Advanced
      • Data Formatting
      • Create Pivot Table
      • Adjusting Fields
      • Consolidation Sheets
      • Managing Pivot Table
      • Basics of Pivot Table Without Solution
      • Basics of Pivot Table With Solution
      • Totals Display
      • Summary Display
      • Multiple Data Field
      • Data Grouping
      • Drill Down Data
      • Calculated Field
      • Summarizing Data Using Pivot Table Without Solution
      • Summarizing Data Using Pivot Table With Solution
      • Pivot Data Sorting
      • Customised Sorting
      • Limited Data Display
      • Rule Based Sorting
      • Data Slicer
      • Slicer Formatting
      • Filter Area
      • Removing Filter
      • Data Filtering Without Solution
      • Data Filtering With Solution
      • Formatting Pivot Table
      • Layouts In Pivot Table
      • Basics Pivot Table Formatting Without Solution
      • Basics Pivot Table Formatting With Solution
      • Rule Based Conditional Formatting
      • Top Bottom Rule Based
      • Data Bars
      • Adding Color Scales
      • Icon Indicators
      • Conditional Formatting
      • Basic Pivot Chart
      • Pivoting Pivot Chart
      • Filter Pivot Chart Data
      • Formatting Pivot Chart
      • Different Chart Types
      • Pivot Chart Without Solution
      • Pivot Chart With Solution
      • Print Table Part 1
      • Print Table Part 2
      • Print Separate
      • Print Headers
      • Printing Table With Headers
      • Print Table
      • First Macro
      • Executing The Macro
      • Macro without solution
      • Macro with solution
      • Starting With Power Pivot
      • Linked Table
      • Creating Relationships Between Tables
      • Pivot TableIn Power Pivot
      • Get External DataIn Power Pivot
      • Introduction of Power Pivot Without Solution
      • Introduction of Power Pivot With Solution
      • Introduction To DAX
      • Reference To Dax Functions
      • Adding Calculated Column
      • Adding Calculated Field
      • DAX in Power Pivot Without Solution
      • DAX in Power Pivot With Solution
    • Microsoft Access 2010 Tutorials
      • Introduction to Microsoft Access
      • Starting Microsoft Access
      • Trusting a File
      • Quick Access Toolbar
      • Backstage of Access
      • Exploring the Ribbons
      • Navigation Pane
      • Components of a Database
      • Planning and designing the database
      • Create a table in Layout View
      • Understanding the structure of a table
      • Create a table using design view
      • Create a table using calculated field
      • Field Properties
      • Importing data into Access
      • Formatting tools
      • Linking the tables
      • Using Query wizard for Simple Queries
      • Using design Query
      • Sorting data using Queries
      • Modifying the Queries
      • Building calculated fields
      • Create data entry forms
      • Create compound forms
      • Modifying forms in Layout and design view
      • Report on single table
      • Report on multiple table and formatting
      • Create reports through queries
      • Exporting data from Access
      • Creating a mail merge
    • Learn Microsoft Word 2010 - Beginners
      • Basic Microsoft Word 2010 Introduction
      • Basic Microsoft Word 2010 PDF
      • Introduction to Word 2010 & Understanding the Ribbons
      • Back Stage View & Quick Access Toolbar
      • Compatibility Mode & Navigation Pane 2010
      • Working with Text 2010
      • Selection of Text 2010
      • Find & Replace Text 2010
      • Understanding Fonts 2010
      • Working with fonts & applying basic formatting
      • Text effects 2010
      • How to save a word document 2010
      • Other file format 2010
      • Arranging paper margins, paper orientation & paper size 2010
      • Inserting columns & page break ups 2010
      • Using watermarks, page colour & page border 2010
      • Checking spelling & grammar 2010
      • Using thesaurus, word count & translate language 2010
      • Printing a document 2010
      • Setting Print Options 2010
      • Alignment, Justifying & Line Spacing 2010
      • Use of indents, tabs & bulleted or numbering list 2010
      • Demonstrating a document with pictures & clip art 2010
      • Positioning, Wrapping & Re-sizing a picture 2010
      • Use of table, smartart, charts & screen shots 2010
      • Special Effects 2010
      • Customizing a word & Ribbon 2010
    • Microsoft word 2010 - Advanced
      • Advance Microsoft Word 2010 Introduction
      • Understanding Themes 2010
      • Change style sets colours, fonts & paragraph spacing 2010
      • Creating quick styles & table of contents 2010
      • Restrict Formatting & Create Multi-level list 2010
      • Understanding of Tables 2010
      • Converting text into table, formatting and adding & rows in a table 2010
      • Creating a form 2010
      • Use of excel spreadsheet, sorting of data & converting table into text 2010
      • Understanding of Cover Page 2010+ Add Content
      • Numbering pages, headers, footers & text box 2010+ Add Content
      • Customising Headers & Footers 2010+ Add Content
      • Document Sharing 2010+ Add Content
      • Tracking Changes 2010
      • Accepting & Rejecting Changes 2010
      • Comparing & Combining Changes 2010
      • Mail Merge 2010
      • Protecting your document 2010


Course Fee:
USD 400

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

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