Microsoft Subject Focused Training Courses

  • Excel Basic Formulas & Functions
  • Excel Advanced Formulas & Functions
  • Excel Charts – From Basic to Amazing
  • Excel Pivot Tables & Pivot Charts
  • Excel Macros
  • Word – New Features & Shortcuts
  • Outlook – Time Saving Tips
  • PowerPoint – Charts & Graphs
  • PowerPoint – Mastering the Master Slide
  • What’s New in MS Office 2013 – 2016 – Office 365

Excel Basic Formulas & Functions

Recommended for ALL Excel users
Master the mysteries of Excel formulas with Software Savvy’s highly focused, hands-on training class

  • Formula Rules
  • Simple Formulas
  • AutoSum
  • AutoFill
  • Functions: MAX, MIN and AVERAGE
  • Absolute Reference
  • Auto Calculate
  • Display Formulas
  • COUNT Functions
  • Order of Operations/Mathematics
  • Multiple Operator Formulas
  • VLOOKUP and HLOOKUP Functions
  • Named Ranges
  • Basic IF Functions
  • Duplicate Removal
  • 3D Linking – Total numbers on a Summary Page

Excel Advanced Formulas & Functions

Recommended for more advanced Excel users
Take your Excel formula skills to new levels with Software Savvy’s highly focused, hands-on training class

  • Order of Operations/Mathematics
  • Absolute Reference
  • Multiple Operator Formulas
  • Date Functions and Use Dates in Calculations
  • IF Functions (Single and multiple criteria)
  • Nested IF Functions
  • CountIF, SumIF, AverageIF Functions
  • CountIFS and SumIFS Functions
  • IFError
  • Round Function
  • Goal Seek
  • Text and Formula in the Same Cell
  • FlashFill
  • Text Functions (LEN, TRIM)
  • 3D Linking – Total numbers on Summary Sheet
  • External Links (Links to other workbooks)
  • Maintain Links

Excel Charts:
From Basic to Amazing

  • Create advanced and interactive charts
  • Explore techniques for creating high impact charts
  • Learn how to represent data graphically
  • Modify different areas of charts
  • Rotate and elevate 3-D charts
  • Add or delete a series of data to charts
  • Default chart with keystroke combo
  • Combination chart
  • Interactive Thermometer chart
  • Hide zeros in chart Data Labels
  • Save a chart as a JPEG
  • Use SmartArt drawing tools to add impact and customization

Excel Pivot Tables & Pivot Charts

  • Create interactive Pivot Tables and Pivot Charts
  • Analyze large collections of data using Pivot Tables
  • Through hands-on exercises organize, customize and summarize data
  • Rearrange fields
  • Sort and filter data
  • Add multiple fields in an area and rearrange data
  • Format Pivot Tables using Styles
  • Slicers – new visual filters
  • Change dollar values to Counts or Averages
  • Group dates
  • Get details of summarized numbers
  • Add additional value fields
  • Add Custom calculations
  • Add a Formula field
  • Extract meaningful data and then present that in a Pivot Chart to add visual perspective to your data
  • Filter chart
  • Modify chart axis
  • Format charts with Styles and Colors

Excel Macros

Recommended for more advanced Excel users
Automate repetitive functions. Learn many new ways to use Macros

  • Where macros are stored
  • Macro enabled workbook
  • Run macros
  • Store macro on a button
  • Add macros to the Quick Access Toolbar
  • View VBA code
  • Use Relative Reference when creating macros
  • Create many macros to perform different functions:
    • Modify column headers
    • Highlight an entire spreadsheet and perform different formatting options
    • Delete columns and remove hidden rows and columns
    • Add new columns and formatting
    • Add repetitive text at the beginning of new spreadsheets
    • Copy and paste data from one workbook to another, format column widths and add headings
    • Add a formula
    • Macros using the Relative Reference option
    • Remove blank rows from an entire spreadsheet
    • Zero fill groups of numbers
Orlando Microsoft Office Training:
We are subject experts in Excel, PowerPoint, Outlook, Word, Access, OneNote, Project, Adobe Acrobat and Photoshop.
Software Savvy Orlando computer training is customized to meet computer users’ specific needs. We have helped countless numbers of people become more efficient, more productive and more profitable.

Call 407-880-8447

Word 2013 – New Features and Shortcuts

We all use this program, but how efficiently? This 3 hour class will demonstrate how to take advantage of all the new features plus show you may time saving shortcuts and helpful hints that will make you so much more productive.

  • Quick Access Toolbar (store shortcuts to commonly used functions)
  • Different views in Word: Full Screen, Read Mode, Bookmark View, Side by side
  • Synchronous Scrolling
  • Recent list (quickly reopen recently used documents)
  • Word Counts
  • Shortcuts for Navigation, Highlighting and Spacing
  • Paragraph Indents
  • Drag and Drop Text
  • Bullets/Numbered Lists
  • Watermarks
  • Headers and Footers
  • Section Breaks
  • Columns
  • Format Painter
  • Quick Parts and Building Blocks
  • AutoCorrect
  • Screenshots/Screen Clipping

Outlook – Time Saving Tips

How efficient are you with Outlook? Is your inbox too full? Need organization? This course is a how-to guide on efficiently managing your time with Outlook. Your investment in these 3 hours will result in saved time and better time utilization.

  • Keyboard Shortcuts
  • Quick Delete for email
  • Peeks
  • To Do Bar
  • Email Reminders
  • Flagging email
  • Color coding email
  • Filter Inbox to show only priority email
  • New Search features
  • Autocorrect – quickly bring in common information
  • Read Receipts
  • Schedule Delivery
  • Voting Buttons
  • Attachment Reminder
  • Simplified Rules
  • Turn off Email Alerts
  • Notification of important email
  • Quick Steps – single click links to perform tasks that normally require multiple steps
  • Distribution Lists
  • Tasks – Your To Do List
  • Date Navigator
  • Add another Time Zone
  • Send portion of your Calendar via email without showing the detail
Orlando Microsoft Office Training:
We are subject experts in Excel, PowerPoint, Outlook, Word, Access, OneNote, Project, Adobe Acrobat and Photoshop.
Software Savvy Orlando computer training is customized to meet computer users’ specific needs. We have helped countless numbers of people become more efficient, more productive and more profitable.

Call 407-880-8447

PowerPoint Charts and Graphs

  • Create and change charts and sub-types
  • Add and remove graphical elements
  • Format chart objects
  • Add animation to a chart
  • Create Organizational charts
  • Link an Excel spreadsheet or chart to a PowerPoint presentation and update data in either program

PowerPoint: Mastering the Master Slide

  • Making changes in PowerPoint is easy if you can master the Master Slide
  • Slide Master is a special view in PowerPoint that allows you to make formatting changes to text, bullets or backgrounds that affect your entire presentation
  • Create custom slide layouts
  • Overwrite Slide Master in specific instances
  • Convert slides that have been overwritten to the current Theme
  • Learn how to customize your presentation and then standardize any changes in your own personal design template
Orlando Microsoft Office Training:
We are subject experts in Excel, PowerPoint, Outlook, Word, Access, OneNote, Project, Adobe Acrobat and Photoshop.
Software Savvy Orlando computer training is customized to meet computer users’ specific needs. We have helped countless numbers of people become more efficient, more productive and more profitable.

Call 407-880-8447

What’s New in MS Office 2013 – 2016 – Office 365

  • Clean, new look which uses white backgrounds
  • Word, Excel, and PowerPoint no longer show a blank page at launch. Instead, a landing screen presents templates and other options for creating or reopening a document
  • Cloud collaboration
  • Share tab – Invite others to view or edit your document
  • Tell Me Assistant – Perform functions for you
  • More tablet and touchscreen friendly
  • Word automatically bookmarks the page you were last on when you closed a document, and lets you return to that page when you reopen it
  • Excel has FlashFill. Notices patterns in user’s data entry and then auto completes the remaining data
  • Excel offers recommended Chart styles based on the type of data specified
  • PowerPoint Themes now come with variations, which make it simpler to hone in on the look you want
  • Outlook Social Connector feature automatically provides updates from the users social networks
  • Outlook Weather Bar shows current weather forecast