Microsoft Office Course

IIFA ACADEMY > Short term Courses > Microsoft Office Course

(MS office 2013) MS Word with Advance Excel Training

Topic 1 - Get Started with Microsoft Word

  • How to Open Microsoft Word
  • Finding Your Way Around
  • Typing Your First Letter
  • How to Save Your Work
  • Highlighting Techniques
  • Opening Word Documents
  • Add an Address to a Letter
  • Spelling and Grammar Checking

Topic 3 - Copy and Paste

  • Techniques for Cutting Text
  • Cut and Paste Techniques
  • Copy and Paste Techniques

Topic 5 - Multi-Page Documents

  • Downloading a Text File
  • Setting up Page Margins and Tab Stops
  • How to Insert a Text File
  • Setting up Headers and Footers
  • Print Preview & Print

Topic 7 - Word Shapes

  • Word Shapes – Create a Logo
  • Logo Continued
  • Word Art
  • Completing the Logo

Topic 9 - Mail Merge

  • Create a Mail Merge Data Source
  • Create a Mail Merge Letter

Topic 11 - Document Collaboration

  • Document Collaboration
  • Accepting and Rejecting Changes

Topic 2 - Document Formatting

  • Crime Statistics Document
  • Bold Text
  • Italics and Underline
  • Setting Tab Stop Positions
  • Creating Bulleted Lists
  • Working with Fonts
  • Setting up Page Margins

Topic 4 - Clip Art

  • Inserting Clip art
  • How to Resize and Move Clip Art

Topic 6 - How to Create a Booklet

  • Downloading the Stories
  • Creating Your Own Word Style
  • Page Breaks and Section Breaks
  • Adding a Cover Page
  • Adding a Contents Page
  • Working with Section Breaks
  • Headers and Section Breaks

Topic 8 - Letterheads and Templates

  • Create a Letterhead
  • Adding Columns to a Page
  • Saving Word Documents as a Template

Topic 10 - Microsoft Word Tables

  • Tables in Microsoft Word
  • Table Styles

Topic 12 - Word Options

  • Displaying the Word Options
  • Changing the Language Settings
  • Proofing Options
  • Advanced Options
  • The Quick Access Toolbar
  • Keyboard Shortcuts

(MS office) MS Excel 2013 with Advance Excel Training

Topic 1 - Make a Start with Excel

  • A first look at Excel 2013
  • Excel Rows and Columns
  • Enter text and numbers in a Cell
  • How to edit text in a Cell
  • How to Centre text and numbers
  • Font Formatting in Excel 2013
  • How to change the color of a Cell
  • How to save your work in Excel
  • Currency Symbols in Excel 2013
  • How to Merge & Center
  • Review Number One
  • Use Auto Correct Option
  • Use Format painter
  • Use All Shortcut & Trikes

Topic 3 - Excel 2013 Charts

  • How to Sort Data in Excel
  • Create an Excel Chart
  • Move and Resize your Chart
  • Chart Styles and Layouts
  • Chart Titles and Series Titles
  • Chart Layout Panel in Excel 2013
  • The Format Chart Panel
  • Create a Pie Chart in Excel
  • Add Labels to a Pie Chart
  • Format Pie Chart Segments
  • Create a 2D Line Chart in Excel
  • Format your Axis Titles
  • Predict the future with a Trend line Chart
  • Sparkline Charts

Topic 5 - Functions in Excel 2013

  • The Average Function
  • The Date Function
  • Time Functions in Excel
  • A Time Table Project
  • Financial Functions
  • The Student Averages Project
  • Use Maximum & Minimum Formula
  • Use Product Formula
  • Use Mod for Reminder
  • Mathematics Formula

Topic 7 - Processing Data in Excel

  • Data Tables in Excel 2013
  • A Second Data Table
  • Excel Scenarios
  • Goal Seek
  • Absolute Cell References
  • Named Ranges in Excel 2013
  • Create a Custom Name in Excel
  • Excel Pivot Tables
  • Pivot Tables, Part Two
  • Reference other Worksheets
  • The LOOKUP Function
  • The VLOOKUP Function in Excel
  • Create a Business Invoice, Part One
  • Excel Business Invoice, Part Two
  • Business Invoice, Part Three

Topic 9 – MIS Report in Excel 2013

  • Use Concatenate Condition Option
  • Merge First name last name
  • first name with Left & Find Condition
  • LEN and FIND Condition
  • How to change (UPPER, LOWER, PROPER)
  • Insert Date & Time Formula & Shortcut
  • Change Roman Counting
  • Learn Formula (MATCH, CHOOSE, WEEKDAY FUNCTION, TEXT, NETWORK DAYS, WORKDAY,TRIM, VALUE, LEN)

Topic 2 - A more complex spreadsheet

  • Page Layout
  • How to use AutoFill in Excel 2013
  • Entering Simple Addition Formula
  • The SUM Function in Excel
  • The SUM Function Continued
  • Copy and Paste
  • How to use Paste Special
  • How to Multiply in Excel 2013
  • Finishing your spreadsheet for this section
  • How to Add a Comment to a Cell
  • Review Number Two

Topic 4 - Formulas in Excel 2013

  • The SUM Function
  • How to Multiply in Excel
  • Subtract and Divide
  • Combining the Arithmetic Operators
  • A Budget Spreadsheet
  • Balance Sheet, Salary Sheet
  • Employee Sheet
  • Bookmark & Create Hyperlink
  • Set Print area

Topic6- Conditional Logic in Excel

  • The IF Function
  • Conditional Formatting in Excel 2013
  • COUNTIF, SUMIF, DMAX, DMIN,
  • DCOUNTA, DSUM Use for Stock Table.

Topic 8 - Advanced Excel 2013

  • How to Create an Excel Template
  • Data Forms in Excel 2013
  • Drop Down Lists in Excel
  • Add your own Error Messages
  • Excel and Web Integration
  • Hyperlinks in Excel
  • Object Linking and Embedding
  • Insert Drawing Objects
  • Bookmarks & Hyperlink
  • Use DATA Validation Tools
  • USE Goal Seek & Data Table
  • Use Short option For Series
  • What if Analysis option
  • Consolidate Function
  • How to Protect Excel Sheet
  • How to Protect Excel Data
  • How to Protect Excel Workbook
  • How to Enable Double Password
  • How to Use Pivot Table

MS POWERPOINT 2013

OUTLOOK