180+ Applications, Professional Development Video-Base Courses.

Accounting

Objectives – You will be able to:

  • Determining which version of Quickbooks Online best fits your needs
  • Navigating QuickBooks Online
  • Using the banking center, reconciling accounts, and tracking mileage
  • Setting up vendors, paying bills and managing purchase orders
  • Managing customers, products and services, sales tax, and invoices
  • Read More…

Objectives – You will be able to:

  • Navigate the QuickBooks 2018 interface, including the new Multi-Monitor mode
  • Start a blank new Company File or copy from another Company File
  • Setup a Chart of Accounts
  • Describe how Inventory works in QuickBooks Desktop
  • Demonstrate the tools and features in the Customer Center and Vendor Center
  • Create and customize basic reports
  • Find transactions.. more

Objectives – You will be able to:

  • Describe how inventory adjustments and assemblies function
  • Create customized invoices
  • Use the QuickBooks document center, bank feed center, audit trail, and timesheets.. more

Objectives – You will be able to:

  • Discuss the differences between the different QuickBooks Online versions as well as QuickBooks Desktop
  • Navigate around the QuickBooks Interface, incliuding Dashboards, Money Bars, and the Quick Create menu
  • Create and edit Estimates, Invoices, Sales Receipts, and Deposits
  • Describe various ways to troubleshoot reports.. more
  • Objectives – You will be able to:
    • Describe the Accounting Equation (Assets = Liabilities + Equity)
    • Explain the use of General Journal Entries and double-entry accounting
    • Distinguish between calendar year and fiscal year
    • Discuss Assets, Liabilities, Equity, Debits, Credits, Revenue, Expenses, and the Accounting Process.. more

Information Technology

Objectives – You will be able to:

  • Summarize Switches and VLANS
  • Differentiate patches and updates
  • distinguish common troubleshooting tools.. more

Business Skills

  •  Aprender tres objetivos de una estrategia de gestión de correo electrónico 
  • Comprender los dos tipos de malas estrategias de correo electrónico 
  • Usar carpetas de correo electrónico integradas y agregar las suyas propias 
  • Gestión de correos electrónicos con el proceso de clasificación de cinco pasos 
  • Aprender las diferencias entre Gmail y otros programas de correo electrónico 
  • Read More…
  • Uso de la Auditoría de Tiempos para analizar su productividad
  • Definición de sus Prioridades
  • Centrarse en su Círculo de Influencia
  • Usar una Lista de Tareas de manera eficaz
  • Read More…
  • Entendiendo los riesgos de los piratas informáticos modernos 
  • Reconociendo los ataques de phishing que vienen desde correo electrónico y SMS 
  • Identificando cómo defenderse contra actualizaciones falsas para Windows, Flash, Java y más 
  • Aprendiendo consejos para mantenerse seguro en línea 
  • Read More…
  • Describing the difference between Business Intelligence, Analytics and Testing
  • Distinguishing between four different analytics methodologies
  • Explaining the difference between data science and decision science
  • Applying the BADIR approach to analytics
  • Identifying the benefits and application of each step in the process
  • Communicating results in an effective manner
  • Read More….
  • Starting high in an organization
  • Designing a calling roadmap that keeps you focused on the objective of the call
  • Leaving intriguing voicemails that get you a call back
  • Gaining a critical “Next Set Time”
  • Read More….
  • Explaining the need to prioritize tasks 
  • Conducting a time audit 
  • Applying the SMART test to goal setting 
  • Creating and prioritizing a To Do list 
  • Delegating using the correct process 
  • Read More….
  • Understanding delegation 
  • Learning the qualities of a good delegator  
  • Developing a plan 
  • Honing your skills 
  • Seeking cooperation 
  • Enabling your team 
  • Learning task management tools 
  • Read More….

Objectives – You will be able to:

  • List three goals of an email management strategy
  • Describe the two types of bad email strategies
  • Identify the five primary built-in email folders and their purpose
  • Discuss the benefit of the “To Be Sorted” and “To Do” folders
  • Describe the five-step sorting process for managing emails
  • Discuss the differences between Gmail and other email programs
  • Identify how to convert emails into calendar appointments or tasks in Outlook and in Gmail
  • Describe how Flags, Stars, Mark Important, Categories, and Delegation can be used in an effective email management strategy.. more

Objectives – You will be able to:

  • Describe common mistakes people make in naming their electronic files
  • Identify the different uses for file names and folder structure in searching and browsing
  • Discuss the best use of local, network, and cloud-based storage drives, and the pros and cons of saving to each
  • List six rules to help name files appropriately
  • List four rules to use folders effectively
  • Describe how to use the search function on Windows PCs or Macs, including where to find the tools to fix the search index if needed
  • Discuss the use of the Quick Access list on a PC or the Favorites list on a Mac
  • Describe how to use advanced search features to help clean up your filing system.. more
  • Objectives – You will be able to:
    • Describe some of the risks to yourself and your employers from modern cyber attacks
    • Identify Phishing attacks and list five or more ways they might be used in an email or SMS message
    • Describe how to verify if updates from Windows, Java, Flash, and Adobe Reader are legitimate
    • Discuss the roles of two-factor authentication, https, firewalls, social media, hoaxes, and data backup in preventing or facilitating cyber attacks.. more
  • Objectives – You will be able to:
    • Audit how you currently spend your time and identify areas for improvement.
    • Set SMART goals and evaluate goals against the SMART criteria.
    • Say “No” gracefully and effectively so you can stay focused on your goals.
    • Describe a five-step process for effectively delegating the right tasks to the right people.
    • Implement multiple techniques for minimizing interruptions.
    • Keep meetings moving by sending an agenda ahead of time and using a parking lot during the meeting.
    • Determine how to handle seven different disruptive personality types to keep meetings on track.
    • Describe the importance of email folders and list four recommended folders everyone needs to help them declutter.. more

Objectives – You will be able to:

  • Describe the three types of user accounts Windows 10 supports
  • List the three most common versions of Windows 10
  • Discuss how to navigate around the desktop, start menu, task bar, and action center
  • Demonstrate how to use Cortana for search and other functions, including via text or verbal commands
  • Discuss the use of File Explorer and the Quick Access screen
  • Demonstrate the use of Snap, Task View, and Virtual Desktops
  • Identify common Windows 10 Apps
  • Describe ways to customize your Windows 10 experience.. more

Objectives – You will be able to:

  • Recognize the three types of blind spots
  • Analyze how the brain operates maladaptively in the modern world
  • Apply strategy to neutralize your flight or fight response associated with blind spots
  • Create an Awareness, Action, Adaptation plan for overcoming blind spots.. more

Objectives – You will be able to:

  • Describe the five principles of document design: contrast, proximity, alignment, balance, and consistency.
  • Explain the benefits of each design principle.
  • Illustrate the five design principles in a document.
  • Choose the best design principle to emphasize information within a document.. more

Objectives – You will be able to:

  • Describe risk, opportunity, and reward
  • Summarize the most common mistakes made by individuals
  • Construct a business without feeling trapped.. more

Lessons Include:

01: How Communication Works (13:33)
02: What You Didn’t Know You Were Hearing (9:39)
03: Interpreting Body Language and Tone (8:32)
04: What Stops Us from Listening? (8:21)
05: Active Listening, Part 1 (7:10)
06: Active Listening, Part 2 (5:09).. more

Objectives – You will be able to:

  • Describe the “Keys to Excellence”
  • Apply the “Keys to Excellence” to situations and failures
  • “Learn how to make the hurt better rather than bitter”.. more

Objectives – You will be able to:

  • Describe the three components of good email management
  • Demonstrate how to use folders and categories to organize emails
  • Discuss the use of Rules, Junk Folder, and Delegate Access in managing email.. more

Objectives – You will be able to:

  • Describe the relationship between bad choices and consequences
  • List three legs of the Integral Model
  • Discuss the Unethical Continuum.. more

Objectives – You will be able to:

  • Describe the relationship between Persuasion and Communication
  • Discuss the elements of Persuasion
  • Identify the use of Framing in communication.. more

Objectives – You will be able to:

  • Describe the benefit of planning your presentation
  • List free and paid sites for acquiring presentation graphics
  • Discuss the role of the “Rule of Thirds” in creating appealing slides.. more

Objectives – You will be able to:

  • List four useful websites or applications
  • Discuss the benefits and disadvantages to outsourcing to 99designs.com
  • Describe situations when IFTTT.com can be useful.. more

Objectives – You will be able to:

  • Describe software programs and 3rd party services that can be used for printed calendars
  • Demonstrate using free or paid Google accounts to create a shareable online calendar
  • Discuss the pros and cons of Office 365 individual calendars compared to calendars from Groups, Teams, or shared mailboxes
  • Evaluate the use of third party calendar services such as TeamUp for calendar sharing
  • Describe how to integrate Google, Microsoft, or TeamUp calendars into a website.. more

Objectives – You will be able to:

  • Describe the benefits of using Storytelling in Business
  • Identify four or more places where Storytelling can be used in Business
  • Explain the use of the Personal Story Generator to capture stories
  • Describe the four basic elements of the Hero’s Journey
  • Discuss various methods to collect business stories.. more

Objectives – You will be able to:

  • Audit how you currently spend your time and identify areas for improvement.
  • Set SMART goals and evaluate goals against the SMART criteria.
  • Say “No” gracefully and effectively so you can stay focused on your goals.
  • Describe a five-step process for effectively delegating the right tasks to the right people.
  • Implement multiple techniques for minimizing interruptions.
  • Keep meetings moving by sending an agenda ahead of time and using a parking lot during the meeting.
  • Determine how to handle seven different disruptive personality types to keep meetings on track.
  • Describe the importance of email folders and list four recommended folders everyone needs to help them declutter.. more

Objectives – You will be able to:

  • Define plain language and describe why you should want to write in plain language
  • Describe your reader’s needs, taking into account state-specific literacy
  • Organize your content in a way that makes it most likely to be read, understood, and acted on
  • Write shorter sentences and paragraphs to serve your reader’s needs
  • Choose your words wisely for both readability, consistency, and relevance to your audience
  • Format your content appropriately to emphasize important points
  • Use bulleted lists the right way.. more

HIPAA

Objectives – You will be able to:

  • Describing HIPAA’s history 
  • Identifying important terms and acronyms associated with HIPAA 
  • Discussing three major HIPAA rules 
  • Describing key pieces of the Privacy Rule 
  • Recognizing the 18 elements of PHI (Protected Health Information) 
  • Identifying three types of safeguards 
  • Applying tips for HIPAA implementation 
  • Read More…

Objectives – You will be able to:

  • Describe the history and applicability of HIPAA
  • Discuss the three major HIPAA rules
  • Identify and explain the three types of safeguards.. more

Objectives – You will be able to:

  • Describe the history and applicability of HIPAA
  • Discuss the three major HIPAA rules
  • Identify and explain the three types of safeguards.. more

Objectives – You will be able to:

  • Describe the history and applicability of HIPAA
  • Discuss the three major HIPAA rules
  • Identify and explain the three types of safeguards.. more

Millennial Managers

Objectives – You will be able to:

  • Describe the prevalence of sexual harassment in the workplace and its impacts on the workplace
  • List examples of behavior that may be considered sexual harassment as well as examples of positive behaviors that can help limit harassing situations
  • Discuss the legal implications of sexual harassment and the employer’s legal responsibilities
  • Describe your federal protections through the EEOC and available remediation options
  • Define retaliation and describe your rights when it comes to protected behavior
  • Describe your responsibility as an employee and how you can use common sense to contribute to a positive work environment
  • Describe three approaches to bystander intervention and list specific ways you can help reduce harassment at your workplace
  • Describe strategies for constructively addressing conflict and building positive relationships at work.. more

Objectives – You will be able to:

  • Describe the prevalence of sexual harassment in the workplace and its impacts on the workplace, and list examples of behavior that may be considered sexual harassment as well as examples of positive behaviors that can help limit harassing situations
  • Discuss the legal implications of sexual harassment and the employer’s legal responsibilities
  • Describe your federal protections through the EEOC and available remediation options, and define retaliation and describe your rights when it comes to protected behavior
  • Describe strategies for constructively addressing conflict and building positive relationships at work including three approaches to bystander intervention and specific ways you can help reduce harassment at your workplace
  • Describe approaches for designing a workplace harassment policy and communicating it effectively
  • Describe a four-step process for implementing training including the three critical parts to effective training
  • Create an open and safe environment where employees feel safe, which includes handling complaints quickly and recognizing warning signs of problematic behavior
  • Develop an investigation process with the appropriate steps and documentation… more

Objectives – You will be able to:

  • Recognize the three types of blind spots
  • Analyze how the brain operates maladaptively in the modern world
  • Apply strategy to neutralize your flight or fight response associated with blind spots
  • Create an Awareness, Action, Adaptation plan for overcoming blind spots.. more

Objectives – You will be able to:

  • Explain the differences between Technical skills, Human skills, and Conceptual skills
  • Provide examples of why the balance of skill usage changes as a person moves up the career ladder
  • Explain the purpose behind the vision and mission of your company or department
  • Set SMART goals that align with the organization’s vision and mission
  • Compare and contrast the traits of leaders using Positional Power vs. Personal Power
  • Identify behaviors that provide good examples for employees to follow
  • Create goals for increasing trust using the Transactional Trust Model
  • Recognize and identify how personal values affect decisions and actions in the workplace
  • Explain how different perspectives bring value
  • Create methods for discovering others’ perspectives
  • Create connections from personal values to a manager’s SMART goals
  • Explain the need to challenge a process even if it appears to be working well
  • Explain the difference between a problem as understood and a problem as it truly is
  • Apply the 5 Whys to identify the root cause of a problem
  • Identify types of decision-making criteria applied to a specific problem
  • List resources and activities that aid employees to perform their jobs
  • Explain when training may be a better approach than direction
  • Compare and contrast reinforcement and feedback
  • Explain the 4:1 ratio and explore ways to apply it in the work environment.. more

Objectives – You will be able to:

  • Define delegation and discuss how it benefits an organization.
  • Describe the qualities needed for successful delegation.
  • Explain why some managers do not delegate well.
  • Discuss the first step to effective delegation and learn to assess personnel.
  • Identify steps to broaden your knowledge and skills.
  • Recognize good communication behaviors with your team.
  • Identify ways to seek cooperation for effective delegation.
  • Discuss the importance of establishing goals and expectations when delegating tasks.
  • Explain the importance of monitoring and supporting your team after delegating… more

Sales and Marketing

Objectives – You will be able to:

  • Explain the essentials of appointment making
  • Summarize the model of appointment making
  • Discuss how to answer a direct question or direct statement.. more

Objectives – You will be able to:

  • Discuss how to avoid the “Average Joe” mistake
  • Define the Educational Spectrum and it’s role in the “Right Place – Wrong Time” mistake
  • Identify ways to use Accelerated Discontentment in marketing.. more

Objectives – You will be able to:

  • Identify the difference between White Hat and Black Hat techniques
  • Define PPC
  • Describe the use of Social Media in online marketing… more

Workplace Safety

Objectives – You will be able to:

  • Understanding and measuring diversity and inclusion 
  • Explaining why DEI matters in the workplace and in your personal life 
  • Understanding, describing, and mitigating unconscious bias 
  • Recognizing microaggressions and describing how to handle them 
  • Becoming a DEI ally in the workplace 
  • Read More

Objectives – You will be able to:

  • Describe the prevalence of sexual harassment in the workplace and its impacts on the workplace, and list examples of behavior that may be considered sexual harassment as well as examples of positive behaviors that can help limit harassing situations
  • Discuss the legal implications of sexual harassment and the employer’s legal responsibilities
  • Describe your federal protections through the EEOC and available remediation options, and define retaliation and describe your rights when it comes to protected behavior
  • Describe strategies for constructively addressing conflict and building positive relationships at work including three approaches to bystander intervention and specific ways you can help reduce harassment at your workplace
  • Describe approaches for designing a workplace harassment policy and communicating it effectively
  • Read More

Objectives – You will be able to:

  • Describe the prevalence of sexual harassment in the workplace and its impacts on the workplace
  • List examples of behavior that may be considered sexual harassment as well as examples of positive behaviors that can help limit harassing situations
  • Discuss the legal implications of sexual harassment and the employer’s legal responsibilities
  • Describe your federal protections through the EEOC and available remediation options
  • Read More

Objectives – You will be able to:

  • Describe the threats from cybercriminals which target your devices and yourself
  • Define cybersecurity terms including phishing, vishing, ransomware, sextortion, social engineering, and botnets
  • List benefits cybercriminals hope to achieve by attacking people and devices
  • Describe the role played by hardware, software, priviliege level, and updates in protecting your computer
  • Identify at least three characteristics of a “strong” password
  • Explain the 3-2-1 backup strategy and how it protects from ransomware
  • List at least three ways criminals hope to get access to your computer
  • Discuss the role of clickbait and social engineering in cybersecurity attacks… more

Objectives – You will be able to:

  • Explain how the body reacts in certain situations
  • Define Safe, Secure, and Survive
  • Describe how a plan works… more

Microsoft Office 2019

Objectives – You will be able to:

  • Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
  • Perform calculations using formulas and functions
  • Insert and delete rows and columns
  • Apply formatting to text, numbers, and cells including Conditional Formatting, Comparative Analysis Formatting, Cell Styles, and Themes
  • Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
  • Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
  • Use multiple View features to compare multiple workbooks, compare worksheets, or save Custom Views.
  • Customize your instance of Excel including adding Groups to the Ribbon and modifying the Quick Access Toolbar… more

Objectives – You will be able to:

  • Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
  • Perform calculations using formulas and functions
  • Insert and delete rows and columns
  • Apply formatting to text, numbers, and cells including Conditional Formatting, Comparative Analysis Formatting, Cell Styles, and Themes
  • Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
  • Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
  • Use multiple View features to compare multiple workbooks, compare worksheets, or save Custom Views.
  • Customize your instance of Excel including adding Groups to the Ribbon and modifying the Quick Access Toolbar… more

Objectives:
• Create and use named ranges
• Insert functions into spreadsheets including: Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
• Sort and filter column data
• Create and modify tables, and apply advanced Conditional Formatting
• Create and modify charts and graphics
• Apply advanced charting tools
• Create a Pivot Table to group and summarize data
• Apply advanced Pivot Table features, create a Pivot Chart, and filter data using Slicers and Timelines.. more

Objectives:
• Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using features like cell links, Group Mode, 3D Reference formulas, and Consolidate.
• Collaborate with others using Comments, Track Changes, Sharing, Co-Authoring, and Compare and Merge.
• Prepare a document for sharing by checking for accessibility and sensitive information, as well as multiple ways to protect your worksheets and workbooks from changes.
• Keep your data consistent and accurate with Data Validation and automate tasks with Macros.
• Perform complex calculations by developing a deep understanding of Excel’s Lookup functions like VLOOKUP, MATCH, and INDEX.
• Quickly find and address errors in your formulas with Tracing, Evaluate Formula, and the Watch Window, as well as add error handling with the IFNA and IFERROR functions.
• Use your data to plan and forecast trends and explore a variety of outcomes based on variables and scenarios.
• Visualize geographic data with Map Charts and 3D Map Tours… more

Objectives – You will be able to:

  • Navigate the Outlook 2019 interface and send, reply to, forward, and print emails.
  • Send and receive attachments from your local drive and online locations.
  • Access Help options including searching for articles and training videos and contacting support, as well easily locating features through searching.
  • Professionally format your emails by using text formats, pictures, illustrations, Styles, and Themes, as well as applying automatic formatting to emails.
  • Customize your view in a way that works best for you to read and organize your emails.
  • Get organized with categories, flags, and folders.
  • Create appointments, events, and meetings, and learn to manage multiple calendars.
  • Manage your contact lists and tasks within the Outlook interface.
  • Modify Message Properties to set the Importance or Sensitivity, or to adjust delivery options like having replies sent to someone else.
  • Customize your instance of Outlook to work for your preferences by setting a start folder, customizing the ribbon, adding commands to the Quick Access Toolbar, creating custom views with sorting and filtering, and creating Search Folders.
  • Automate message management with Automatic Replies, Conditional Formatting, Rules, and Quick Steps.
  • Manage multiple calendars including customized work days and hours and Calendar Groups.
  • Manage your contacts including sharing contacts with others.
  • Delegate by assigning tasks or delegating access to your Outlook folders.
  • Collaborate with others by sharing your Contacts or Calendars.
  • Describe the difference between Auto-Archive and Online Archive and manage the settings for either… more

Objectives:
• View and navigate a presentation
• Group, arrange, and animate objects
• Add and modify tables, charts, pictures, and shapes
• Apply transitions and animations.. more

Objectives:
• Customize the interface and update options
• Modify Slide Masters, Notes Masters, and Handout Masters
• Insert advanced graphics like SmartArt, 3D models, SVGs, and icons
• Add media to your presentation (audio and video)
• Add advanced Animations and Transitions including Slide Timing
• Collaborate with others using Share, Comments, Compare & Merge, and Forms
• Customize your slide show with Captions and Subtitles, Translation, Dictation, and Hyperlinks
• Record and distribute your presentations.. more

Objectives:
• Navigate the Word interface
• Create and save documents
• Access commands and select and enter text
• View multiple documents and customize your version of Word
• Format your document including character formatting, paragraph layout, spacing, and alignment
• Create and format lists and tables including sorting and converting text to a table
• Use search, find and replace, repetitive formatting, and Styles
• Insert graphics and symbols
• Print using Page Layout options such as page breaks, headers, and footers
• Check spelling and readability
• Use research tools and checking accessibility… more

Objectives – You will be able to:

  • Demonstrate how Outlook integrates with OneDrive for attachments
  • Describe the function of the Focused Inbox
  • Insert SVG images and Icons into email messages
  • Discuss new calendar and accessibility features… more

Objectives – You will be able to:

  • Demonstrate using the new 3D model images in Word documents
  • Use the new Dictate function to add text in a Word document
  • Discuss the use of the Editor and Researcher tools.. more

Objectives – You will be able to:

  • Describe the new IFS, TEXTJOIN, and SWITCH functions
  • Demonstrate the new Ink Tools including Ink to Shape and Ink Replay
  • Discuss the changes to Cut/Copy and Selection features.. more

Objectives – You will be able to:

  • Describe what’s new and useful in the latest version of PowerPoint.
  • Use the Morph transition for more effective presentations.
  • Insert and modify 3D models including using the Morph transition to animate.
  • Insert and modify vector graphics.
  • Draw freehand with digital ink and modify drawn objects including converting drawings to text and shape objects and using the new digital ruler.
  • Use the new Zoom feature to create interactive navigation within your presentation.
  • Record a slideshow presentation with timing and narration for sharing.
  • Use the Translation, Dictation, and Accessibility features… more

Objectives:

  • Identify multiple ways to initiate or join a Teams call or meeting
  • Discuss in-meeting controls including turning video and microphones on and off, showing the people pane, sending a meeting invitation to others, and using the lobby feature
  • Describe how Microsoft Teams can be used to share screens, App windows, PowerPoint presentations, and whiteboards during a Teams meeting
  • Discuss best practices for holding meetings in Microsoft Teams.. more

Microsoft Office 2016

Objectives – You will be able to:

  • Navigate within Microsoft Access
  • Create an Access database
  • Use Access help and set configuration options
  • Efficiently locate and change data
  • Sort and filter records in a table
  • Create a query
  • Sort and filter data through a query
  • Perform calculations through a query
  • Create a form
  • Work with data in a form
  • Create a report
  • Add a control to a report
  • Apply themes, fonts, and layout options to a report
  • Prepare a report to be printed
  • Organize report information
  • Format a report.. more

Objectives – You will be able to:

  • Design a relational database
  • Join tables to retrieve data from unrelated tables
  • Validate data entered into a database
  • Use advanced queries to manipulate your data
  • Organize a database for efficiency and performance, and to maintain data integrity
  • Customize reports to organize the displayed information and produce specific print layouts.. more

Objectives – You will be able to:

  • Demonstrate how to navigate the ribbon
  • Discuss the compatibility issues between Excel 2016 and older versions of Excel
  • Explain the importance of named ranges
  • Write nested functions
  • Demonstrate advanced functions
  • Define and develop macros.. more

Objectives – You will be able to:

  • Explain the hierarchy of organization of your notebook.
  • Demonstrate the different ways to organize your information
  • Create pages and subpages
  • Identify the different ways to format your notes
  • Discuss how to link to different pages and/or notebooks in your notes.. more

Objectives – You will be able to:

  • Demonstrate how to send a new email
  • Identify the buttons on the ribbon
  • Discuss how to add an attachment to your email
  • Explain the different advanced characters and objects
  • Organize messages with groups
  • Find emails using the search bar.. more

Objectives – You will be able to:

  • Demonstrate how to view and navigate a presentation
  • Modify pictures and shapes
  • Describe how to group, arrange, and animate objects
  • Summarize how to customize the user interface
  • Use headers and footers
  • Illustrate how to add video and audio to a presentation… more

Objectives – You will be able to:

  • Demonstrate basic formatting and text effects
  • Use text selection and mini toolbar
  • Illustrate how to insert symbols, pictures, and characters
  • Demonstrate how to insert blank and cover pages
  • Apply custom list and table styles
  • Use advanced mail merge
  • Demonstrate how to insert video and screenshots
  • Summarize the process of sharing documents
  • Modify and use forms
  • Create and use macros… more

Objectives – You will be able to:

  • Describe the use of SmartArt to illustrate documents and spreadsheets
  • Use the Goal Seek function to analyze data in Excel
  • Create and manage animation triggers in PowerPoint.. more

Microsoft Office 2013

Objectives – You will be able to:

  • Demonstrate navigating around the Access Interface
  • Explain the relationship between Tables, Records, and Forms in Access
  • Describe how Access can be used to create web-based applications… more

Objectives – You will be able to:

  • Demonstrate navigating around the Excel Interface
  • Explain the relationship between Workbooks, Worksheets, rows, columns, cells, and named ranges
  • Describe how to create and use Pivot Tables and Pivot Charts.. more

Objectives – You will be able to:

  • Describe the relationship between notebooks, sections, section groups, and pages
  • Save and share OneNote notebooks
  • Demonstrate the use of handwriting recognition in OneNote
  • Discuss the use of the Quick Filing feature.. more

Objectives – You will be able to:

  • Distinguish between HTML and plain text options
  • Discuss how to add attachments to emails
  • Use search tools
  • Create new contacts
  • Explain how to set and modify appointments using the calendar
  • Create, format, and insert a customized signature in your emails
  • Describe the purpose of an Information Rights Management service
  • Demonstrate how to add additional email addresses to Outlook
  • Explain how to delete messages and clean up folders
  • Integrate social media, such as Facebook, to your Outlook.. more

Objectives – You will be able to:

  • Move, Resize, and Nudge photos on slides
  • Create custom slideshows for a presentation
  • Create custom shapes
  • Loop, crop, and add fades to video embedded in a PowerPoint presentation.. more

Objectives – You will be able to:

  • Create, Save, and Find Documents
  • Navigate around in the Word 2013 interface
  • Adjust Margins, Columns, and Text Boxes
  • Describe how to implement Footnotes, Hyperlinks, and Table of Contents
  • Describe the use of Redlining and Tracking Changes in documents
  • Discuss the use of Mailmerge, Form Fields, and Digital Signatures… more

Objectives – You will be able to:

  • Describe the use of the Ribbon in Office 2013 applications
  • Discuss the changes to the file types in Office 2013
  • List formatting enhancements in Office 2013… more

Objectives – You will be able to:

  • Describe the new functions
  • Demonstrate Pivot Charts
  • Explain Power View.. more

Objectives – You will be able to:

  • Describe the new backstage view
  • Demonstrate the wrapping text function
  • Summarize how to size graphics.. more

Objectives – You will be able to:

  • Explain background notes
  • Demonstrate new transitions and animations
  • Illustrate how to insert pictures… more

Microsoft Office 2010

Objectives – You will be able to:

  • Create and manipulate worksheets
  • Demonstrate the different ways to copy and paste data
  • Organize spreadsheets to increase productivity.. more

Objectives – You will be able to:

  • Illustrate how to change slide designs
  • Demonstrate how to add SmartArt, pictures, shapes, and videos
  • Modify and use animation options, pane, painter, and triggers.
  • Explain the process of converting videos to WMV format
  • Use headers and footers.. more

Objectives – You will be able to:

  • Explain the status bar and view options
  • Describe different document types
  • Modify margins, orientation, and paper size.. more

Office 365

  • Básicos del correo electrónico de Outlook, parte 1
  • Básicos del correo electrónico de Outlook, parte 2
  • Busqueda de correos electrónicos y filtros
  • Carpetas de correo electrónico
  • Read More…

Objectives – You will be able to:

  • Aprender cómo Planner puede administrar su carga de trabajo
  • Uso de funciones como planes, tarjetas, cubos y etiquetas
  • Aprender cómo funciona Planner con la aplicación Groups de Office 365
  • Crear tareas y asignarlas a otros
  • Revisar los plazos y el progreso con los gráficos y el panel
  • Read More…

Objectives – You will be able to:

  • Navigating within documents using shortcuts 
  • Creating, saving, and printing documents 
  • Selecting, copying, and moving text 
  • Using Find, Replace, and Go To 
  • Formatting text 
  • Applying Styles 
  • Read More…

Objectives – You will be able to:

  • Navigating the Word interface 
  • Navigating within a Word document 
  • Creating and saving documents 
  • Getting help 
  • Formatting text 
  • Selecting, copying, and moving text 
  • Read More…

Objectives – You will be able to:

  • Managing rows, columns, and worksheets 
  • Creating and using named ranges 
  • Adding logical and conditional functions 
  • Addressing formula errors 
  • Applying cell and number formats, including cell styles and themes 
  • Modifying charts 
  • Read More…

Objectives – You will be able to:

  • Using Flash Fill, Text to Columns, and Group Mode to work with your data 
  • Using editing features such as Find and Replace, proofing options, and research tools to refine your workbook 
  • Modifying workbook views 
  • Applying conditional formatting to text, numbers, and dates 
  • Applying custom number formatting 
  • Read More…

Objectives – You will be able to:

  • Sharing personal and additional calendars with others
  • Using Office 365 groups or Shared Mailboxes to share calendars and email
  • Publishing Calendars to the internet
  • Delegating access to your calendars or email folders to a coworker
  • Read More…

Objectives – You will be able to:

  • Using basic functions of Calendar, To Do, and People inside Outlook online
  • Changing Calendar views, customizing, and sharing.
  • Creating, editing, and responding to meetings and events.
  • Searching and printing calendars.
  • Creating and viewing tasks in Outlook and To Do
  • Read More…

Objectives – You will be able to:

  • Understanding Microsoft 365
  • Setting up email & Outlook on the Web
  • Getting organized with flags, tags, folders, and categories
  • Staying focused with Focused Inbox
  • Storing, sharing, and collaborating on files with OneDrive & SharePoint
  • Communicating with Teams, Yammer, and Kaizala
  • Using Microsoft 365 mobile apps
  • Read More…

Objectives – You will be able to:

  • Using basic email functionality
  • Organizing your information with Search and Folders
  • Tagging items with Categories and Mentions
  • Using built-in tools to keep your inbox clean with Focused Inbox, Sweep, and Clutter
  • Creating Signatures and Automatic Replies
  • Read More…

Objectives – You will be able to:

  • Email and Calendar basics
  • Email folders, categories, and mentions
  • Focused Inbox, email archive, automatic replies and signatures
  • Microsoft To Do and MyDay
  • OneDrive basics
  • OneDrive file sharing, sync, and co-authoring
  • Read More…

Objectives – You will be able to:

  • Discuss the benefits of Office 365
  • Describe the use of Teams, Groups, Planner, OneDrive, and Skype for Business
  • List at least six mobile apps which work with Office 365.. more

Objectives – You will be able to:

  • Describe the role and function of Microsoft Teams
  • Create and Manage Teams and Channels
  • Describe the difference between Channel Conversations and Chat Conversations
  • Identify uses for Chatbots, Shifts, and Praise
  • Discuss how to start scheduled or ad-hoc Meetings
  • Setup and Edit a Wiki
  • Add custom tabs to Channels and Chats
  • Use Documents and Apps in Channels
  • Describe the function of Connectors
  • Discuss using the Calls feature of Teams as a phone system
  • Discuss the use of external users (guests) in Teams, including limitations… more

Objectives – You will be able to:

  • Discuss the role and purpose of Microsoft Forms
  • Differentiate between the types of forms available for use
  • Create a basic form using Microsoft Forms
  • Create a basic quiz or survey
  • Explain the purpose of branching and describe when to use it
  • Explain how to set rules and parameters
  • Explain the different ways to share a form
  • Customize a Microsoft Form using the “Themes” feature
  • Explain how to gather, view, and share information collected.. more

Objectives – you will be able to:

  • Create Teams and Channels
  • Use Chat
  • Create Online Meetings
  • Describe Best Practices for Teams, Channels, Notifications, Files, Chat, and Meetings.. more

Objectives – You will be able to:

  • Describe the Microsoft To-Do App
  • Explain the My Day feature, and how to add To Do’s to My Day
  • Create Multiple To-Do Lists to Organize Your Tasks.. more

Objectives – You will be able to:

  • Discuss the different options in Office 365 packages
  • Demonstrate how to navigate around Office 365
  • Discover files in OneDrive with the search feature
  • Change your presence indicator
  • Use Skype for Business to do video calls, audio calls, and screen share… more

Objectives – You will be able to:

  • Describe how to access Groups through Outlook and the Outlook Web App
  • Use the Scheduling Assistant to find convenient meeting times for all Group members
  • Share files with the Group via web, email, and OneDrive
  • Access the Group Notebook from the web or OneNote
  • Discuss how to use Connectors to add information from outside sources.. more

Objectives – You will be able to:

  • Discuss the relationship between Plans, Cards, Buckets, and Labels
  • Describe how Planner works with the Office 365 Groups app
  • Create Tasks and Assign them to others
  • Review deadlines and progress with Charts and the Dashboard.. more

Objectives – You will be able to:

  • Describe the difference between OneDrive, OneDrive for Business, and SharePoint Document Libraries
  • Demonstrate how to access, edit, and share your files from the web version of OneDrive for Business
  • Access OneDrive documents from inside Microsoft Office apps on your PC, Mac, or mobile device
  • Use Versioning and the 2-stage Recycle Bin to recover files
  • Control permissions for shared OneDrive files.. more

Objectives – You will be able to:

  • Start a chat (Instant Message) session using the Skype for Business app
  • Initiate audio and video calls using Skype for Business
  • Share an interactive whiteboard
  • Set the Presence indicator and Personal Message in Skype for Business.. more

Objectives – You will be able to:

  • Discuss the basic use of Document Libraries
  • Describe the typical uses for Team Sites and Communication Sites
  • Explain the difference between Major Versions and Minor Versions
  • Describe the use of Check In, Search, the Recycle Bin, and List Apps in SharePoint.. more

Objectives – You will be able to:

  • Describe the function of SharePoint in Office 365
  • Discuss the differences between Team Sites and Communication Sites
  • Create a SharePoint Site
  • Add Pages to a SharePoint Site.. more

Objectives:
• Demonstrate how to navigate around Office 365
• Discuss the use of core Office 365 features such as Outlook Email, Calendars, Microsoft To Do, OneDrive, and the Office Online apps
• Identify key Microsoft Office mobile apps and their function
• Use Office 365 Search and Help tools.. more

Objectives:
• Navigate the Microsoft 365 Admin Center and configure settings and security for Microsoft Teams, OneDrive, Exchange, and SharePoint
• Manage users and groups, including Dynamic (self-managing) groups
• Describe the importance of Break Glass global admin accounts
• Manage and properly license Shared Mailboxes including converting a Regular Mailbox to a Shared Mailbox for offboarding purposes
• Push configuration changes and add-ins to users, and update settings to limit what people can share externally
• Secure access to your tenant with multi-factor authentication (MFA) and password policies, and secure email traffic in your tenant with DKIM, SPF, and DMARC policies
• Enhance the security of your Azure AD environment by branding your site, limiting what users can do in Azure AD, enabling Conditional Access Policies, accessing Audit Lots, and monitoring Secure Scores
• Use Security Baselines to quickly set up device configuration policies, access and review device compliance policies, and describe the purpose of AutoPilot in automatically deploying and configuring devices
• Configure Advanced Threat Protection with Anti-Phishing, Safe Attachment, Safe Links, Anti-Spam, and Anti-Malware policies, and conduct a Message Trace to investigate undelivered email.. more

Microsoft Other

Objectives – you will be able to:

  • Crear un Equipo o un Canal
  • Evitar la duplicación de nombres de Canales o Equipos
  • Usar Pestañas para conectarse a aplicaciones clave
  • Consejos de aprendizaje para usar la búsqueda
  • Usar notificaciones para alertarlo sobre Conversaciones y Eventos
  • Editar un documento en Teams
  • Read More…

Objectives – you will be able to:

  • Unirse a una reunión desde un canal, calendario o invitación por correo electrónico 
  • Iniciar una llamada o una reunión 
  • Personalización de sus opciones de cámara y audio 
  • Gestión de distracciones de audio y video de fondo 
  • Uso de controles en la reunión para administrar su reunión y los asistentes 
  • Read More…

Objectives – you will be able to:

  • Navegación por la interfaz de Outlook Online 
  • Uso de las funciones básicas del correo electrónico y el calendario de Outlook 
  • Organizar tu información con búsqueda y carpetas 
  • Uso de categorías y menciones para etiquetar elementos 
  • Compartir calendarios y carpetas de correo electrónico 
  • Uso de firmas y respuestas automáticas 
  • Read More…

Objectives – you will be able to:

  • Describe the role and function of Microsoft Teams 
  • Create and manage Teams and Channels 
  • Start and manage scheduled or ad-hoc Meetings 
  • Work with files including uploading, editing, and sharing 
  • Add custom tabs to Channels and Chats including files and Apps 
  • Read More…

Objectives – you will be able to:

  • Discussing the role and purpose of Microsoft Forms
  • Learning types of forms available for use
  • Creating a basic form
  • Creating a basic quiz or survey
  • Creating a poll and using it in a Teams chat or meeting
  • Sharing a form
  • Read More…

Objectives – you will be able to:

  • Creating floor plans and room diagrams 
  • Creating and modifying cross-functional flowcharts 
  • Creating network diagrams 
  • Working with shape data 
  • Using layers and containers 
  • Modifying styles, themes, and page backgrounds 
  • Read More…

Objectives – you will be able to:

  • Using Quick Steps
  • Creating reusable text, searches, and rules to automate things you do often.
  • Using color, rules, and the task list to highlight and make email easier to manage and organize
  • Read More…

Objectives – you will be able to:

  • Defining dynamic array functions 
  • Listing the characteristics of dynamic arrays  
  • Using the seven new dynamic array functions  
  • Listing the benefits of using dynamic arrays
  • Read More…

Objectives – you will be able to:

  • Create a pivot table from a local data source, multiple local data sources, and external sources
  • Organize data within a pivot table
  • Modify pivot table options.. more

Objectives – You will be able to:

  • Use range names in formulas
  • Create nested functions
  • Work with forms, form controls, and data validation
  • Use lookup functions
  • Combine multiple functions
  • Create, modify, and format charts
  • Use sparklines, trendlines, and dual-axis charts
  • Create a PivotTable and analyze PivotTable data
  • Present data with PivotCharts
  • Filter data with slicers.. more

Objectives – You will be able to:

  • Enable the Power Pivot add-in and navigate its interface
  • Manage Data Relationships
  • Create a Power Pivot Report
  • Create calculations in Power Pivot
  • Create a Key Performance Indicator
  • Work with dates and time in Power Pivot.. more

Objectives – you will be able to:

  • Enter Data
  • Use Formulas and Functions
  • Create and Use Relative, Absolute, and Worksheet references
  • Modify Cells, Columns, and Rows
  • Use Find and Replace
  • Apply Text Formatting and Number Formats
  • Use Styles and Themes
  • Apply Conditional Formatting
  • Create Templates
  • Setup Page Layout
  • Use Custom Views.. more

Objectives – You will be able to:

  • Manage multiple worksheets within one workbook
  • Describe the elements of a Project Charter
  • Create linked fields between worksheets
  • Describe the parts of a clear and concise requirement
  • Insert a table into a worksheet
  • Create a dropdown list for data consistency
  • Negotiate requirements using the triple constraint
  • Add conditional formatting or icons to a column to call attention to important rows
  • Define Work Breakdown Structure (WBS)
  • Describe how to split work into work packages
  • Relate requirements to tasks using cross-references
  • Create a pivot table to summarize your task data
  • Describe the process to identify and manage project risks
  • Prioritize risk management and determine risk response using probability and impact
  • Create summary data at the top of a worksheet
  • Track stakeholder contact information and their communication needs and preferences
  • Filter stakeholder data with slicers to create a project communications plan.. more

Objectives – You will be able to:

  • Locate the syntax of an Excel function and explain the basics of function syntax design.
  • Describe how Excel functions use True/False evaluations based on criteria.
  • Write an Excel function that uses wildcards.
  • Describe the syntax and write an Excel function using the following functions:
    • DATEDIF
    • EDATE
    • EOMONTH
    • CONVERT
    • INDEX + MATCH
    • OFFSET
    • COUNTA
    • SUMPRODUCT
  • Create nested functions using multiple Excel functions in one cell calculation.
  • Determine anniversary dates using EDATE, DATEDIF, and EOMONTH.
  • Convert units using the CONVERT function (e.g., miles to kilometers).
  • Find a value in a large array of data using the combination of INDEX and MATCH.
  • Debug or trace through an Excel formula using the “Evaluate Formula” feature or the Excel Formula Beautifier online tool.
  • Create a rolling average using the OFFSET function or OFFSET and MATCH.
  • Calculate totals and subtotals using SUMPRODUCT and describe how this can be used as an alternative to pivot tables… more

Project Management

Objectives – You will be able to:

  • Outline characteristics of a project
  • Create a project schedule, communication plan, and a final report
  • Describe skills of a project manager.. more

Objectives – You will be able to:

  • Navigate though the Microsoft Project interface
  • Create a new project plan
  • Add and schedule tasks to a project plan.. more

Objectives – You will be able to:

  • Manage and update task progress with SharePoint
  • Create custom fields and views
  • Analyze a project plan
  • Construct custom and visual reports.. more

Essentials

Objectives – You will be able to:

  • Understanding the basics of Windows 11, including versions and user account types
  • Navigating Windows 11, including the desktop, Start Menu, Task Bar, and Action Center
  • Managing your files with the File Explorer and the Quick Access option
  • Using Snap, Task View, and Virtual Desktops to organize your windows
  • Customizing Windows 11 for your personal workflow
  • Read More…

Objectives – You will be able to:

  • How to use the automatic proofreading tools available in Microsoft Word.
  • Understanding the differences between editing and proofreading.
  • The process for efficient, productive proofreading.
  • Avoiding the common errors in punctuation, nouns, and formatting and avoiding them.
  • Read More…

Objectives – You will be able to:

  • Demonstrate use of the Gmail interface
  • Compare and contrast labels and folders
  • Describe how to add and use Inbox Pause, HelloSign, and Boomerang in Gmail.. more

Objectives – You will be able to:

  • Compose documents in Google Docs
  • Manage Schedules and Tasks with Google Calendar
  • Describe how to store files in Google Drive.. more

Objectives – You will be able to:

  • Describe how to navigate through a PDF Document
  • Construct a PDF Portfolio
  • Change the size of a PDF document.. more

Objectives:

  • Describe the purpose of Google Workspace and identify features that are common across Google apps
  • Access Gmail, Google Contacts, and Google Calendar to manage email and contacts and create events
  • Access your Google Drive to upload and share documents, and create new Google files from Drive
  • Create Google Docs, Google Sheets, Google Slides, Google Forms, and Google Sites and use basic features like formatting, commenting, version history, sharing, working offline, and publishing to the web
  • Store your photos in Google Photos, automatically sync photos and videos from your phone, and use powerful companion apps like PhotoScan and Google Lens
  • Access less common apps like Google Jamboard, Google Keep, Google Drawings, and Google Translate
  • Connect with friends and contacts via chat, video, or phone using Google Hangouts and Google Meet
  • Use file management systems like Google Drive File Stream and Shared Drives.. more

Objectives – You will be able to:

  • Describe how Power BI enables real-time data sharing and reports by connecting directly to external data sources, including Excel
  • Manage data relationships within Power BI including create, modify, and delete
  • Create a set of applied steps to clean a data source including changing data types, modifying field names, and splitting and merging columns
  • Create and customize visualizations to display your data including formatting, sorting, and filtering
  • Format report pages including text, shapes, and images
  • Create calculated columns using Data Analysis Expressions (DAX) for both strings and numbers
  • Create explicit measures and add measures to visualizations
  • Create interactive reports using real-time filters, hierarchies, and slicers
  • Publish a report to the Power BI Web App and create multiple dashboards specific to different audiences.. more

Objectives – You will be able to:

  • Describe how to use the new Start Screen
  • Apply touch enabled features on Windows 8
  • Duplicate mouse commands to navigate through Windows 8 more effectively.. more

Objectives – You will be able to:

  • Add and edit contacts in Lync (Skype for Business)
  • Start and end audio and video calls in Lync
  • Recording calls and conversations in Lync.. more

Objectives:
• Log into Salesforce and navigate the interface including Apps and Items (Tabs)
• Describe most common objects in Salesforce: Leads, Accounts, Contacts, and Opportunities
• Create and manage Leads
• Track activities such as phone calls, planned events, deadlines, and emails related to a Salesforce object (e.g., a Lead, an Opportunity).
• Convert a Lead into an Account, Contact, and Opportunity
• Create and edit Opportunities including progressing through the stages of the sale
• Create your own List Views and mark records as Favorites so you can quickly see the records most important to you
• Search your Salesforce records including using wildcards to search partial values.. more

Objectives:
• Describe the purpose and benefits of Google Drive and navigate the Google Drive interface
• Describe the difference between Google format and non-Google format files
• Create and navigate folders and use the “Convert uploads” setting to determine whether uploaded files will be converted to Google format
• Open and edit files including Microsoft Word documents using Google Docs
• Pull text out of a PDF, delete files and restore a file from trash
• Edit files while offline and sync the changes when you reconnect to the internet
• Share files and folders with others by making people collaborators, sharing links, and sending files with Gmail
• Sync Drive folders and files to your computer and explain benefits of file syncing
• Use the Drive app to access and edit files on a phone or tablet and scan documents using an Android phone.. more

Extras

Objectives:

  • Determinar cuándo enviar un email y cuándo utilizar otra forma de comunicación. 
  • Redacción de emails profesionales con seis mejores prácticas 
  • Enumerar las 4 Ces de la buena escritura: Claro, Conciso, Completo Y Correcto 
  • Identificar su propósito y verificar que su email sea compatible con ese propósito 
  • Eliminar información adicional 
  • Read More…

Objectives:

  • Definir empatía y explicar la diferencia entre empatía y simpatía. 
  • Explicar la importancia de la empatía en el desarrollo de la inteligencia emocional. 
  • Desarrollar una lista de emociones típicas del entorno. 
  • Reconocer y comunicar la conciencia de lo que otra persona siente mediante la empatía. 
  • Definir la ciber-desinhibición e identificar métodos para reducir su impacto en la empatía. 
  • Concéntrese en escuchar activamente al notar el lenguaje corporal, el tono de voz y las palabras. 
  • Read More…

Objectives:

  • Transmitir que está escuchando mediante declaraciones breves (señales verbales) y lenguaje corporal. 
  • Buscar acuerdo y entendimiento usando una fórmula simple de declaración de clarificación. 
  • Generar confianza al proporcionar un entorno de escucha seguro y sin distracciones 
  • Usar preguntas apropiadas para comprender el mensaje del orador. 
  • Concentrarse en el orador prestando atención al lenguaje corporal 
  • Expresar empatía y brindar información para ayudar al orador a comprender mejor su situación. 
  • Read More…

Objectives:

  • Creating a new Smartsheet
  • Customizing columns
  • Add tasks and hierarchies
  • Using conditional formatting
  • Attaching files and links
  • Creating formulas
  • Read More…

Objectives:

  • Identify the appropriate settings for engaging meetings.
  • Share a presentation from a desktop, laptop, or tablet.
  • Use the Whiteboard to promote attendee participation and community outcomes.
  • Poll your attendees to encourage active participation and elicit feedback.
  • Assign attendees to breakout rooms for small-group collaboration and discussion and then communicate with or visit the rooms.
  • Create a fun, engaging, and effective virtual meeting environment.. more

Objectives:
• Decide when it’s best to write an email versus using another form of communication, and explain how the increase in email usage has led to too many emails.
• Ensure your emails are professional by paying attention to six best practices like reviewing before sending and writing an informative subject line.
• Write clear emails by identifying your purpose and checking that your email supports that purpose.
• Write concise emails with clearly communicated key points and no extra information.
• Write complete emails using six questions that will ensure your email includes all necessary information.
• Write correct emails using four steps to identify and fix common mistakes… more

Objectives:
• Share a workspace safely and effectively with your coworkers.
• Create an environment of open communication about employee health that encourages people to take care of themselves.
• Describe ways to limit the spread of germs in office hotspots like the breakroom, bathroom, and general office area.
• Understand the importance of having your own equipment even when sharing spaces with coworkers.
• List common government guidelines for keeping an office area clean and disinfected.
• Describe how a neater office space can improve both physical and mental wellbeing… more

Objectives:
• Describe why it’s easy to not listen and why it’s important to work at being a good, active listener
• Convey that you are listening using short statements (verbal cues) and body language
• Seek agreement and understanding using a simple clarifying statement formula
• Build trust by providing a safe and distraction-free listening environment
• Use appropriate questions to understand the speaker’s message
• Focus on the speaker by paying attention to body language
• Express empathy and provide input to help the speaker better understand their situation.. more

Objectives:
• Define empathy and explain the difference between empathy and sympathy
• Explain the importance empathy plays in developing emotional intelligence
• Develop a list of emotions typical to the environment
• Recognize and communicate an awareness of what someone else is feeling using empathy
• Define cyber-disinhibition and identify methods to reduce its impact on empathy
• Focus on active listening by noting body language, voice tone, and words.. more

Objectives – You will be able to:

  • Define basic SQL terminology and list the seven types of clauses in an SQL statement.
  • Write an SQL query that retrieves data from one table.
  • Clean your query results by sorting, filtering, and adding column aliases.
  • Use the WHERE clause to filter results based on comparisons to numbers and strings.
  • Write an SQL query that retrieves data from multiple tables using inner joins and WHERE clause joins.
  • Use outer joins to retrieve results where one of the tables does not have matching records.
  • Use date functions to format dates in your results (DATEPART, DATENAME) and to calculate the difference between two dates (DATEDIFF).
  • Concatenate columns using string functions (+, TRIM) and summarize a column using aggregate functions (SUM, AVG)
  • Collect data across multiple records and group the results using the GROUP BY clause and filter based on grouped data using the HAVING clause.
  • Use subqueries to retrieve more complex results that cannot be achieved with a single SQL query.. more

Objectives – You will be able to:

  • Create a SharePoint site.
  • Create subsites to make it easy for members of different teams to quickly access the information important to them.
  • Add a document library to your SharePoint site for your team to share, modify, and track shared documents of all file types.
  • Manage version control within your document library; enable users to manage multiple versions and avoid conflicts.
  • Guide your team in setting up customized alerts for changes in SharePoint that are important to their work.
  • Design a custom list in SharePoint where your team can track and manage shared data records.
  • Guide your team in importing Excel files that are shared among the group into a SharePoint list for easier management and collaboration.
  • Customize your site for branding and to make it easy for your users to quickly get to the information they need.
  • Assign user permissions at both the site and item levels… more

Objectives:
• Describe the power of a schedule in organizing your day to focus on important tasks, and explain how getting started can be the key to tackling big to-do items
• Explain how accountability partners and systems can help you avoid blame and shame and improve how you spend your time
• Describe how practicing forgiveness for your coworkers and having a short memory for your own mistakes can improve productivity and provide a wealth of health benefits
• Master the “Graceful No” to clarify priorities and focus on productivity over being busy
• Describe how decluttering your workspace and minimizing distractions can create a productive work environment, and how automating some of your decisions can limit Decision Fatigue
• Reframe the stories you tell yourself about failures and setbacks, so you can move forward
• Make the most of your time spent on communications like email
• Learn how small changes can make for better, more productive meetings
• Describe how perfectionism is often due to fear of failure, and how embracing “good enough” can lead to better results.. more

Objectives – You will be able to:

  • Describe what data series and data tables are in Excel
  • Illustrate how to use animation triggers in PowerPoint
  • Modify themes and styles in Word.. more

Objectives – You will be able to:

  • Improvements in Clip Trimming, 4 Point Editing, Sub-sequences, Master Clips, and the Project Panel in Premiere Pro
  • Better Integration between Premiere Pro and Audition
  • Access Creative Cloud Libraries in Premiere Pro and After Effects
  • Describe the benefits of the Lumetri Color Panel
  • Apply Premiere Pro’s new Morph Cut
  • Improvements Exporting, Time Tuning, and more in Premiere Pro
  • The “under-the-hood” improvements to the After Effects engine
  • The new Adobe Character Animator
  • Improvements to Expressions and 3D Character Animation
  • Using mobile apps Adobe Hue, Premiere Clip, Adobe Color, and the Adobe CC Libraries to improve creativity and collaboration… more

Objectives – You will be able to:

  • Describe the use of Sway
  • Create a new Sway
  • Add Cards and Groups to a Sway
  • Insert media and other content types in your Sway
  • Discuss different ways to host and share your Sway.. more

Objectives – You will be able to:

  • Discuss the basic use of Document Libraries
  • Explain the difference between Document Libraries and Picture Libraries
  • Describe the use of Search, the Recycle Bin, and Calendars in SharePoint.. more

TOSA

Objectives:
• Customize your instance of Excel including adding Groups to the Ribbon and modifying the Quick Access Toolbar
• Use a wide variety of functions including: Logical functions, Text functions, Conditional functions, Lookup functions, Math functions, Database functions, Subtotals, and nested functions
• Create a Pivot Table to group and summarize data
• Apply advanced Pivot Table features and create a Pivot Chart
• Collaborate with others using Co-Authoring
• Quickly find and address errors in your formulas with Tracing, Evaluate Formula, and the Watch Window, as well as add error handling with the IFNA and IFERROR functions
• Use your data to plan and forecast trends and explore a variety of outcomes based on variables and scenarios
• Provide quick and easy access to navigate, modify, and enter data using Forms and Form Controls, including ActiveX Controls.. more

Objectives:
• Create and use named ranges
• Insert functions into spreadsheets including: Date and Time functions, Conditional functions, Database functions, Lookup functions, and Subtotals
• Perform custom and advanced filtering
• Apply advanced charting tools and create a chart template
• Create a Pivot Table and apply advanced Pivot Table features, as well as filter data using Slicers and Timelines
• Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using features like cell links and Consolidate
• Collaborate with others using Co-Authoring and Compare and Merge
• Prepare a document for sharing by adding a digital signature, as well as use multiple ways to protect your worksheets and workbooks from changes
• Keep your data consistent and accurate with Data Validation and automate tasks with Macros
• Provide quick and easy access to navigate, modify, and enter data using Forms and Form Controls.. more

Objectives:
• Insert functions into spreadsheets including Logical functions and Conditional functions
• Insert and delete rows and columns
• Apply formatting to text, numbers, and cells including Cell Alignment and Themes
• Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
• Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
• Create and use named ranges
• Create and modify charts
• Quickly find and address errors in your formulas with Tracing.. more

Objectives:
• Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
• Perform calculations using formulas and functions
• Apply formatting to text, numbers, and cells including Conditional Formatting and Cell Styles
• Control how your worksheets print using Page Layout options
• Sort and filter column data
• Identify different Chart Types
• Use Ideas in Office 365.. more

30 Minutes (MS Office)

Objectives:
• Format a PivotTable using built in Styles
• Refresh a PivotTable
• Change PivotTable options
• Create and modify PivotCharts based on PivotTables
• Filter a PivotTable or PivotChart using Slicers and Timelines.. more

Objectives:
• Create a PivotTable from existing Excel data
• Change how summaries are calculated in a PivotTable
• Group data using Excel’s Automatic Grouping feature and Custom Groups.. more

Objectives:
• Create Dual-Axis and Combo charts using Recommended Charts
• Apply and modify Trendlines on a chart
• Create and use a Chart Template
• Insert graphic objects into a spreadsheet
• Apply formatting tools to modify objects.. more

Objectives:
• Create Dual-Axis and Combo charts using Recommended Charts
• Apply and modify Trendlines on a chart
• Create and use a Chart Template
• Insert graphic objects into a spreadsheet
• Apply formatting tools to modify objects.. more

Objectives:
• Create and modify a new table from a dataset
• Apply Table Styles to modify table formatting
• Add formulas to a table using standard functions and the Total Row
• Access commonly used features from the Quick Analysis shortcut
• Customize conditional formatting using the Rules Manager
• Determine which cells to format based on formulas.. more

Objectives:
• Use Database functions to perform calculations on ranges of data based on specific criteria
• Apply the Subtotal function to a filtered list
• Add Subtotals to data using the Subtotals feature.. more

Objectives:
• Sort data using Quick Sort options
• Sort data using the Sort Options dialog box
• Apply filters to view specific data
• Use filters to view specific dates
• Find data within specific ranges with filters
• Analyze data with filters
• Set up advanced filtering to filter data based on complex criteria.. more

Objectives:
• Split text into multiple cells with Text functions
• Split text into multiple cells with the Text to Columns feature
• Combine two or more cells using the CONCAT function
• Change the case of text cells with Text functions
• Use Math functions to round, rank, and generate numbers
• Differentiate between automatic and manual calculation.. more

Objectives:
• Use the IF function to analyze data and determine an outcome
• Use conditional functions with single and multiple criteria to determine which data to summarize
• Nest multiple functions to increase functionality
• Use the IFS and SWITCH functions.. more

Objectives:
• Use Date functions to calculate the difference between two dates
• Use functions to calculate a future or past date
• Use functions to provide information about a date
• Enter and format time in a spreadsheet
• Use a formula to calculate the difference between two times.. more

Objectives:
• Create Named Ranges using the Name Box
• Create and modify Named Ranges from the Ribbon
• Use Named Ranges in formulas.. more

Objectives:
• Open Microsoft Word and navigate the application
• Use keyboard shortcuts to move around and use Search to find text
• Create new documents, add text, and save it
• Update documents and save it without overwriting the original
• Access multiple documents and arrange them for easy access and viewing.. more

Objectives:
• Demonstrate multiple ways to select text to enable faster editing
• Move and copy existing text
• Edit documents by removing text, moving text, and adding hyperlinks
• Preview and control how your document prints
• Customize your version of Word by adding commands to your Quick Access Toolbar or updating your background or theme.. more

Objectives:
• Format text by changing the font style and font color, and adding options like bold and italicized text
• Control how text is laid out by adjusting alignment, hyphenation, and margins
• Manage your indentation with the ruler, indentation markers, and tabs
• Adjust the space between lines of text or paragraphs
• Set tab stops in a paragraph and indent text using tabs
• Create bulleted and numbered lists.. more

Objectives:
• Find and replace text within your document
• Save time and add consistency to your document by applying repetitive formatting
• Create consistent and professional looking headings using Styles
• Create Styles for paragraph text to make reusable formatting for different types of information.. more

Objectives:
• Sort lists using multiple criteria, including lists with multiple columns
• Format numbered lists to control numbering style and sequence
• Fix issues with list sequencing to continue numbering or restart numbering at 1
• Insert tables to clearly lay out important information
• Update tables by adding rows, moving rows, and adjusting column width
• Format tables using Table Styles or individual options like updating Borders and Shading
• Create tables from text that’s already in your document using Convert Text to Table.. more

Objectives:
• Insert Symbols and Special Characters like trademarks and em dashes
• Insert images and control how they appear in line with text, and change their appearance by moving, resizing, and cropping
• Apply borders or background colors to pages
• Include key information in the headers and footers of your document including Dynamic Fields
• Control page layout by adjusting margins, inserting page breaks, and changing the page orientation
• Designate a document’s purpose by adding a watermark.. more

Objectives:
• Check your document for spelling and grammatical errors
• Improve the content of your document with useful tools like the Thesaurus, Translate, and Smart Lookup (research)
• Improve the accessibility of your document for all audiences including those with visual and cognitive disabilities
• Save documents to a variety of formats other than Word 2019.. more

Trusted by Aspiring IT Professionals, Corporations and
Government agencies
for more than a Decade

Get unlimited online access learn anywhere, anytime using your computer or mobile device!