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 2013 - The Ultimate MS Office 2013 Bundle

Course Summary

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


  • +

    Course Syllabus

    • Overview
      • Overview
    • Getting Started
      • Opening Excel
      • Familiarity with excel interface and Ribbons
      • Surfing an excel worksheet and How to use HELP in MS Excel
    • Case Study
      • Case Study
      • XYZ Company Basic Excel Case Study
    • Data Entry
      • Data Entry in excel
    • Populating the Case Study in Excel
      • Populating the Case Study in Excel
      • Populating case study in excel (without solution)
      • Populating case study in excel (with solution)
    • Calculations
      • Calculations
      • Calculations (without solution)
      • Calculations (with solution)
    • Formulas
      • Formulas - Autosum, Max
      • Formulas - Min, Average
    • Excel 2013 - Financial functions using Excel
      • Introduction
      • DOWNLOAD Course Materials
      • Understanding Future Value
      • Calculation of Future Value
      • Calculating Simple and compound Interest
      • Calculation of FV using compound interest
      • Understanding Present Value (PV)
      • Calculate NPER and RATE
      • Lender and Borrower FV
      • DOWNLOADABLE Course Materials
      • Multiple cash flows
      • Multiple cash flows- FV Calculation
      • Asset valuation using DCF analysis
      • DOWNLOADABLE Course Materials
      • Understanding NPV and IRR calculation
      • Understanding project selection using NPV and IRR
      • Understanding NPV and IRR at different cash flow intervals
      • Understanding XNPV
      • Understanding XIRR
      • DOWNLOADABLE Course Materials
      • Understanding the PMT functions
      • Calculating loan payment with grace period
      • Understanding PPMT and IPMT
      • DOWNLOADABLE Course Materials
      • Calculating the PRICE of the bond (premium bonds)
      • Calculating the PRICE of the bond (discounted bonds)
      • Calculating the YIELD
      • Calculating the DURATION
    • Excel 2013 - Excel Graphs & Charts
      • Learning about Excel Charts & Graphs 2013
      • 01 Understanding Excel Charts
      • Chart Concepts 2013 Without Solution (DOWNLOAD)
      • Chart Concepts 2013 With Solution (DOWNLOAD)
      • 02 Basic Learning of Excel Charts
      • Chart Building 2013 With Solution (DOWNLOAD)
      • Chart Building 2013 Without Solution (DOWNLOAD)
      • 03 Alteration of Excel Charts
      • 04 Modifying Options of Charts - part 1
      • 04 Modifying Options of Charts - part 2
      • Chart Options 2013 With Solution (DOWNLOAD)
      • Chart Options 2013 Without Solution (DOWNLOAD)
      • 05 Arrangement of Tab Options
      • Column and Line Chart
      • Pie Diagram
      • Area Chart
      • Doughnut, Bubble and Radar Chart
      • Specific Chart Types 2013 With Solution (DOWNLOAD)
      • Specific Chart Types 2013 Without Solution (DOWNLOAD)
      • Paste Chart Data
      • Multiple Source Data and Table Chart
      • Basic Dynamic Chart
      • Chart Sources 2013 With Solution (DOWNLOAD)
      • Chart Sources 2013 Without Solution (DOWNLOAD)
      • Dynamic Chart with Check boxes
      • Dynamic Pie Chart
      • Pareto Chart
      • Frequency Chart
      • Chart Filter
      • Gantt Chart
      • Advanced Dynamic Chart
      • Calculator Chart
      • Pivot Chart
      • Map Chart
      • Specialized Charts & Graphs 2013 With Solution (DOWNLOAD)
      • Specialized Charts & Graphs 2013 Without Solution (DOWNLOAD)
    • Excel 2013 - Excel Dashboard
      • Introduction to Dashboard
      • Concepts of Excel Dashboard
      • Vlookup
      • Hlookup and Sum product
      • Hlookup and Sum product Continues
      • Choose Function
      • Lookups Without Solution (DOWNLOAD)
      • Lookups With Solution (DOWNLOAD)
      • 3D Charts
      • Area and Bar Chart
      • Combination Charts
      • Different Typs
      • Types of Charts Without Solution (DOWNLOAD)
      • Types of Charts With Solution (DOWNLOAD)
      • Pivot Table
      • Pivot Chart and Slicer
      • Pivot Charts and Slicer New Without Solution (DOWNLOAD)
      • Pivot Charts and Slicer New With Solution (DOWNLOAD)
      • Checkbox
      • Check and Scroll 1
      • Scroll Chart
      • Check and Scroll Without Solution (DOWNLOAD)
      • Check and Scroll With Solution (DOWNLOAD)
      • Basic Macro Part 1
      • Macro Example Without Solution (DOWNLOAD)
      • Macro Example With Solution (DOWNLOAD)
      • Basic Macro Part 2
      • Macro Navigation
      • Dashboard End
      • Macro chart Example and Navigation Without Solution (DOWNLOAD)
      • Macro Chart Example With solution (DOWNLOAD)
      • Macro Navigation With Solution (DOWNLOAD)
    • Excel 2013 - Pivot Table
      • Data Formatting
      • Creating Pivot Table
      • Recommended Data Table
      • Pivoting Pivot Table
      • External Data
      • 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 Filters
      • 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
      • Executingthe Macro
      • Using Macros In Pivot Tables Without Solution
      • Using Macros In Pivot Tables With Solution
      • Starting With Power Pivot
      • Why Use Power Pivot
      • Adding Table To Power Pivot
      • 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
      • Power Pivot Calculated Field Without Solution
      • Power Pivot Calculated Field With Solution
      • Power Pivot Calculated Column with solution
      • Introduction To Power View
      • Displaying Data Using Different Controls Part 1
      • Displaying Data Using Different Controls Part 2
      • Formatting Of Controls
      • Filters In Power View
      • Data Display Using Charts In Power View
      • Data Display Using Maps
      • Introduction of Power View Without Solution
      • Introduction of Power View With Solution
    • Learn Microsoft Access 2013
      • 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
      • 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 2013
      • Introduction 2013
      • Basic Microsoft Word 2013
      • Introduction to Word 2013 and Understanding the Ribbons
      • Backstage View and Quick Access Toolbar 2013
      • Compatibility Mode and Navigation Pane 2013
      • Working with text 2013
      • Selection of Text 2013
      • Find and Replace Text 2013
      • Understanding Fonts 2013
      • Working with Fonts and Applying Basic Formatting 2013
      • Text Effects 2013
      • How to Save a Document 2013
      • Other File Formats 2013
      • Arranging Paper Margins, Paper Orientation and Paper Size 2013
      • Inserting Columns and Page Break up 2013
      • Using Watermarks, Page Colour and Page Borders 2013
      • Checking Spelling and Grammar 2013
      • Using Thesaurus, Word Count and Language Translate 2013
      • Printing a Document 2013
      • Setting Print Options 2013
      • Alignment Justifying and Line Spacing 2013
      • Use of Indents, Tabs and bulleted or Numbering list 2013
      • Demonstrating a Document with Pictures 2013
      • Positioning, Wraping And Re-sizing a Picture 2013
      • Use of Table, Smart art, Charts, Screen Shots 2013
      • Special Effects 2013
      • Customizing a Word and its Ribbons 2013
    • Microsoft word 2013 - Advanced
      • Advance Microsoft Word 2013 Introduction
      • Understanding Themes 2013
      • Change style sets colors, fonts & paragraph spacing 2013
      • Creating quick styles & table of contents 2013
      • Restrict Formatting & Create Multi-level list 2013
      • Understanding of Tables 2013
      • Converting text into table, formatting and adding columns & rows in a table 2013
      • Creating a form 2013
      • Use of excel spreadsheet, sorting of data & converting table into text 2013
      • Understanding of Cover Page 2013
      • Numbering pages, headers, footers & text box 2013
      • Customising Headers & Footers 2013
      • Document Sharing 2013
      • Tracking Changes 2013
      • Accepting & Rejecting Changes 2013
      • Comparing & Combining Changes 2013
      • Mail Merge 2013
      • Protecting your document 2013
    • Microsoft One Note 2013
      • One Note Introduction
      • What is One Note?
      • Launching One Note
      • Understanding the Interface
      • Sharing Notebook
      • Sharing Notebook- Properties
      • Creating a New Notebook
      • Adding New Sections
      • Working with Pages and Sub-pages
      • Creating a Note
      • Sending Content to One Note
      • Copy Data from PDF
      • Screen Clipping
      • Adding Images
      • Adding Media Files
      • Inserting Excel Sheets
      • Adding Equations & Symbols
      • Formatting Text
      • Using Styles
      • Bullets & Numbering
      • Spell Check & Auto Correct Options
      • Customizing the Interface
      • Search Option
      • Uses of Tags
      • Adding new Templates
      • Creating a New Template
      • Making a default template for a Section
      • Page setup
      • Adding Graphics to Background
      • Inserting a Table
      • Inserting Rows & Columns
      • Formatting the Table
      • Converting Table to Excel Spreadsheet
      • Using OneNote Draw Option
      • Converting Handwriting to Text
      • Changing Handwriting and Shapes
      • Ink to Math option
      • Interacting with Outlook
      • Sending Page Information by email
      • Outlook Tasks
      • Saving to other Formats
      • Saving Notebook to PDF Format
      • Saving Notebook on SkyDrive
      • Inviting others
      • Creating a shared link
      • Syncing the Notebook
      • Author Indicators
      • Identifying Recent changes
      • Page Versions
      • Quick access toolbar & Ribbon changes
      • Email Option changes
      • Setting up Password
      • Backup Options for Notebook


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