STUDENT TRAINING NEEDS ASSESSMENT 

TRANSFORM EXISTING DOCUMENTS AND FILES FROM ANY SOURCE INTO PORTABLE DOCUMENT FILES OR PDF’S ♦ CONVERT ELECTRONIC FILES, PAPER DOCUMENTS AND WEB PAGES INTO THIS UNIVERSALLY ACCEPTED DOCUMENT FILE FORMAT ♦ CREATE DOCUMENTS THAT CAN BE VIEWED EXACTLY AS YOU INTENDED BY THE BUSINESS WORLD’S ENORMOUSLY DIVERSE RANGE OF ELECTRONIC DEVICES AND SYSTEMS ♦ CREATE PDF’S FROM ANY DOCUMENT OR FILE USING A VARIETY OF TOOLS AND TECHNIQUES ♦ EDIT PDF CONTENT USING THE ACROBAT PROGRAM OR WITH MICROSOFT WORD ♦ COMBINE OR MERGE MULTIPLE PDF OR CREATE PROFESSIONAL PORTFOLIO PDF FILES TO HOUSE AND DISPLAY ANY FILE TYPE ♦ FORMAT PDF’S WITH HIGHLIGHTING, COLOR, AND STAMPS ♦ ADD SECURITY SETTING TO LIMIT INTERACTIONS ♦ UTILIZE PROFESSIONAL PRINT TOOLS AND OPTIONS ♦ CREATE AND DISTRIBUTE FILLABLE FORMS AND COLLECT AND MANAGE SUBMITTED DATA.

CONSTRUCT POWERFUL BUSINESS-STYLE DATABASES FROM SCRATCH OR FROM ALREADY-MADE PROFESSIONAL DATABASE TEMPLATES ♦ CREATE DATABASE TABLES OR DATASHEETS TO STORE DATA AND LEARN HOW TO ADD DATA MANUALLY AND THROUGH DATA IMPORTING ♦ ADMINISTER DATA MANAGEMENT TOOLS TO CHANGE, MODIFY, REPLACE, AND DELETE FIELDS AND RECORDS OF DATA ♦ EXPLORE VARIOUS WAYS TO VIEW DATA AND CHANGE HOW IT LOOKS WITH COLOR, BORDERING, SHADING, AND BANDING. GROUP AND ORGANIZE DATA USING SORTING TOOLS WHILE FILTERING BY APPLYING CRITERIA METHODS ♦ IMPORTANCE OF ESTABLISHING TABLE RELATIONSHIPS AND SETTING KEYED FIELDS WITHIN A RELATIONAL DATABASE ♦ DESIGN DATABASE FORMS TO USE AS AN ALTERNATIVE TO THE TABLE DATASHEET FOR VIEWING AND MANAGING DATA FIELDS AND RECORDS ♦ APPLY DATABASE MAINTENANCE AND REPAIRING TOOLS TO MAINTAIN DATA INTEGRITY AND SAFETY ♦ LEARN HOW TO EXPORT DATA INTO OTHER EXTERNAL FILE FORMATS INCLUDING EXCEL, CSV AND ASCII DELIMITED.

SUMMARIZE AND ANALYZE YOUR DATABASE DATA WITH QUERIES AND REPORTS ♦ LEARN HOW TO CREATE SINGLE AND MULTIPLE-TABLED QUERY DESIGNS ♦ CREATE SELECT QUERIES TO FOCUS ON AND TARGET SPECIFIC DATA BASED ON VARIOUS CRITERIA ♦ USE FORMULAS AND DATABASE FUNCTIONS TO CREATE NEW CALCULATED FIELDS ♦ USE THE QUERY WIZARD TO SUMMARIZE DATA AND AGGREGATE RECORDS WITH TOTALS ♦ CREATE CROSS-TABULATION QUERIES THAT ARE LIKE PIVOT TABLES ♦ CREATE QUERIES THAT FIX MISMATCHED DATA, APPENDING, CHANGING, UPDATING, AND REMOVING DUPLICATES ♦ GENERATE A VARIETY OF REPORTS BASED ON QUERIES.

CREATE AN ASSORTMENT OF BUSINESS-CLASS SPREADSHEET/WORKSHEETS FROM SCRATCH OR BASED OFF A LIBRARY OF TEMPLATES ♦ INSERT ESSENTIAL FORMULAS AND FUNCTION FORMULAS TO PERFORM CALCULATIONS ON WORKSHEET DATA ♦ MODIFY THE STRUCTURE AND DESIGN OF WORKSHEETS USING ROW, COLUMN AND WORKSHEET-WIDE TOOLS THAT MAKE THE PROCESS EASY ♦ FORMAT THE LOOK OF WORKSHEETS USING RIBBON-BASED AND KEYBOARD SHORTCUT FORMATTING TOOLS AND FEATURES ♦ EXPLORE WORKSHEET VIEWING AND GROUPING TOOLS THAT MAKE IT EASIER TO VIEW AND INTERACT WITH THE WORKSHEET ♦ SAVE THE SPREADSHEET FILE TO LOCAL AND NETWORK DRIVES, PORTABLE AND EXTERNAL DRIVES, AND TO THE CLOUD ♦ LEARN HOW TO SHARE SPREADSHEET FILES USING MICROSOFT’S ONEDRIVE CLOUD STORAGE PLATFORM AND OPTIONALLY COLLABORATE ON IT.

LEARN HOW WORKSHEET FORMATTING CAN MAKE YOUR WORKSHEET STAND OUT AND EMPHASIZE KEY AREAS FOR DISCUSSION AND ANALYSIS ♦ MANIPULATE THE STRUCTURE AND PROPERTIES OF WORKSHEETS, ROWS, AND COLUMNS ♦ LOCK CERTAIN ROWS AND/OR COLUMNS FROM SCROLLING ♦ SPLIT THE WORKSHEET SCREEN INTO INDEPENDENTLY SCROLLABLE SECTIONS ♦ ORGANIZE WORKSHEET BY SORTING, TRANSPOSING, GROUPING AND OUTLINING ♦ APPLY A WIDE RANGE OF FORMATTING INCLUDING FONT, COLOR, BORDERING, SHADING, AND ALIGNMENT ♦ APPLY STANDARD AND CUSTOMIZED NUMBER AND DATE FORMATTING ♦ COPY FORMATTING USING THE FORMAT PAINTER TOOL ♦ QUICKLY APPLY FORMATTING USING THE “QUICK FORMAT”, “REPEAT FORMATTING”, “STYLE FORMATTING” AND “THEME FORMATTING” TOOLS ♦ USE THE “CONDITIONAL FORMATTING” TOOL TO FORMAT TEXT, NUMBERS AND DATES BASED ON SET CRITERIA BEING MET ♦ ADD NOTES AND COMMENTS THROUGHOUT ♦ PROTECT THE WORKSHEET FROM EDITING ♦ LEARN HOW TO PREPARE YOUR WORKSHEET TO BE PRINTED INCLUDING WHAT TO PRINT, FITTING TO, HEADERS AND FOOTERS AND MORE.

LEARN HOW CONDITIONAL FORMATTING CAN BE USED TO AUTOMATICALLY APPLY FORMATTING LIKE FONT AND CELL COLOR, ICONS, AND DATA BARS, TO ONE OR MORE CELLS BASED ON THE CELL VALUE ♦ EXPLORE USING THIS POWERFUL TOOL TO VISUALLY ANALYZE DATA, IDENTIFY PATTERNS AND TRENDS AND DETECT CRITICAL ISSUES ♦ APPLY PRESET CONDITIONAL FORMAT RULES THAT TRIGGER FORMATTING TO BE APPLIED WHEN CELL VALUES (TEXT, NUMBERS, OR DATES) ARE GREATER THAN, LESS THAN, EQUAL TO OR ARE BETWEEN A VALUE SET BY A CRITERIA ♦ CREATE CUSTOMIZED CONDITIONAL FORMATTING RULES TO DETECT DUPLICATES, HIGHEST AND LOWEST VALUES, AND ABOVE OR BELOW OVERALL AVERAGES ♦ BUILD CONDITIONAL FORMATTING RULES USING FORMULAS AND FUNCTIONS THAT COMPARE VALUES AND OPTIONALLY FORMAT THE ENTIRE ROW AS OPPOSED TO SINGLE CELLS.

CREATE A POWERFUL VARIETY OF FORMULAS THAT WILL HELP YOU SEE DEEPER INTO YOUR WORKSHEET DATA ♦ CREATE COMBINATIONS OF ADDITION, SUBTRACTION, MULTIPLICATION, AND DIVISION SYNTAX CAN PRODUCE EYE-CATCHING FORMULAS ♦ LEARN THE ROLE PARENTHESIS PLAY IN ASSURING THE PROPER CALCULATION RESULTS IN FORMULAS ♦ EXPLORE TOOLS USED TO TROUBLESHOOT FORMULA ERRORS AND OVERSIGHTS ♦ UNDERSTAND HOW COMBINATIONS OR RELATIVE AND ABSOLUTE REFERENCING IN FORMULAS CAN SAVE TIME AND FRUSTRATION WHEN COPYING FORMULAS ♦ SEE HOW TO PERFORM CALCULATIONS WITHOUT THE USE OF FORMULAS (WHAH?) ♦ CREATE DOZENS OF FORMULAS FOR RUNNING TOTALS, CARRY-OVERS, PERCENTAGE CHANGE, VARIANCES, INDICES, BUDGET-REMAIN, COMMISSION/BONUS, DATE CALCULATIONS AND PROJECTIONS, AREA, AND VOLUME, TO NAME A FEW ♦ LINK CELL VALUES BETWEEN MULTIPLE WORKSHEETS AND CONSOLIDATE WORKSHEETS ♦ LINK WORKSHEETS FROM MULTIPLE WORKBOOKS (SPREADSHEET FILES) AND LEARN HOW TO MANAGE AND TROUBLESHOOT THESE CONNECTIONS ♦ LEARN HOW TO USE FORMULA AUDITING TOOLS TO EVALUATE FORMULAS, ERROR CHECKING AND TRACE FORMULA PRECEDENTS AND DEPENDENTS ♦ LEARN THE TOP FIVE WAYS TO COPY AND EDIT SIMPLE AND COMPLEX FORMULAS ♦ LEARN HOW TO REMOVE FORMULAS FROM WORKSHEETS WHILE LEAVING BEHIND THE CALCULATION’S MOST RECENT OUTCOME/VALUE.

SEE HOW FUNCTION FORMULAS (OR PREDEFINED FORMULAS) LET YOU PERFORM MATHEMATICAL, STATISTICAL, AND LOGICAL OPERATIONS THAT GO WELL BEYOND THE STANDARD REFERENTIAL FORMULAE AND ARE CRUCIAL TO SEEING DEEPER INTO YOUR NUMBERS AND DATA ♦ LEARN HOW FUNCTION FORMULAS WORK AND HOW BEST TO APPLY THEM IN A WIDE RANGE OF BUSINESS APPLICATIONS ♦ INSERT FUNCTION FORMULAS FROM CATEGORIES LIKE FINANCIAL, CHRONOLOGICAL, MATHEMATICAL, STATISTICAL, LOGICAL, DATABASE AND REFERENTIAL ♦ COMBINE (OR NEST) MULTIPLE FUNCTIONS TO CREATE DYNAMIC CALCULATIVE RESULTS ♦ LEARN THE IMPORTANT ROLES RELATIVE AND ABSOLUTE FORMULA REFERENCING PLAY IN THE CALCULATION AND OPERATIONAL PROCESSES ♦ ADDED BONUS: SPECIALLY CREATED ESSENTIAL FUNCTIONS (CALLED UDF’S) NOT NORMALLY INCLUDED WITH THE EXCEL PROGRAM.

EXPLORE THE MYRIAD OF POWERFUL STATISTICAL ANALYSIS TOOLS USED IN TODAY’S BUSINESS WORLD ♦ USE THE WHAT-IF FEATURES LIKE GOAL SEEK, SCENARIO MANAGER AND DATA TABLE, TO SEE HOW CHANGING VALUES CREATE A WIDE RANGE OF CALCULATION OUTCOMES ♦ PERFORM RANDOM SAMPLING OF DATA ALONG WITH CREATING RANDOM ASSIGNMENTS TO TASKS AND GROUP CREATION ♦ CALCULATE MOVING AVERAGES AND PREDICT TRENDS WITH VARIOUS FORECASTING TOOLS ♦ RANK DATA ON CERTAIN VALUES, MEASURE DATA FREQUENCY AND CALCULATE WEIGHTED AVERAGES ♦ MEASURE VARIANCE TO HELP MAKE THE BEST DECISIONS AND CHOICES ♦ DETERMINE CORRELATIVE STRENGTH BETWEEN DATA SETS ♦ USE REGRESSION TO ESTIMATE RELATIONSHIPS THAT HELP MAKE BETTER PREDICTIONS ♦ INSERT FUNCTION FORMULAS THAT PERFORM STATISTICAL CALCULATIONS AND FILL IN MISSING DATA ♦ USE THE SOLVER TOOL TO FIND THE BEST MIX OF SUGGESTED CELL VALUES THAT RESULT IN AN OPTIMIZED AND DESIRED RESULTS.

EFFECTIVELY ANALYZE AND MANAGE DATA INFORMATION STORED IN AN EXCEL WORKSHEET ♦ LEARN THE DATABASE TOOLS, FEATURES AND SPECIALIZED FUNCTION FORMULAS USED TO LEARN THE MOST ABOUT AND FROM YOUR DATA ♦ CREATE A WORKSHEET DATABASE AND LEARN TO FILL IT MANUALLY BY TYPING IN DATA OR BY IMPORTING THE DATA FROM AN OUTSIDE SOURCE ♦ RESTRUCTURE THE DATABASE DESIGN TO MEET GROWING DEMANDS ♦ NORMALIZE OR FIX YOUR DATA USING FUNCTION FORMULAS AND OTHER TOOLS AND SAVING TIME ♦ ORGANIZE DATA USING A VARIETY OF SORTING TOOLS AND TECHNIQUES ♦ SUMMARIZE SORTED DATA GROUPING WITH THE SUBTOTAL TOOL ♦ APPLY FILTERING TOOLS TO FOCUS ON SPECIFIC DATA USING CUSTOMIZED CRITERIA ♦ GENERATE UNIQUE LISTINGS FROM SINGLE AND MULTIPLE FIELDS ♦ IMPLEMENT DATA ANALYSIS USING DATABASE FUNCTIONS AND LOGICAL FUNCTION SUMMARIES ♦ CONVERT WORKSHEET DATABASE LISTS INTO DATA TABLES TO QUICKLY FORMAT, CALCULATE AND SORT/FILTER DATA RECORDS ♦ INSERT VISUAL FILTER SLICERS FOR THE ULTIMATE IN FILTERING AND DASHBOARD EXPERIENCE ♦ LEARN HOW TO USE A DATABASE LIST TO MAIL MERGE ENVELOPES, LABELS, AND FORM LETTERS ♦ PERFORM AN E-MAIL MAIL MERGE USING SIMILAR DATA TO CREATE PERSONALIZED MASS-E-MAILS.

EXPLORE HOW TO USE PIVOT TABLES TO HELP MAKE THE MOST OUT OF YOUR DATA BY APPLYING ITS POWERFUL SUMMATION, CHARTING, AND REPORTING TOOLS ♦ IDENTIFY WHAT CONSTITUTES FOR SUITABLE DATA TO BASE YOUR PIVOT TABLES ON ♦ LEARN WHY CONVERTING YOUR DATA TO TABLE FORMAT IS BENEFICIAL TO SUCCESSFUL REPORTING ♦ LEARN HOW TO ADD NEW AND MISSING DATA EITHER BY ADDING FIELDS TO THE WORKSHEET OR DIRECTLY TO THE PIVOT TABLE REALM USING CALCULATED FIELDS AND ITEMS ♦ UNDERSTAND THE UTILITY TOOLS USED IN CREATING PIVOT TABLES AND PIVOT CHARTS ♦ CREATE PIVOT TABLES FROM SCRATCH OR THROUGH THE USE OF PREFERRED TEMPLATES ♦ LEARN HOW TO GROUP AND BUNDLE YOUR PIVOT TABLE DATA INCLUDING DATES, VALUES, AND TEXT ♦ APPLY A VARIETY OF SORTING TECHNIQUES AND FILTERING TOOLS INCLUDING ADVANCED SLICER AND TIMELINE FILTERS ♦ INSERT POWERFUL SUMMARY CALCULATIONS AND CUSTOM ROW/COLUMN CALCULATIONS AND CUSTOM COMPARATIVE CALCULATIONS ♦ FORMAT PIVOT TABLES AND PIVOT CHARTS USING TRADITIONAL TOOLS AS WELL AS ADVANCED CONDITIONAL FORMATTING RULES ♦ CREATE A VARIETY OF PIVOT CHARTS INCLUDING COLUMN, BAR, LINE, AREA, PIE AND MORE ♦ LEARN HOW TO PERFECTLY PRINT PIVOT TABLES AND PIVOT CHARTS, WITH OPTIONS.

LEARN HOW GRAPHICS ARE USED TO MAKE INFORMATION EASIER TO VISUALIZE ♦ SEE HOW UNDERLYING PATTERNS FOUND IN ALL GRAPHICS CAN BE USED TO MORE IMPACTFULLY COMMUNICATE WHAT YOUR RAW DATA CONVEYS ♦ LEARN TO CREATE EYE-CATCHING GRAPHICS THAT SHOW TRENDS AND CYCLES, EASILY AND QUICKLY ♦ CREATE CHARTS FROM COLUMN, BAR, LINE, AREA, SCATTER, SURFACE AND RADAR TO DONUT, WATERFALL, BOX & WHISKER, SUNBURST, TREEMAP AND HISTOGRAM ♦ CREATE SINGLE-CELLED SPARKLINE GRAPHS IN LINE, BAR, AND WIN-LOSS FORMATS ♦ CREATE COMBO CHARTS THAT INCLUDE MULTIPLE TYPES ♦ ANALYZE FURTHER WITH VARIETIES OF TRENDLINES AND FORECASTING ♦ USE DRAWING TOOLS TO ADD A VARIETY OF SHAPES ♦ ADD TEXT TO A SHAPE AND USE THE DRAWING CANVAS TO CONTROL DRAWING ELEMENTS ♦ CHANGE AN EXISTING SHAPE AND APPLY FORMATTING STYLES AND EFFECTS ♦ MAKE AND INSERT SCREEN SHOTS TO YOUR WORKSHEETS ♦ REARRANGE, RESIZE, ORGANIZE, AND FORMAT SHAPES ♦ INSERT A VARIETY OF SMARTART DIAGRAM OBJECTS INCLUDING LISTS, PROCESSES, CYCLES, HIERARCHY’S, MATRIXES, PYRAMIDS AND MORE ♦ ADJUST THE LAYOUT OF THE SHAPES USED IN THE SMARTART OBJECTS ♦ APPLY NEW LAYOUTS AND FORMATTING STYLES ♦ ADD ADDITIONAL OBJECT SHAPES USING THE PANE.

LEARN HOW MACROS CAN AUTOMATE WHAT YOU DO MOST IN A WORKSHEET AND WORKBOOK ♦ LEARN HOW TO CREATE MACROS TO AUTOMATE REPETITIVE TASKS USING THE MACRO RECORDER AND BY INSERTING VBA CODE ♦ LEARN HOW TO RECORD MACROS IN STAGES ♦ SHARE MACROS BETWEEN WORKBOOKS ♦ SET UP KEYBOARD SHORTCUTS, QUICK ACCESS TOOLBAR ICONS AND TAB RIBBON ICONS, TO RUN YOUR MACROS QUICKLY ♦ LEARN TO CREATE MACROS FROM SCRATCH BY INSERTING VBA THAT PROVIDES CUSTOM FUNCTIONALITY TO ENHANCE EXCEL’S PERFORMANCE AND EFFICIENCY ♦ ADD CODE TO MACROS AND CREATE, EXPORT, AND DELETE CODE MODULES ♦ CREATE MACROS THAT ADD ADDITIONAL TOOLS AND FEATURES NOT FOUND NORMALLY IN THE PROGRAM ♦ CREATE USER-DEFINED FUNCTIONS (UDF’S) THAT ADD ADDITIONAL FUNCTION FORMULAS TO THE PROGRAM ♦ USE VBA TO CALCULATE USING EXCEL’S BUILT-IN FUNCTIONS ♦ CREATE CUSTOM ADD-INS THAT PACKAGE GROUPS OF MACROS FOR USE ON OTHER COMPUTERS ♦ LEARN HOW TO EDIT/EXPAND YOUR MACROS TO MAKE THEM DO MORE AND WORK FASTER ♦ LEARN ABOUT MACRO SECURITY AND HOW TO PROTECT YOUR COMPUTER ♦ LEARN HOW TO JOIN AND COMBINE MACROS ALONG WITH STREAMLINING THEM.

CREATE AN ASSORTMENT OF BUSINESS-CLASS SPREADSHEET/WORKSHEETS FROM SCRATCH OR BASED OFF A LIBRARY OF TEMPLATES ♦ INSERT ESSENTIAL FORMULAS AND FUNCTION FORMULAS TO PERFORM CALCULATIONS ON WORKSHEET DATA ♦ MODIFY THE STRUCTURE AND DESIGN OF WORKSHEETS USING ROW, COLUMN AND WORKSHEET-WIDE TOOLS THAT MAKE THE PROCESS EASY ♦ FORMAT THE LOOK OF WORKSHEETS USING RIBBON-BASED AND KEYBOARD SHORTCUT FORMATTING TOOLS AND FEATURES ♦ EXPLORE WORKSHEET VIEWING AND GROUPING TOOLS THAT MAKE IT EASIER TO VIEW AND INTERACT WITH THE WORKSHEET ♦ SAVE THE SPREADSHEET FILE TO LOCAL AND NETWORK DRIVES, PORTABLE AND EXTERNAL DRIVES, AND TO THE CLOUD ♦ LEARN HOW TO SHARE SPREADSHEET FILES USING GOOGLE DRIVE CLOUD STORAGE PLATFORM AND OPTIONALLY COLLABORATE ON IT.

LEARN HOW WORKSHEET FORMATTING CAN MAKE YOUR WORKSHEET STAND OUT AND EMPHASIZE KEY AREAS FOR DISCUSSION AND ANALYSIS ♦ MANIPULATE THE STRUCTURE AND PROPERTIES OF WORKSHEETS, ROWS, AND COLUMNS ♦ LOCK CERTAIN ROWS AND/OR COLUMNS FROM SCROLLING ♦ SPLIT THE WORKSHEET SCREEN INTO INDEPENDENTLY SCROLLABLE SECTIONS ♦ ORGANIZE WORKSHEET BY SORTING, TRANSPOSING, GROUPING AND OUTLINING ♦ APPLY A WIDE RANGE OF FORMATTING INCLUDING FONT, COLOR, BORDERING, SHADING, AND ALIGNMENT ♦ APPLY STANDARD AND CUSTOMIZED NUMBER AND DATE FORMATTING ♦ COPY FORMATTING USING THE FORMAT PAINTER TOOL ♦ QUICKLY APPLY FORMATTING USING THE “QUICK FORMAT”, “REPEAT FORMATTING”, “STYLE FORMATTING” AND “THEME FORMATTING” TOOLS ♦ USE THE “CONDITIONAL FORMATTING” TOOL TO FORMAT TEXT, NUMBERS AND DATES BASED ON SET CRITERIA BEING MET ♦ ADD NOTES AND COMMENTS THROUGHOUT ♦ PROTECT THE WORKSHEET FROM EDITING ♦ LEARN HOW TO PREPARE YOUR WORKSHEET TO BE PRINTED INCLUDING WHAT TO PRINT, FITTING TO, HEADERS AND FOOTERS AND MORE.

LEARN HOW CONDITIONAL FORMATTING CAN BE USED TO AUTOMATICALLY APPLY FORMATTING LIKE FONT AND CELL COLOR, ICONS, AND DATA BARS, TO ONE OR MORE CELLS BASED ON THE CELL VALUE ♦ EXPLORE USING THIS POWERFUL TOOL TO VISUALLY ANALYZE DATA, IDENTIFY PATTERNS AND TRENDS AND DETECT CRITICAL ISSUES ♦ APPLY PRESET CONDITIONAL FORMAT RULES THAT TRIGGER FORMATTING TO BE APPLIED WHEN CELL VALUES (TEXT, NUMBERS, OR DATES) ARE GREATER THAN, LESS THAN, EQUAL TO OR ARE BETWEEN A VALUE SET BY A CRITERIA ♦ CREATE CUSTOMIZED CONDITIONAL FORMATTING RULES TO DETECT DUPLICATES, HIGHEST AND LOWEST VALUES, AND ABOVE OR BELOW OVERALL AVERAGES ♦ BUILD CONDITIONAL FORMATTING RULES USING FORMULAS AND FUNCTIONS THAT COMPARE VALUES AND OPTIONALLY FORMAT THE ENTIRE ROW AS OPPOSED TO SINGLE CELLS.

CREATE A POWERFUL VARIETY OF FORMULAS THAT WILL HELP YOU SEE DEEPER INTO YOUR WORKSHEET DATA ♦ CREATE COMBINATIONS OF ADDITION, SUBTRACTION, MULTIPLICATION, AND DIVISION SYNTAX CAN PRODUCE EYE-CATCHING FORMULAS ♦ LEARN THE ROLE PARENTHESIS PLAY IN ASSURING THE PROPER CALCULATION RESULTS IN FORMULAS ♦ EXPLORE TOOLS USED TO TROUBLESHOOT FORMULA ERRORS AND OVERSIGHTS ♦ UNDERSTAND HOW COMBINATIONS OR RELATIVE AND ABSOLUTE REFERENCING IN FORMULAS CAN SAVE TIME AND FRUSTRATION WHEN COPYING FORMULAS ♦ SEE HOW TO PERFORM CALCULATIONS WITHOUT THE USE OF FORMULAS (WHAH?) ♦ CREATE DOZENS OF FORMULAS FOR RUNNING TOTALS, CARRY-OVERS, PERCENTAGE CHANGE, VARIANCES, INDICES, BUDGET-REMAIN, COMMISSION/BONUS, DATE CALCULATIONS AND PROJECTIONS, AREA, AND VOLUME, TO NAME A FEW ♦ LINK CELL VALUES BETWEEN MULTIPLE WORKSHEETS AND CONSOLIDATE WORKSHEETS ♦ LINK WORKSHEETS FROM MULTIPLE WORKBOOKS (SPREADSHEET FILES) AND LEARN HOW TO MANAGE AND TROUBLESHOOT THESE CONNECTIONS ♦ LEARN HOW TO USE FORMULA AUDITING TOOLS TO EVALUATE FORMULAS, ERROR CHECKING AND TRACE FORMULA PRECEDENTS AND DEPENDENTS ♦ LEARN THE TOP FIVE WAYS TO COPY AND EDIT SIMPLE AND COMPLEX FORMULAS ♦ LEARN HOW TO REMOVE FORMULAS FROM WORKSHEETS WHILE LEAVING BEHIND THE CALCULATION’S MOST RECENT OUTCOME/VALUE.

SEE HOW FUNCTION FORMULAS (OR PREDEFINED FORMULAS) LET YOU PERFORM MATHEMATICAL, STATISTICAL, AND LOGICAL OPERATIONS THAT GO WELL BEYOND THE STANDARD REFERENTIAL FORMULAE AND ARE CRUCIAL TO SEEING DEEPER INTO YOUR NUMBERS AND DATA ♦ LEARN HOW FUNCTION FORMULAS WORK AND HOW BEST TO APPLY THEM IN A WIDE RANGE OF BUSINESS APPLICATIONS ♦ INSERT FUNCTION FORMULAS FROM CATEGORIES LIKE FINANCIAL, CHRONOLOGICAL, MATHEMATICAL, STATISTICAL, LOGICAL, DATABASE AND REFERENTIAL ♦ COMBINE (OR NEST) MULTIPLE FUNCTIONS TO CREATE DYNAMIC CALCULATIVE RESULTS ♦ LEARN THE IMPORTANT ROLES RELATIVE AND ABSOLUTE FORMULA REFERENCING PLAY IN THE CALCULATION AND OPERATIONAL PROCESSES ♦ ADDED BONUS: SPECIALLY CREATED ESSENTIAL FUNCTIONS (CALLED UDF’S) NOT NORMALLY INCLUDED WITH THE EXCEL PROGRAM.

EFFECTIVELY ANALYZE AND MANAGE DATA INFORMATION STORED IN AN EXCEL WORKSHEET ♦ LEARN THE DATABASE TOOLS, FEATURES AND SPECIALIZED FUNCTION FORMULAS USED TO LEARN THE MOST ABOUT AND FROM YOUR DATA ♦ CREATE A WORKSHEET DATABASE AND LEARN TO FILL IT MANUALLY BY TYPING IN DATA OR BY IMPORTING THE DATA FROM AN OUTSIDE SOURCE ♦ RESTRUCTURE THE DATABASE DESIGN TO MEET GROWING DEMANDS ♦ NORMALIZE OR FIX YOUR DATA USING FUNCTION FORMULAS AND OTHER TOOLS AND SAVING TIME ♦ ORGANIZE DATA USING A VARIETY OF SORTING TOOLS AND TECHNIQUES ♦ SUMMARIZE SORTED DATA GROUPING WITH THE SUBTOTAL TOOL ♦ APPLY FILTERING TOOLS TO FOCUS ON SPECIFIC DATA USING CUSTOMIZED CRITERIA ♦ GENERATE UNIQUE LISTINGS FROM SINGLE AND MULTIPLE FIELDS ♦ IMPLEMENT DATA ANALYSIS USING DATABASE FUNCTIONS AND LOGICAL FUNCTION SUMMARIES ♦ CONVERT WORKSHEET DATABASE LISTS INTO DATA TABLES TO QUICKLY FORMAT, CALCULATE AND SORT/FILTER DATA RECORDS ♦ INSERT VISUAL FILTER SLICERS FOR THE ULTIMATE IN FILTERING AND DASHBOARD EXPERIENCE ♦ LEARN HOW TO USE A DATABASE LIST TO MAIL MERGE ENVELOPES, LABELS, AND FORM LETTERS ♦ PERFORM AN E-MAIL MAIL MERGE USING SIMILAR DATA TO CREATE PERSONALIZED MASS-E-MAILS.

EXPLORE HOW TO USE PIVOT TABLES TO HELP MAKE THE MOST OUT OF YOUR DATA BY APPLYING ITS POWERFUL SUMMARIZATION, CHARTING, AND REPORTING TOOLS ♦ IDENTIFY WHAT CONSTITUTES FOR SUITABLE DATA TO BASE YOUR PIVOT TABLES ON ♦ LEARN WHY CONVERTING YOUR DATA TO TABLE FORMAT IS BENEFICIAL TO SUCCESSFUL REPORTING ♦ LEARN HOW TO ADD NEW AND MISSING DATA EITHER BY ADDING FIELDS TO THE WORKSHEET OR DIRECTLY TO THE PIVOT TABLE REALM USING CALCULATED FIELDS AND ITEMS ♦ UNDERSTAND THE UTILITY TOOLS USED IN CREATING PIVOT TABLES AND PIVOT CHARTS ♦ CREATE PIVOT TABLES FROM SCRATCH OR THROUGH THE USE OF PREFERRED TEMPLATES ♦ LEARN HOW TO GROUP AND BUNDLE YOUR PIVOT TABLE DATA INCLUDING DATES, VALUES, AND TEXT ♦ APPLY A VARIETY OF SORTING TECHNIQUES AND FILTERING TOOLS INCLUDING ADVANCED SLICER AND TIMELINE FILTERS ♦ INSERT POWERFUL SUMMARY CALCULATIONS AND CUSTOM ROW/COLUMN CALCULATIONS AND CUSTOM COMPARATIVE CALCULATIONS ♦ FORMAT PIVOT TABLES AND PIVOT CHARTS USING TRADITIONAL TOOLS AS WELL AS ADVANCED CONDITIONAL FORMATTING RULES ♦ CREATE A VARIETY OF PIVOT CHARTS INCLUDING COLUMN, BAR, LINE, AREA, PIE AND MORE ♦ LEARN HOW TO PERFECTLY PRINT PIVOT TABLES AND PIVOT CHARTS, WITH OPTIONS.

LEARN HOW GRAPHICS ARE USED TO MAKE INFORMATION EASIER TO VISUALIZE ♦ SEE HOW UNDERLYING PATTERNS FOUND IN ALL GRAPHICS CAN BE USED TO MORE IMPACTFULLY COMMUNICATE WHAT YOUR RAW DATA CONVEYS ♦ LEARN TO CREATE EYE-CATCHING GRAPHICS THAT SHOW TRENDS AND CYCLES, EASILY AND QUICKLY ♦ CREATE CHARTS FROM COLUMN, BAR, LINE, AREA, SCATTER, SURFACE AND RADAR TO DONUT, WATERFALL, BOX & WHISKER, SUNBURST, TREEMAP AND HISTOGRAM ♦ CREATE SINGLE-CELLED SPARKLINE GRAPHS IN LINE, BAR, AND WIN-LOSS FORMATS ♦ CREATE COMBO CHARTS THAT INCLUDE MULTIPLE TYPES ♦ ANALYZE FURTHER WITH VARIETIES OF TRENDLINES AND FORECASTING ♦ USE DRAWING TOOLS TO ADD A VARIETY OF SHAPES ♦ ADD TEXT TO A SHAPE AND USE THE DRAWING CANVAS TO CONTROL DRAWING ELEMENTS ♦ CHANGE AN EXISTING SHAPE AND APPLY FORMATTING STYLES AND EFFECTS ♦ MAKE AND INSERT SCREEN SHOTS TO YOUR WORKSHEETS ♦ REARRANGE, RESIZE, ORGANIZE, AND FORMAT SHAPES ♦ INSERT A VARIETY OF SMARTART DIAGRAM OBJECTS INCLUDING LISTS, PROCESSES, CYCLES, HIERARCHY’S, MATRIXES, PYRAMIDS AND MORE ♦ ADJUST THE LAYOUT OF THE SHAPES USED IN THE SMARTART OBJECTS ♦ APPLY NEW LAYOUTS AND FORMATTING STYLES ♦ ADD ADDITIONAL OBJECT SHAPES USING THE PANE.

EXPLORE HOW ONENOTE PROVIDES AN EFFECTIVE WAY TO CREATE AND COLLECT YOUR NOTES IN AN ELECTRONIC NOTEBOOK WILL HELP YOU CAPTURE IDEAS, MEETING NOTES, AND TO-DO ITEMS ♦ LEARN HOW TO STORE A WIDE VARIETY OF CONTENT IN AN ORGANIZED STRUCTURE, ACCESS THE CONTENT FROM ANYWHERE, AND SHARE IT WITH OTHERS ♦ NAVIGATE AND CUSTOMIZE THE ONENOTE INTERFACE AND ENVIRONMENT ♦ ADD AND FORMAT TEXT, IMAGES, AUDIO, LINKS, AND DRAWING OBJECTS TO A NOTEBOOK ♦ EMBED EXCEL SPREADSHEETS AND ATTACH OTHER FILES TO A NOTEBOOK ♦ CATEGORIZE, ORGANIZE, AND SEARCH NOTEBOOK CONTENT ♦ CHECK SPELLING IN, PRINT, AND PASSWORD-PROTECT NOTEBOOKS ♦ USE OUTLOOK AND ONEDRIVE TO SEND AND SHARE NOTEBOOK CONTENT ♦ EXPORT NOTEBOOK CONTENT AND MANAGE NOTEBOOK HISTORY AND BACKUPS.

LEARN HOW TO EFFECTIVELY COMPOSE, RECEIVE, AND MANAGE YOUR E-MAIL MESSAGES ♦ CUSTOMIZE THE ENVIRONMENT TO WORK BEST FOR YOU ♦ SET HOW THE MESSAGES ARE DISPLAYED AND VIEWED ♦ FIND MESSAGES THAT FIT CERTAIN CRITERIA AND MANAGE MESSAGES USING FOLDERS, CATEGORIES, AND CONDITIONAL FORMATTING ♦ SET RULES THAT CONTROL HOW THE SYSTEM HANDLES OUTGOING AND INCOMING MESSAGES ♦ CREATE TASKS AND TODO’S FROM MESSAGES ♦ CREATE NEW MESSAGES FROM SCRATCH OR FROM MESSAGE TEMPLATES ♦ ATTACH FILES AND ITEMS TO MESSAGES AND LEARN HOW TO MANAGE MESSAGES WITH ATTACHMENTS ♦ PROOFREAD SPELLING AND GRAMMAR AND TRANSLATE MESSAGES INTO 50+ LANGUAGES ♦ PRINT OR PDF MESSAGES.

MANAGE YOUR CONTACTS, CALENDAR MEETINGS AND APPOINTMENTS, TASKS AND NOTES USING THESE POWERFUL TOOLS ♦ START BY EXPLORING YOUR ORGANIZATION’S GLOBAL ADDRESS BOOK AS WELL AS YOUR PERSONAL CONTACTS PEOPLE LIST ♦ LEARN HOW TO ADD APPOINTMENTS AND SET UP MEETINGS WITH OTHERS ♦ UNDERSTAND HOW TO ACCEPT OR DECLINE A MEETING REQUEST ♦ SEE HOW TO SHARE YOUR CALENDAR OR VIEW OTHER PEOPLE’S CALENDARS, WITH OR WITHOUT THEIR PERMISSION ♦ LEARN HOW TO CREATE TASKS AND TO-DO’S FOR YOURSELF OR CREATE AND TRACK FOR OTHERS ♦ ORGANIZE YOUR THOUGHTS WITH NOTES.

LEARN HOW TO EFFECTIVELY COMPOSE, RECEIVE, AND MANAGE YOUR E-MAIL MESSAGES ♦ CUSTOMIZE THE ENVIRONMENT TO WORK BEST FOR YOU ♦ SET HOW THE MESSAGES ARE DISPLAYED AND VIEWED ♦ FIND MESSAGES THAT FIT CERTAIN CRITERIA AND MANAGE MESSAGES USING FOLDERS, CATEGORIES, AND CONDITIONAL FORMATTING ♦ SET RULES THAT CONTROL HOW THE SYSTEM HANDLES OUTGOING AND INCOMING MESSAGES ♦ CREATE TASKS AND TODO’S FROM MESSAGES ♦ CREATE NEW MESSAGES FROM SCRATCH OR FROM MESSAGE TEMPLATES ♦ ATTACH FILES AND ITEMS TO MESSAGES AND LEARN HOW TO MANAGE MESSAGES WITH ATTACHMENTS ♦ PROOFREAD SPELLING AND GRAMMAR AND TRANSLATE MESSAGES INTO 50+ LANGUAGES ♦ PRINT OR PDF MESSAGES.

MANAGE YOUR CONTACTS, CALENDAR MEETINGS AND APPOINTMENTS, TASKS AND NOTES USING THESE POWERFUL TOOLS ♦ START BY EXPLORING YOUR ORGANIZATION’S GLOBAL ADDRESS BOOK AS WELL AS YOUR PERSONAL CONTACTS PEOPLE LIST ♦ LEARN HOW TO ADD APPOINTMENTS AND SET UP MEETINGS WITH OTHERS ♦ UNDERSTAND HOW TO ACCEPT OR DECLINE A MEETING REQUEST ♦ SEE HOW TO SHARE YOUR CALENDAR OR VIEW OTHER PEOPLE’S CALENDARS, WITH OR WITHOUT THEIR PERMISSION ♦ LEARN HOW TO CREATE TASKS AND TO-DO’S FOR YOURSELF OR CREATE AND TRACK FOR OTHERS ♦ ORGANIZE YOUR THOUGHTS WITH NOTES.

MICROSOFT ONEDRIVE IS A CLOUD-BASED STORAGE SERVICE THAT ALLOWS A USER TO ACCESS FILES FROM ANY DEVICE WITH AN INTERNET CONNECTION ♦ DISCOVER HOW TO STORE AND SHARE DOCUMENTS, SPREADSHEETS, AND OTHER FILES WITH MICROSOFT ONEDRIVE ♦ THIS MEANS A USER CAN SHARE FILES WITH OTHERS WITHIN THE ORGANIZATION AS WELL AS EXTERNAL USERS ♦ FILES STORED ON ONEDRIVE CAN BE EDITED IN THE OFFICE ONLINE APPLICATIONS AND CAN EVEN BE CO-AUTHORED BY MULTIPLE USERS AT ONCE ♦ SEE HOW TO GET STARTED WITH ONEDRIVE AND LEARN HOW TO UPLOAD, ORGANIZE, COPY, AND DELETE FILES ♦ LEARN ABOUT HOW TO VIEW PHOTOS IN ELEGANT GALLERIES AND SLIDESHOWS, SHARE FILES USING LINKS AND THE PUBLIC FOLDER, LOCATE SPECIFIC FILES, AND CREATE DOCUMENTS WITH MICROSOFT OFFICE ONLINE ♦ GET QUICK ANSWERS TO YOUR MOST PRESSING QUESTIONS ♦ LEARN HOW TO BE MORE PRODUCTIVE AND COLLABORATIVE WITH ONEDRIVE INCLUDING ACCESS TO YOUR DOCUMENTS FROM ANYWHERE, ANY DEVICE, ANY BROWSER, ANY TIME ♦ DISCOVER HOW TO UPLOAD AND LOCATE FILES AND FOLDERS IN ONEDRIVE, SHARE FILES AND FOLDERS WITH INTERNAL AND EXTERNAL COLLEAGUES, INCLUDING MANAGING FILE VERSIONS, CHANGE SHARING OPTIONS, ACCESS AND CHANGE FILE VERSIONS, SYNC FILES TO THE DESKTOP, RESTORE FILES, USE ONEDRIVE ON MOBILE DEVICES AND MORE ♦ STUDENTS WILL ALSO LEARN TO WORK WITH VERSION HISTORY, DELETE FILES, AND SYNC FILES.

GOOGLE DRIVE IS A CLOUD-BASED STORAGE SERVICE THAT ALLOWS A USER TO ACCESS FILES FROM ANY DEVICE WITH AN INTERNET CONNECTION ♦ DISCOVER HOW TO STORE AND SHARE DOCUMENTS, SPREADSHEETS, AND OTHER FILES WITH GOOGLE DRIVE ♦ THIS MEANS A USER CAN SHARE FILES WITH OTHERS WITHIN THE ORGANIZATION AS WELL AS EXTERNAL USERS ♦ FILES STORED ON DRIVE CAN BE EDITED IN THE OFFICE ONLINE APPLICATIONS AND CAN EVEN BE CO-AUTHORED BY MULTIPLE USERS AT ONCE ♦ SEE HOW TO GET STARTED WITH DRIVE AND LEARN HOW TO UPLOAD, ORGANIZE, COPY, AND DELETE FILES ♦ LEARN ABOUT HOW TO VIEW PHOTOS IN ELEGANT GALLERIES AND SLIDESHOWS, SHARE FILES USING LINKS AND THE PUBLIC FOLDER, LOCATE SPECIFIC FILES, AND CREATE DOCUMENTS WITH GOOGLE ONLINE ♦ GET QUICK ANSWERS TO YOUR MOST PRESSING QUESTIONS ♦ LEARN HOW TO BE MORE PRODUCTIVE AND COLLABORATIVE WITH DRIVE INCLUDING ACCESS TO YOUR DOCUMENTS FROM ANYWHERE, ANY DEVICE, ANY BROWSER, ANY TIME ♦ DISCOVER HOW TO UPLOAD AND LOCATE FILES AND FOLDERS IN DRIVE, SHARE FILES AND FOLDERS WITH INTERNAL AND EXTERNAL COLLEAGUES, INCLUDING MANAGING FILE VERSIONS, CHANGE SHARING OPTIONS, ACCESS AND CHANGE FILE VERSIONS, SYNC FILES TO THE DESKTOP, RESTORE FILES, USE DRIVE ON MOBILE DEVICES AND MORE ♦ STUDENTS WILL ALSO LEARN TO WORK WITH VERSION HISTORY, DELETE FILES, AND SYNC FILES.

CREATE TEXTUAL AND GRAPHIC PRESENTATIONS WITH EASE USING THIS POWERFUL PRESENTATION SOFTWARE ♦ CREATE PRESENTATIONS FROM SCRATCH OR THROUGH PRESENTATION TEMPLATES THAT NUMBER THE THOUSANDS ♦ LEARN HOW TO ADD TEXTUAL CONTENT BY TYPING AS WELL AS THROUGH THE IMPORTATION FROM OTHER SOURCES ♦ USE AUTO TEXT TO PLACE SAVED CHUNKS OF TEXT INTO A SLIDE ♦ ADD SPECIAL CHARACTERS THROUGHOUT ♦ ADD NOTES TO EACH SLIDE TO USE LATER WHEN PRESENTING ♦ CREATE BULLETED AND MULTI-LEVEL OUTLINE LISTS TO SHOWCASE VARIOUS TEXT ♦ APPLY VARIOUS FORMATTING AND THEME FORMATTING TO YOUR TEXT AND SLIDES ♦ WORK WITH THE SLIDE MASTER TO QUICKLY FORMAT OR CHANGE THE FORMATTING FOR THE ENTIRE PRESENTATION ♦ UNDERSTAND HOW TO MANAGE YOUR PRESENTATION’S SLIDES FOR PRODUCTIVITY AND EFFECTIVENESS ♦ PROOF YOUR PRESENTATION FOR SPELLING AND GRAMMAR ♦ TRANSLATE ANY OR THE ENTIRE PRESENTATION INTO ANY ONE OF 50+ LANGUAGES.

LEARN HOW TO CREATE AND INSERT TABLES AND SPREADSHEETS INTO SLIDES ♦ ADD GRAPHICS LIKE SHAPES, ICONS, MODELS, AND WORDART AND DRAW ATTENTION AND EFFECT ♦ INSERT PICTURES, SCREEN SHOTS, AS MULTIMEDIA INCLUDING VIDEOS, AUDIO, AND ONLINE MEDIA ♦ ADD CHARTS AND DIAGRAMS INCLUDING LINE, BAR, PIE, ORGANIZATIONAL CHARTS, AND FLOWCHART DIAGRAMS ♦ BRING YOUR SLIDES TO LIFE WITH SLIDE ANIMATIONS AND VISUAL TRANSITIONS ♦ DEVELOP SLIDE NOTES TO USE IN A PRESENTATION AND DISTRIBUTE AUDIENCE HANDOUTS FOR EFFECTIVE TAKEAWAYS ♦ CREATE VERSIONS OF YOUR PRESENTATION TO BE APPLIED TO VARIED AUDIENCES USING THE CUSTOM SHOW TOOL ♦ PREPARE YOUR PRESENTATION FOR DELIVERY EITHER IN PERSON OR SAVED AS A SHOW OR VIDEO ♦ UNDERSTAND HOW TO USE THE PRESENTER TOOLS FOR FLAWLESS PRESENTATION DELIVERY.

CREATE TEXTUAL AND GRAPHIC PRESENTATIONS WITH EASE USING THIS POWERFUL PRESENTATION SOFTWARE ♦ CREATE PRESENTATIONS FROM SCRATCH OR THROUGH PRESENTATION TEMPLATES THAT NUMBER THE THOUSANDS ♦ LEARN HOW TO ADD TEXTUAL CONTENT BY TYPING AS WELL AS THROUGH THE IMPORTATION FROM OTHER SOURCES ♦ USE AUTO TEXT TO PLACE SAVED CHUNKS OF TEXT INTO A SLIDE ♦ ADD SPECIAL CHARACTERS THROUGHOUT ♦ ADD NOTES TO EACH SLIDE TO USE LATER WHEN PRESENTING ♦ CREATE BULLETED AND MULTI-LEVEL OUTLINE LISTS TO SHOWCASE VARIOUS TEXT ♦ APPLY VARIOUS FORMATTING AND THEME FORMATTING TO YOUR TEXT AND SLIDES ♦ WORK WITH THE SLIDE MASTER TO QUICKLY FORMAT OR CHANGE THE FORMATTING FOR THE ENTIRE PRESENTATION ♦ UNDERSTAND HOW TO MANAGE YOUR PRESENTATION’S SLIDES FOR PRODUCTIVITY AND EFFECTIVENESS ♦ PROOF YOUR PRESENTATION FOR SPELLING AND GRAMMAR ♦ TRANSLATE ANY OR THE ENTIRE PRESENTATION INTO ANY ONE OF 50+ LANGUAGES.

LEARN HOW TO CREATE AND INSERT TABLES AND SPREADSHEETS INTO SLIDES ♦ ADD GRAPHICS LIKE SHAPES, ICONS, MODELS, AND WORDART AND DRAW ATTENTION AND EFFECT ♦ INSERT PICTURES, SCREEN SHOTS, AS MULTIMEDIA INCLUDING VIDEOS, AUDIO, AND ONLINE MEDIA ♦ ADD CHARTS AND DIAGRAMS INCLUDING LINE, BAR, PIE, ORGANIZATIONAL CHARTS, AND FLOWCHART DIAGRAMS ♦ BRING YOUR SLIDES TO LIFE WITH SLIDE ANIMATIONS AND VISUAL TRANSITIONS ♦ DEVELOP SLIDE NOTES TO USE IN A PRESENTATION AND DISTRIBUTE AUDIENCE HANDOUTS FOR EFFECTIVE TAKEAWAYS ♦ CREATE VERSIONS OF YOUR PRESENTATION TO BE APPLIED TO VARIED AUDIENCES USING THE CUSTOM SHOW TOOL ♦ PREPARE YOUR PRESENTATION FOR DELIVERY EITHER IN PERSON OR SAVED AS A SHOW OR VIDEO ♦ UNDERSTAND HOW TO USE THE PRESENTER TOOLS FOR FLAWLESS PRESENTATION DELIVERY.

MICROSOFT PUBLISHER IS A DESKTOP PUBLISHING SOFTWARE APPLICATION CAPABLE OF PRODUCING GREETING CARDS, CERTIFICATES, NEWSLETTERS, AND OTHER PRINTED PUBLICATIONS ♦ CREATE, PERSONALIZE, AND SHARE A WIDE RANGE OF PROFESSIONAL-QUALITY PUBLICATIONS ♦ MAKE YOUR PUBLICATIONS LOOK MORE PROFESSIONAL AND HAVE MORE VISUAL IMPACT SO THAT YOU CAN SELL YOUR MESSAGE MORE POWERFULLY AND COMMUNICATE INFORMATION MORE EFFECTIVELY ♦ USE THIS POWERFUL SOFTWARE TO CREATE PROFESSIONAL-LOOKING BROCHURES, FLYERS, ADVERTISEMENTS, BUSINESS CARDS, BOOKLETS, AND MANY MORE ♦ SEE HOW MUCH MORE QUICKLY YOU CAN CREATE THE MOST COMPLEX PUBLICATIONS USING THE HUNDREDS OF AVAILABLE TEMPLATES TO CUT DEVELOPMENT TIME DOWN TO A FRACTION.

DISCOVER HOW THIS CHAT-BASED COLLABORATION TOOL PROVIDES GLOBAL, REMOTE, AND DISPERSED TEAMS (GROUPS) WITH THE ABILITY TO WORK TOGETHER AND SHARE INFORMATION VIA A COMMON SPACE ♦ LEARN HOW THIS PERSISTENT CHAT-BASED COLLABORATION PLATFORM FACILITATES IN DOCUMENT SHARING, ONLINE MEETINGS, ONE-ON-ONE AND TEAM CHAT, AND MANY MORE EXTREMELY USEFUL FEATURES FOR BUSINESS COMMUNICATIONS ♦ INTEGRATE AN ARSENAL OF APPS DESIGNED FOR USE IN THE TEAMS ENVIRONMENT.

EXPLORE HOW WORD MAKES IT EASY TO CREATE PROFESSIONALLY LOOKING DOCUMENTS USING ITS POWERFUL FEATURES AND RICH TOOLS ♦ LEARN HOW TO CREATE AN ASSORTMENT OF DOCUMENTS FROM LETTERS TO REPORTS ♦ START BY SETTING THE PAGE SIZE, MARGINS, AND LINE SPACING ♦ LEARN HOW TO EFFECTIVELY ENTER AND INSERT TEXT EVEN IF YOU LACK TYPING SKILLS ♦ EDIT YOUR WORK USING A VARIETY OF TEXT SELECTION AND EDITING TOOLS AND TECHNIQUES ♦ APPLY ESSENTIAL LAYOUT AND FORMATTING TOOLS TO GIVE YOUR DOCUMENT THAT CLEAN, UNCLUTTERED, PROFESSIONAL LOOK AND READABILITY ♦ APPLY FINISHING TOUCHES INCLUDING COVER PAGES AND MORE ♦ PROOF YOUR DOCUMENT FOR SPELLING AND GRAMMATICAL ERRORS AND USE THE THESAURUS TO FIND THAT PERFECT WORD ♦ TRANSLATE YOUR DOCUMENT INTO ANY ONE OF 50+ LANGUAGES ♦ SAVE YOUR DOCUMENT AS A WORD DOCUMENT OR TRANSFORM IT INTO AN ACROBAT PDF ♦ LEARN HOW TO SAVE YOUR DOCUMENT LOCALLY OR ON THE CLOUD… AND SEE HOW TO SHARE YOUR DOCUMENT AND HAVE OTHERS COLLABORATE ♦ LEARN HOW TO PRINT YOUR DOCUMENT WITH MANY OPTIONS.

DOCUMENT FORMATTING IS ONE OF THE MOST IMPORTANT ELEMENTS IN OVERALL READABILITY BECAUSE IT CAN BE FRUSTRATING TO READ AND ABSORB IF IT IS NOT STRUCTURED INTO A CLEAR HIERARCHY OF INFORMATION ♦ WELL FORMATTED DOCUMENTS MAKE FOR A LASTING IMPRESSION AND ARE MUCH MORE QUICKLY AND EASILY READ AND UNDERSTOOD ♦ LEARN DOCUMENT DESIGN CONSIDERATIONS THAT WILL HELP ENHANCE THE READABILITY OF THE DOCUMENT ♦ CONSIDERATIONS FOR OVERALL AS FAR AS FONT, SPACING AND ALIGNMENT FORMATTING ♦ LEARN THE TOOLS USED TO FORMAT TEXT, LINES, PARAGRAPHS, PAGES, AND THE OVERALL DOCUMENT ♦ MAKE YOUR POINTS STAND OUT WITH SINGLE LEVEL BULLETING AND MULTI-LEVEL LISTS ♦ APPLY CONSISTENT FORMATTING AND SAVE FORMATTING TIME BY CREATING AND USING STYLE AND THEME FORMATTING ♦ LEARN HOW SECTION BREAKS ARE USED TO CONTAIN FORMATTING WITHIN A CERTAIN AREAS.

EXPLORE WORD’S EASY-TO-USE LAYOUT TOOLS THAT ORGANIZE DOCUMENT INFORMATION INTO COLUMNS, TABBED COLUMNS, TABLES, AND EMBEDDED SPREADSHEETS ♦ LEARN HOW TO MAKE DATA EASIER TO READ AND UNDERSTAND BY DISPLAYING DATA IN ROWS AND COLUMNS, WITH OPTIONAL TITLE AND TABLE HEADINGS ♦ SEE THE DIFFERENCES IN THE DISPLAY OF DATA WHEN COMPARING COLUMNAR LAYOUT STYLES FOR TABS, COLUMNS, TABLES, AND EMBEDDED SPREADSHEETS ♦ WORK WITH THE DEFAULT TAB SETTINGS AND THEN LEARN HOW TO MANUALLY SET TAB STOPS FOR PERFECT POSITIONING ♦ SET UP A MULTI-COLUMN LAYOUT AND COMPARE THAT WITH A PARALLEL COLUMN SETUP ♦ CONVERT EXISTING TEXT INTO NEWSPAPER LAYOUT ♦ INSERT A TABLE FROM A GRID OR DRAW ONE FROM SCRATCH ♦ QUICKLY CONVERT EXISTING TEXT INTO A TABLE LAYOUT ♦ INSERT OR EMBED A NEW OR EXISTING WORKSHEET AND OPTIONALLY LINK IT FROM MICROSOFT EXCEL ♦ INSERT CHARTS AND GRAPHS INCLUDING COLUMN, BAR, LINE, AND PIE ♦ ADD SMARTART DIAGRAMS LIKE ORG CHARTS AND FLOW CHARTS ♦ ADD PICTURES, ICONS AND GRAPHIC SHAPES AND OPTIONALLY CONNECT THEM WITH CONNECTOR LINES ♦ INSERT BOOKMARKS AND HYPERLINKS ♦ ADD DOCUMENT REFERENCING LIKE TABLE OF CONTENTS, INDEXING, FOOTNOTES, AND ENDNOTES ♦ SHARE AND COLLABORATE USING ONEDRIVE CLOUD STORAGE ♦ MANAGE THE MANY VERSIONS OF YOUR DOCUMENT AND GO BACK TO ANY ONE OF THEM ♦ LEARN HOW TO MAIL MERGE ENVELOPES, LABELS AND FORM LETTERS AND LEARN HOW TO PERFORM E-MAIL MAIL MERGE AS WELL.

EXPLORE HOW DOCS MAKES IT EASY TO CREATE PROFESSIONALLY LOOKING DOCUMENTS USING ITS POWERFUL FEATURES AND RICH TOOLS ♦ LEARN HOW TO CREATE AN ASSORTMENT OF DOCUMENTS FROM LETTERS TO REPORTS ♦ START BY SETTING THE PAGE SIZE, MARGINS, AND LINE SPACING ♦ LEARN HOW TO EFFECTIVELY ENTER AND INSERT TEXT EVEN IF YOU LACK TYPING SKILLS ♦ EDIT YOUR WORK USING A VARIETY OF TEXT SELECTION AND EDITING TOOLS AND TECHNIQUES ♦ APPLY ESSENTIAL LAYOUT AND FORMATTING TOOLS TO GIVE YOUR DOCUMENT THAT CLEAN, UNCLUTTERED, PROFESSIONAL LOOK AND READABILITY ♦ APPLY FINISHING TOUCHES INCLUDING COVER PAGES AND MORE ♦ PROOF YOUR DOCUMENT FOR SPELLING AND GRAMMATICAL ERRORS AND USE THE THESAURUS TO FIND THAT PERFECT DOCS ♦ TRANSLATE YOUR DOCUMENT INTO ANY ONE OF 50+ LANGUAGES ♦ SAVE YOUR DOCUMENT AS A DOCS DOCUMENT OR TRANSFORM IT INTO AN ACROBAT PDF ♦ LEARN HOW TO SAVE YOUR DOCUMENT LOCALLY OR ON THE CLOUD… AND SEE HOW TO SHARE YOUR DOCUMENT AND HAVE OTHERS COLLABORATE ♦ LEARN HOW TO PRINT YOUR DOCUMENT WITH MANY OPTIONS.

DOCUMENT FORMATTING IS ONE OF THE MOST IMPORTANT ELEMENTS IN OVERALL READABILITY BECAUSE IT CAN BE FRUSTRATING TO READ AND ABSORB IF IT IS NOT STRUCTURED INTO A CLEAR HIERARCHY OF INFORMATION ♦ WELL FORMATTED DOCUMENTS MAKE FOR A LASTING IMPRESSION AND ARE MUCH MORE QUICKLY AND EASILY READ AND UNDERSTOOD ♦ LEARN DOCUMENT DESIGN CONSIDERATIONS THAT WILL HELP ENHANCE THE READABILITY OF THE DOCUMENT ♦ CONSIDERATIONS FOR OVERALL AS FAR AS FONT, SPACING AND ALIGNMENT FORMATTING ♦ LEARN THE TOOLS USED TO FORMAT TEXT, LINES, PARAGRAPHS, PAGES, AND THE OVERALL DOCUMENT ♦ MAKE YOUR POINTS STAND OUT WITH SINGLE LEVEL BULLETING AND MULTI-LEVEL LISTS ♦ APPLY CONSISTENT FORMATTING AND SAVE FORMATTING TIME BY CREATING AND USING STYLE AND THEME FORMATTING ♦ LEARN HOW SECTION BREAKS ARE USED TO CONTAIN FORMATTING WITHIN A CERTAIN AREAS.

EXPLORE DOC’S EASY-TO-USE LAYOUT TOOLS THAT ORGANIZE DOCUMENT INFORMATION INTO COLUMNS, TABBED COLUMNS, TABLES, AND EMBEDDED SPREADSHEETS ♦ LEARN HOW TO MAKE DATA EASIER TO READ AND UNDERSTAND BY DISPLAYING DATA IN ROWS AND COLUMNS, WITH OPTIONAL TITLE AND TABLE HEADINGS ♦ SEE THE DIFFERENCES IN THE DISPLAY OF DATA WHEN COMPARING COLUMNAR LAYOUT STYLES FOR TABS, COLUMNS, TABLES, AND EMBEDDED SPREADSHEETS ♦ WORK WITH THE DEFAULT TAB SETTINGS AND THEN LEARN HOW TO MANUALLY SET TAB STOPS FOR PERFECT POSITIONING ♦ SET UP A MULTI-COLUMN LAYOUT AND COMPARE THAT WITH A PARALLEL COLUMN SETUP ♦ CONVERT EXISTING TEXT INTO NEWSPAPER LAYOUT ♦ INSERT A TABLE FROM A GRID OR DRAW ONE FROM SCRATCH ♦ QUICKLY CONVERT EXISTING TEXT INTO A TABLE LAYOUT ♦ INSERT OR EMBED A NEW OR EXISTING WORKSHEET AND OPTIONALLY LINK IT FROM GOOGLE SHEETS ♦ INSERT CHARTS AND GRAPHS INCLUDING COLUMN, BAR, LINE, AND PIE ♦ ADD DIAGRAMS LIKE ORG CHARTS AND FLOW CHARTS ♦ ADD PICTURES, ICONS AND GRAPHIC SHAPES AND OPTIONALLY CONNECT THEM WITH CONNECTOR LINES ♦ INSERT BOOKMARKS AND HYPERLINKS ♦ ADD DOCUMENT REFERENCING LIKE TABLE OF CONTENTS, INDEXING, FOOTNOTES, AND ENDNOTES ♦ SHARE AND COLLABORATE USING ONEDRIVE CLOUD STORAGE ♦ MANAGE THE MANY VERSIONS OF YOUR DOCUMENT AND GO BACK TO ANY ONE OF THEM ♦ LEARN HOW TO MAIL MERGE ENVELOPES, LABELS AND FORM LETTERS AND LEARN HOW TO PERFORM E-MAIL MAIL MERGE AS WELL.

EXPLORE HOW VISIO CAN HELP YOU CREATE PROFESSIONAL-LOOKING GRAPHIC DIAGRAMS, MAPS, AND DRAWINGS, USING ITS EXTENSIVE BY USING ITS EXTENSIVE GALLERY OF SHAPES, THEMES, AND STENCILS ♦ LEARN HOW YOU CAN USE ITS GRAPHIC CAPABILITIES TO COMMUNICATE PROCESSES, FLOWS AND RELATIONSHIPS, THROUGH VISUAL REPRESENTATIONS ♦ LEARN HOW TO DESIGN, MODIFY, AND MANAGE A WIDE ASSORTMENT OF DIAGRAMS INCLUDING FLOWCHARTS, ORGANIZATIONAL CHARTS, NETWORK DIAGRAMS, WORKFLOW DIAGRAMS, TIMELINES, FLOOR PLANS, BLOCK AND DATAFLOW DIAGRAMS, WIREFRAMES, CALENDARS, MAPS, AND GANTT CHARTS ♦ SEE HOW TO DRAW AND ORGANIZE SHAPES ♦ ADD PICTURES AS SHAPES ♦ CREATE NEW SHAPES AND ORGANIZE THEM ON STENCILS ♦ FORMAT USING TRADITIONAL TOOLS AS WELL AS FROM AN ASSORTMENT OF THEMES ♦ LEARN HOW TO PROPERLY CONNECT SHAPES, VISUALLY ORGANIZE THEM INTO CONTAINERS AND CREATE MULTIPLE LAYERS DRAWINGS ♦ UNDERSTAND PAGING FEATURES AND SHAPE SHEETS ♦ LEARN HOW TO UTILIZE DATA GRAPHICS THAT TRANSFORMS ANY DIAGRAM INTO A VISUAL DATABASE, ALONG WITH CREATING DATA SHAPE REPORTS.

LEARN HOW TO USE THIS PROGRAM TO MANAGE ANY SIZE PROJECT WITH EASE ♦ UNDERSTAND WHAT IS NEEDED TO MANAGE YOUR PROJECT INCLUDING PURPOSE, SCOPE, AND EXPECTATIONS ♦ CREATE PROJECTS FROM SCRATCH AND TEMPLATES, ADD TASKS AND MILESTONES, AND ESTABLISH RELATIONSHIPS ♦ LEARN THE RELATION BETWEEN DURATION AND HOURS WORKED ♦ UNDERSTAND CRITICAL PATH, TASK CONSTRAINTS AND THE HIDING OF TASKS TO SEE EFFECTS ON THE PROJECT ♦ APPLY FORMATTING TO GANTT CHART AND CALENDAR VIEWS ♦ CREATE A PROJECT TIMELINE AND MODIFY THE PROJECT’S TIMESCALE ♦ SCHEDULE THE PROJECT FROM A START DATE OR FROM A FINISH DATE ♦ PRINT A PROJECT IN A VARIETY OF FORMATS AND PROJECT VIEWS.

APPLY WORK, MATERIAL AND COST RESOURCES TO PROJECT TASKS USING FIXED AND POOLED RESOURCE SOURCES ♦ MODIFY RESOURCE WORK CALENDARS TO REFLECT CUSTOMIZED WORK AVAILABILITY ♦ CHANGE PROJECT TASK SCHEDULING BY APPLYING RESOURCES WITH CUSTOMIZED CALENDARS ♦ CREATE PROJECT BASELINE BUDGETS TO TRACK THE PROGRESS OF YOUR PROJECT IN REAL-TIME ♦ EASILY MANAGE MULTIPLE PROJECTS BY LINKING THEM TO A MASTER PROJECT SCREEN ♦ ADD INDICATORS AND ALARMS TO YOUR PROJECT VIEWS BY INSERTING FORMULAS ♦ APPLY CONDITIONAL FORMATTING TO PROJECT VIEWS USING FORMULAS ♦ ADD NEW FIELDS USING FORMULAS TO EXISTING PROJECT VIEWS AND ADD EXISTING FIELDS AS WELL ♦ USE REPORT TEMPLATES TO REPORT ON A PROJECT ♦ CREATE MACROS TO AUTOMATE REPETITIVE TASKS.

LEARN ALL THE NECESSARY ESSENTIALS OF WINDOWS 10 ♦ THIS COMPREHENSIVE COURSE COVERS EVERYTHING YOU NEED TO KNOW TO SUCCESSFULLY USE ALL THAT THIS POWERFUL OPERATING SYSTEM HAS TO OFFER ♦ START BY GETTING TO KNOW YOUR COMPUTER AND THE WINDOWS 10 INTERFACE ♦ USE THE WINDOWS APPS INCLUDING MAIL, MUSIC, CALENDAR, MOVIES, CAMERA AND TV, AND ALONG THE WAY, UNDERSTAND THE HOW TO NAVIGATE YOUR SYSTEM ♦ WORK WITH SOME OF THE MORE POPULAR DESKTOP SOFTWARE PROGRAMS AS WELL AS MICROSOFT’S WEB BROWSER CALLED THE EDGE ♦ CUSTOMIZE THE WINDOWS ENVIRONMENT TO WORK BEST FOR YOU ♦ USE AND UNDERSTAND SECURITY FEATURES TO ALWAYS BE AHEAD OF THE GAME ♦ WORK WITH THE SETTINGS AND CONTROL PANEL ALONG WITH THE VIRTUAL DESKTOPS ♦ LEARN HOW TO CONNECT AND CONFIGURE DEVICES INCLUDING WEBCAMS AND PRINTERS.