Welcome to Mobile Learning Centers Welcome to Mobile Learning Centers
Home Training E-Learning About MLC Our Clients Contact MLC

Power Breaks/Mini Classes List

We can also customize a class for you to meet your specific company needs.
Training material is also available for purchase. Please contact us for details.

D = mini demo style; H = hands-on power break; D/H = Can be either format

ID#MS ProductFormatClass TitleDescription
01AccessHAutomate Your Access DatabaseParameter queries
Interactive user macros
Building a switchboard
02AccessD/HAnswers to Your Access QueriesChoose the appropriate database management technique
Sort and filter data using queries
Use wildcards and top values in queries
Apply logic programming to queries
03Access & ExcelDAccess vs. ExcelCompares the feature strengths of Excel and Access
Transfer data between the two applications
04ExcelD/HAnalyze Excel DataPivot Tables and Pivot Charts
Data Tables
Scenarios
Goal Seek Solver
05ExcelHExcel Formulas and FunctionsBasics of formulas
Absolute & relative references
Basic functions using the Function Palette (Sum, Avg,
Max, Min)
IF and VLOOKUP
06ExcelHValidate Your Excel DataConditional formatting
Data validation
Auditing techniques
Protecting worksheets
07ExcelHMultiple Sheets and Pivot Tables in ExcelCreating and working with worksheet tabs
Grouping & copying
AutoFilter, AutoFill, AutoSum, and AutoFormat
Pivot tables
08ExcelD/HExcel ChartingAutoSum, AutoFormat, AutoFill, and drag & drop
Format Painter
Charting with and without the Wizard
Chart options
Drawing objects on charts
09ExcelDExcel ExtrasConverting text to columns
Using conditional formatting and data validation
Working with AutoFormat
10ExcelDManipulate Lists with ExcelMathematical and analytical features
List management techniques
Sorting and filtering data
11ExcelDExcel FunctionsUsing Excel's most popular functions, including:
IF, VLOOKUP, PMT, and DFunctions.
12OutlookHOrganize Your OutlookFolders
Categories
Rules
13OutlookDOutlook ShortcutsHandy shortcuts to save you time and improve
proficiency
14OutlookDSchedule It with OutlookAppointments
Events
Meetings
Group Schedules
Time zones
15PowerPointD/HUse PowerPoint's Special EffectsDraw & manipulate objects
WordArt
Slide transitions
Animation
16PowerPointD/HPowerPoint Made EasyFocus on more advanced features
Tips and tricks
Shortcuts
17PowerPointDProduce Successful PresentationsProven formula to successfully deliver an effective presentation
18WordH Bullets and NumberingBulleted lists
Numbered lists
Outlined numbered lists
How to customize all lists
19WordH Generate Forms in WordTables
Using controls
Populating data
Protecting the form
20WordHMass Mailings Using WordForm letters
Labels and envelopes
Retrieving data from Outlook, Excel and Access
21WordHMaster Document Using WordAdvantages/disadvantages of Master Documents
Creating and editing Master Documents
Creating and editing Sub Documents
22WordD/HWord's Tabs and TablesConverting text to tables
Converting tables to text
Working with Word formulas
23WordD/HAutomate Your Word WorkAutomated features to save you time including:
AutoComplete
AutoCorrect
AutoFormat
AutoText
Smart Tags
24WordD/HMake Styles Work for You using WordWhat is a style?
Work with existing styles
Create, modify and apply new styles
Organize your styles
25WordHStreamline Long Word DocumentsStyles and templates
Bookmarks
Headers and footers
Index & Table of Contents
Section breaks
26WordDUsing Drawing Tools to put the Wow in Your WordOrganize, enhance and add excitement to your
documents
Add shapes and lines for more impact
27WordD/HDocument CollaborationCreate multiple versions of a document
Distribute a document for review
Track changes
Review changes
28WordD/HLayout Techniques Using WordInsert ClipArt, WordArt, and files
Paragraph spacing, section breaks and column
breaks
Format Painter and page borders
29WindowsHManage Your Files and FoldersFile management using Windows Explorer
Folder management using Windows Explorer
30Office XPDOffice XP OverviewOverview of new features (Smart Tags, Task Pane,
Office Clipboard)
Outlook updates
Word's new features
Excel's time-saving enhancements
PowerPoint's new look (with the 3 hour demo)
Access updates (with the 3 hour demo)
31Office XPD/HShare Information Among Office ApplicationsMerge Word document with Outlook Contacts folder
Import an Excel spreadsheet into an Access
database
Merge an Access table into a Word mailing label
document
Import and link an Excel chart into PowerPoint
Create PowerPoint handouts in Word
32Office XPD Office Software ShortcutsKeyboard shortcuts
Quick highlight techniques
Office Clipboard
Basic search
Media Clip Organizer
33Office XPH/DReducing File SizeImportance of file size
Checking size of graphics
Graphics - Resizing, Change Resolution, Change Type Reducing size of PowerPointPresentations
Using WinZip
34Internet ExplorerHSurf the Internet EffectivelySearch engines
Search techniques
35E-MailDUnderstanding E-Mail EtiquetteGuidance for users of e-mail systems
Understand the strengths, limitations and etiquette
of e-mail
vendor management
© 2016 Mobile Learning Centers. All rights reserved.
Woman-Owned Business Enterprise (WBE)
314-750-1777
info@mobilelearn.com