Microsoft Specialty Training Courses

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

Mastering Excel
Formulas

Master the mysteries of Excel formulas with Software Savvy’s highly focused, hands-on training class
From creating basic formulas to working with IF Statements and VLookup functions … and everything in between!

  • Absolute versus Relative Referencing
  • Average, Maximum, Minimum and Count functions
  • New Feature: FlashFill (replaces many functions)
  • Use dates in formulas
  • Basic IF statements and Nested IF statements
  • SumIF, CountIF and AverageIF
  • SumIFS, CountIFS and AverageIFS (multiple criteria)
  • VLookups and HLookups

Excel Charts:
From Basic to Amazing

  • Create advanced and interactive charts
  • Explore techniques for creating high impact charts
  • Learn how to represent data graphically
  • Add or delete series of data to charts
  • Combination charts and self-expanding charts
  • 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
  • Extract meaningful data and then present that in a Pivot Chart to add visual perspective to your data

Word 2013 – New Features, Tips 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 – Save Time with Outlook

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