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