Welcome to Course Builder

Microsoft Excel

• - Basic Formulas in Excel
  
• - Basics of Using Excel
  
• - Calculating between Workbooks
  
• - Conditional Formatting
  
• - Create a PDF from your Excel spreadsheet
  
• - Creating Charts in Excel
  
• - Find and Replace
  
• - Format your Spreadsheets
  
• - Functions - IF
  
• - Functions - INDEX and MATCH
  
• - Functions - SUMIFS and COUNTIFS
  
• - Functions - VLOOKUP
  
• - Macros
  
• - Multiple Worksheets
  
• - PivotTables and PivotCharts
  
• - Printing a spreadsheet
  
• - Protecting a Worksheet and/or Workbook
  
• - Use basic functions (MAX/MIN/AVERAGE)
  
• - Using Absolute References ($) in Formulas
  
• - Using Named Ranges in Spreadsheets
  
• - Working with Lists of Data in Excel
  

Microsoft PowerPoint

• - Animations and Slide Transitions
  
• - Automatic Shows
  
• - Basics of Using PowerPoint
  
• - Charts from Excel
  
• - Creating Templates
  
• - Custom Shows
  
• - Inserting Slides from another Presentation
  
• - Printing Notes and Handouts
  
• - Using Hyperlinks
  
• - Using the Drawing Tools
  
• - Using the Slide Master
  

Microsoft Word

• - Basics of Using Word
  
• - Create a Chart/Graph
  
• - Create a Header/Footer in your document
  
• - Create a PDF from your Word document
  
• - Create A Table
  
• - Document Margins
  
• - Mail Merge
  
• - Paragraph Formatting - Indents
  
• - Paragraph Formatting - Indents, Spacing and Tabs
  
• - Paragraph Formatting - Spacing
  
• - Paragraph Formatting - Tabs
  
• - Photos in Word Documents
  
• - Record a Macro
  
• - Report - Bookmarks and Cross-References
  
• - Reports - Table of Contents
  
• - Reports in Word
  
• - Sections - Columns
  
• - Sections - Headers and Footers
  
• - Sections - Page Layout
  
• - Sections in Word documents
  
• - Tables - Drawing
  
• - Tables - Formulas
  
• - Tables - Sorting
  
• - Track Changes
  
• - Use an Excel spreadsheet in your Word document
  
• - Use Find and Replace
  

Duration: 1 hour(s) and 30 min(s)