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
• 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
• Multiple cash flows
• Multiple cash flows- FV Calculation
• Asset valuation using DCF analysis
• 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
• Understanding the PMT functions
• Calculating loan payment with grace period
• Understanding PPMT and IPMT
• 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
• 02 Basic Learning of Excel Charts
• 03 Alteration of Excel Charts
• 04 Modifying Options of Charts - part 1
• 04 Modifying Options of Charts - part 2
• 05 Arrangement of Tab Options
• Column and Line Chart
• Pie Diagram
• Area Chart
• Doughnut, Bubble and Radar Chart
• Paste Chart Data
• Multiple Source Data and Table Chart
• Basic Dynamic Chart
• Dynamic Chart with Check boxes
• Dynamic Pie Chart
• Pareto Chart
• Frequency Chart
• Chart Filter
• Gantt Chart
• Calculator Chart
• Pivot Chart
• Map Chart
• Excel 2013 - Excel Dashboard
• Introduction to Dashboard
• Concepts of Excel Dashboard
• Vlookup
• Hlookup and Sum product
• Hlookup and Sum product Continues
• Choose Function
• 3D Charts
• Area and Bar Chart
• Combination Charts
• Different Typs
• Pivot Table
• Pivot Chart and Slicer
• Checkbox
• Check and Scroll 1
• Scroll Chart
• Basic Macro Part 1
• Basic Macro Part 2
• Dashboard End
• 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
• 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 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
• 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
• Backstage of Access
• Exploring the ribbons
• 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
• 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
• 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
• 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
• 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
• Working with Pages and Sub-pages
• Creating a Note
• Sending Content to One Note
• Copy Data from PDF
• Screen Clipping
• Inserting Excel Sheets
• Formatting Text
• Using Styles
• Bullets & Numbering
• Spell Check & Auto Correct Options
• Customizing the Interface
• Search Option
• Uses of Tags
• Creating a New Template
• Making a default template for a Section
• Page setup
• 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
• Saving to other Formats
• Saving Notebook to PDF Format
• Saving Notebook on SkyDrive
• Inviting others
• Syncing the Notebook
• Author Indicators
• Identifying Recent changes
• Page Versions
• Email Option changes
• Backup Options for Notebook

Course Fee:
USD 400

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: