Menu
Insights Training
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools

Basic MS Office Training

LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL INQUIRE@INSIGHTSMANILA.COM

Part 1.  Basic MS Excel Functions
  • Text Functions
    • Combining Texts
    • Changing Case
    • Other Accessory Text Functions
  • Logical Functions: Basic IF Statement
  • Math Functions
    • Basic Math Functions
    • Named Ranges
    • Conditional Math Functions
  • Lookup Functions
  • VLOOKUP

 Part 2.  Worksheet Preparation Tools
  • Sorting and Filtering
  • Adding Borders
  • Merge Cells and Cell Alignment
  • Insert, Delete, and Add Worksheets
  • Text-to-Columns
  • Basic Conditional Formatting
  • Basic Dropdown Menus and Cell Validations

Part 3. PivotTables and PivotCharts
  • Basic PivotTable Features
  • Refresh and Change Data Source
  • Using Slicers
  • Creating PivotCharts

Part 4.  Essential MS Word Tools
  • Advanced Document Formats
  • Creating New Styles
  • Inserting Headers and Footers
  • Alternating Footers
  • First Page Footer
  • Table of Contents

Part 5.  Basic PowerPoint Techniques
  • Adding and Modifying MS PowerPoint Objects
  • Modifying Texts
  • Formatting Texts: Font, Color, Size
  • Adding Textboxes
  • Automatic Text Reformatting
  • Troubleshooting Font Issues
  • Enhancing Images
  • Inserting Images
  • Cropping Images
  • Changing Image Colors
  • Using the Selection Pane
  • Inserting Audio and Video
  • Slide Formatting using the Slide Master View
  • Adding Animation

Part 6.  Adding Diagrams and Charts in MS Office
  • Creating Diagrams using SmartArt
  • Creating Charts in Excel, PowerPoint, and Word






​​

Related Courses

Advanced MS Excel

Macros and VBA Programming
Find Public Class
Send Email

Home

Courses

Public Classes

Contact

Copyright © 2022