|
Microsoft Excel |
| | |
| | |
Excel - Level 1 Basic Excel operations |
| Lesson 1: Creating a Basic Worksheet |
| | Navigate and Select in Excel Enter Data and Save a Workbook |
| Lesson 2: Performing Calculations |
| | Create Basic Formulas Calculate with Functions Copy Formulas and Functions |
| Lesson 3: Managing Large Workbooks |
| | Format Worksheet Tabs Manage Worksheets in a Workbook Manage the View of Large Worksheets |
Excel - Level 2 Multiple sheets, three dimensional formulas |
| Lesson 1: Calculating Data with Advanced Formulas |
| | Manage Cell and Range Names Calculate Data Across Worksheets |
| Lesson 2: Auditing Worksheets |
| | Trace Cells Troubleshoot Errors in Formulas Troubleshoot Invalid Data and Formulas Watch and Evaluate Formulas |
Excel - Level 3 Advanced functions and charting |
| Lesson 1: Presenting Data Using Charts |
| | Create a Chart Modify Charts Format Charts |
| Lesson 2: Using Functions |
| | Use Specialized Functions Database Functions Analyze Data with Logical and Lookup Functions Subtotals
|
Excel - Level 4 Enhancing Workbooks |
| Lesson 1: Enhancing Workbooks |
| | Inserting Comments Themes Protecting Workbooks and Worksheets |
| Lesson 2: Analyzing Data |
| | Create Sparklines Create Scenarios Using Goal Seek
|
Excel - Level 5 Workbooks, Exporting and Macros |
| Lesson 1: Working with Multiple Workbooks |
| | Using Links and External References Consolidate Data Compare and Merge workbooks
|
| Lesson 2: Forecasting Data Trends |
| | Determine Potential Outcomes Using Data Tables Forecasting Data Trends Mapping Data
|
| Lesson 3: Automating Workbook Functionality |
| | Data Validation Create and Edit a Macro
|
Excel - Level 6 Pivot Tables and Databases |
| Lesson 1: Analyzing Data Using Pivot Tables and Pivot Charts |
| | Create a Pivot Table Report Filter Data Using Slicers Analyze Data Using Pivot Charts |
| Lesson 2: Organizing Worksheet and Table Data |
| | Create and Modify Tables Format Tables Sort or Filter Worksheet or Table Data Calculate Data in a Table or Worksheet |
| Lesson 3: Automating Worksheet Functionality |
| | Apply Conditional Formatting |
|
Microsoft Word |
|
|
Word - Level 1 Basic word processing |
| Lesson 1: Editing a Document |
| | Navigate and Select Text in a Document Insert, Delete, or Rearrange Text |
| Lesson 2: Formatting Text |
| | Change Font Appearance Highlight Text |
| Lesson 3: Formatting Paragraphs |
| | Set Tabs to Align Text Control Paragraph Layout Add Borders and Shading Apply Styles |
| Lesson 4: Using Templates |
| | Create a Document Using a Template Create a Template |
Word - Level 2 Tables, numbering and graphics |
| Lesson 1: Adding Tables |
| | Create a Table Modify the Table Structure Format a Table Convert Text to a Table or Tables to Text |
| Lesson 2: Inserting Graphic Objects |
| | Add Visual Effects Using Symbols and Special Characters Insert Illustrations Integrate Pictures and Text Insert and Format Screenshots |
| Lesson 2: Controlling Text Flow |
| | Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow |
Word - Level 3 Tables of contents, tracking changes |
| Lesson 1: Making Long Documents Easier to Use |
| | Insert Blank and Cover Pages Insert an Index Insert Table of Figures Insert Table of Contents |
| Lesson 2: Collaborating on Documents |
| | Send a Document for Review Review a Document Compare Document Changes Merge Document Changes Review Track Changes and Comments |
| Lesson 3: Adding Reference Marks and Notes |
| | Add Captions Add Cross References Add Bookmarks |
Word - Level 4 Forms and Macros |
| Lesson 1: Forms |
| | Create Forms Manipulate Forms |
| Lesson 2: Macros |
| | Record and Run a macro |
| Lesson 3: Working with Quick Parts |
| | Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts |
Word - Level 5 Mail Merge, Tables, Charts and Styles |
| Lesson 1: Automating Mail Merges |
| | Perform a Mail Merge Mail Merge Envelopes and Labels Use Word to Create a Data Source |
| Lesson 2: Customizing Formats Using Styles and Themes |
| | Create and modify Text Styles Create Custom List or Table Styles Apply Document Themes |
| Lesson 3: Working with Tables and Charts |
| | Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart |
|
Microsoft Access |
|
|
Access - Level 1 Database basics - the design |
| Lesson 1: Designing a Database |
| | Describe the Relational Database Design Process Define Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize Data Designate Primary and Foreign Keys Determine Table Relationships |
Access - Level 2 Tables and simple select queries |
| Lesson 1: Building a Database |
| | Create a New Database Create a Table Manage Tables Create a Table Relationship |
| Lesson 2: Querying a Database |
| | Filter Records Create a Query Add Criteria to a Query Add a Calculated Field to a Query Perform Calculations on a Record Grouping |
Access - Level 3 Working with forms and reports |
| Lesson 1: Designing Forms |
| | View Data Using an Access Form Create a Form Modify the Design of a Form |
| Lesson 2: Generating Reports |
| | View an Access Report Create a Report Add a Custom Calculated Field to a Report Format the Controls in a Report Apply an AutoFormat to a Report Prepare a Report for Print |
Access - Level 4 Working with forms and reports |
| Lesson 1: Improving Forms |
| | Design a Form Layout Enhance the Appearance of a Form Restrict Data Entry in Forms Add a Command Button to a Form Create a Subform |
| Lesson 2: Customizing Reports |
| | Organize Report Information Format the Report Set Report Control Properties Control Report Pagination Summarize Report Information Add a Subreport to an Existing Report Create a Mailing Label Report |
Access - Advanced Queries Action queries, crosstabs and pivot queries |
| Lesson 1: Creating Flexible Queries |
| | Set Select Query Properties Create Parameter Queries Create Action Queries |
| Lesson 2: Writing Advanced Queries |
| | Create Subqueries Create Unmatched and Duplicate Queries Group and Summarize Records Using Criteria Summarize Data Using a Crosstab Query Create a PivotTable and a PivotChart |
|
Microsoft Outlook |
|
|
Outlook - Level 1 Using email features and options |
| Lesson 1: Getting Started with Outlook |
| | Send a Simple Message Reading Messages Reply to and Forward a Message Print a Message Delete a Message |
| Lesson 2: Composing Messages |
| | Address a Message Format a Message Check Spelling and Grammar Attach a File |
| Lesson 3: Organizing Messages |
| | Open and Save an Attachment Flag a Message Organize Content with Folders |
Outlook - Level 2 Working with email features and options |
| Lesson 1: Customizing Message Options |
| | Modify Message Settings Modify Delivery Options Change the Message Format Notify Others That You will be Out of the Office Create a Distribution List Insert a Hyperlink |
| Lesson 2: Personalizing Your Email |
| | Apply Stationery and Themes Create Signatures |
Outlook - Level 3 Working with the calendar, appointments and meeting requests |
| Lesson 1: Scheduling Appointments |
| | Explore the Outlook Calendar Schedule an Appointment Assign Categories and Edit Appointments |
| Lesson 2: Scheduling Meetings |
| | Schedule a Meeting Reply to a Meeting Request Propose a New Meeting Time Manage Meetings Print the Calendar |
Outlook - Level 4 Working with tasks, contacts and notes |
| Lesson 1: Managing Contacts |
| | Add a Contact Sort and Find Contacts Manage Contacts |
| Lesson 2: Managing Tasks and Notes |
| | Create a Task Edit and Update a Task Create a Note Edit a Note Display a Note on the Desktop |
| Lesson 3: Managing Tasks |
| | Assign a Task Reply to a Task Request Send a Task Update Track Assigned Tasks | Crystal Reports | | | Crystal Reports - Level 1 Creating simple reports, sorting and filtering | | Lesson 1: Creating a Report | | | Specify Fields for a New Report Preview a Report Modify Field Display Add a Report Title Position Fields Add Fields from Other Tables | | Lesson 2: Displaying Specific Report Data | | | Find Data Sort Data Filter Data by a Single Criterion | Crystal Reports - Level 2 Grouping and summarizing data | | Lesson 1: Grouping Report Data | | | Insert a Group Add Summaries Format Summary Information Change Group Options Add a Second-Level Grouping Filter Records by Group Create a Top N Sort Group | Crystal Reports - Level 3 Formulas in Crystal Reports | | Lesson 1: Building Formulas | | | Create a Formula Edit a Formula Combine Fields by Formula Delete a Formula Filter Data by Multiple Criteria Modify a Filter Using an OR Operator Create a Parameter Field Account for Null Fields in a Formula | | Power Point | | | Power Point - Level 1 - Develop and Prepare to Deliver Presentations | | Lesson 1: Developing a PowerPoint Presentation | | | Select a Presentation Type View and Navigate a Presentation Edit Text Build a Presentation | | Lesson 2: Performing Advanced Text Editing | | | Format Characters Format Paragraphs Format Text Boxes | | Lesson 3: Adding Graphical Elements to Your Presentation | | | Insert Clip Art and Images Insert Shapes | | Lesson 4: Modifying Objects in Your Presentation | | | Edit Objects Format Objects Group Objects Arrange Objects Animate Objects | Power Point - Level 2 - Modify, Customize and Collaborate Presentations | | Lesson 1: Adding Tables to Your Presentation | | | Create a Table Format a Table Insert a Table from Other Microsoft Office Applications | | Lesson 2: Adding Charts to Your Presentation | | | Create a Chart Format a Chart Insert a Chart from Microsoft Excel | | Lesson 3: Preparing to Deliver Your Presentation | | | Review Your Presentation Apply Transitions Print Your Presentation Deliver Your Presentation | | | Project | | | Project - Level 1 | | Lesson 1: Getting Started with Microsoft Project | | | Explore the Microsoft Project Environment Display an Existing Project Plan in Different Views | | Lesson 2: Creating a Project Plan | | | Create a Project Plan Assign a Project Calendar Add Tasks to a Project Plan Enter the Task Duration Estimates Add Resources to a Project Plan | | Lesson 3: Managing Tasks in a Project Plan | | | Outline Tasks Link Dependent Tasks Set Task Constraints and Deadlines Add Notes to a Task Add a Recurring Task | | Lesson 4: Managing Resources in a Project Plan | | | Create a Resource Calendar Assign Resources to Tasks Enter Costs for Resources Resolve Resource Conflicts | Project - Level 2 | | Lesson 1: Finalizing a Project Plan | | | Shorten a Project Using the Critical Path Set a Baseline Print a Project Summary Report | | Lesson 2: Exchanging Project Plan Data with Other Applications | | | Import Project Information Export Project Plan Cost Data to an Excel Workbook Copy a Picture of the Project Plan | | Lesson 3: Updating a Project Plan | | | Enter Task Progress Enter Overtime Work Edit Tasks Reschedule a Task Filter Tasks Set an Interim Plan Create a Custom Table Create a Custom Field | | Lesson 4: Reusing Project Plan Information | | | Create a Project Plan Template Create a Custom View Make Custom Views Available to Other Project Plans Share Resources Create a Master Project | | Visio | | | Visio - Level 1 | | Lesson 1: Getting Started with Visio 2013 | | | Navigate the Visio Environment Use Backstage Commands Save a File | | Lesson 2: Creating a Workflow Diagram | | | Use Drawing Components Modify a Drawing Callouts and Groups | | Lesson 3: Creating an Organization Chart | | | Create a Basic Organization Chart Modify an Organization Chart Make an Organization Chart from an Excel Spreadsheet | | Lesson 4: Making a Floor Plan | | | Make a Basic Floor Plan Model a Room Layout | | Lesson 5: Creating a Cross-Functional Flowchart | | | Create a Cross-Functional Flowchart Format a Cross-Functional Flowchart | Visio - Level 2 | | Lesson 1: Creating a Network Diagram | | | Network Diagrams Use Shape Data Use Layers | | Lesson 2: Styling a Diagram | | | Shape and Connector Styles Themes and Variants Use Containers | | Lesson 3: Enhancing the Look of Drawings | | | Apply Backgrounds, Borders, and Titles Define Shape Styles | | Lesson 4: Creating Shapes, Stencils, and Templates | | | Create Simple Custom Shapes Create Custom Stencils Create Custom Templates | | Microsoft Teams - Chat, Hold Meetings, Call and Collaborate | |
Microsoft Teams is much more than an instant messaging program! With Teams, here are a few of the things you can do: · - Chat
- Hold Meetings
- Video conferencing
- Screen sharing
- Call
- Collaborate
- Announcements and file sharing
- Apps
- Central location for Q&As
- Work on multiple projects together
In this training we will explore the Teams Interface. We will delve into creating Teams and channels. We will practice screen sharing, file sharing, and look at many other features that are available. Students will need Microsoft Teams installed on their computer in order to participate in the class. Generic account information will be emailed to students prior to the beginning of class. | | | Other Training | | | Windows File Management | | Lesson 1: Managing Folders and Files | | | Navigate to Folders Using Windows Explorer Work with Folders and Files Secure Folders and Files Organize Folders and Files Search for Folders and Files | Office Tips and Tricks - How to Use All Microsoft Programs More Efficiently | Lesson 1: Microsoft Office | Common Features in Applications The Cloud | Lesson 2: Shortcut keys | Common Shortcut Keys in All the Applications Application-specific Shortcut Keys & Tips | Lesson 3: Newer Features | Breakdown in Each of the Applications | iPad - Basics of Using an iPad | | Lesson 1: Navigation | | | Keyboard shortcuts Controls and navigation options | | Lesson 2: Overview of Apps | | | Apps that come with your iPad Apps that you can download | Open Question and Answer | | Bring any question about Microsoft Office Products, iPad, Cyrstal Reports, or Windows to Marty, the trainer. Marty will take questions on a first come/first serve basis. Just show up during the designated time slot (either 9:00 am-noon or 1:00 pm - 4:00 pm). If you stump Marty she will take your contact information, research the question, and then get back to you. | | It is not necessary to register for the Open Question and Answer time - you only need to arrive during the 3 hour time period. | Windows 10 - Understanding Windows 10 | | Lesson 1: Accessing Windows 10 | | | Navigate the Windows 10 Desktop Manage the Start Menu Sign In to Windows 10 | | Lesson 2: Using Windows Apps and Desktop Applications | | | Navigate Desktop Applications Navigate Windows Apps Features Navigate the Cortana Virtual Assistant App | | Lesson 3: Working with Files and Folders | | | Manage Files and Folders with File Explorer Store and Share Files with OneDrive Multitask with Open Apps | | Lesson 4: Accessing the Internet using Microsoft Edge | | | Use Microsoft Edge Customize Microsoft Edge | | Lesson 5: Customizing the Windows 10 Environment | | | Customize the Start Screen Customize the Desktop | | | Microsoft Office Online and One Drive - How to Utilize Microsoft One Drive | | Lesson 1: Getting Started | | | Creating an account | | Lesson 2: Files and Folders | | | Folder Hierarchy Uploading Folders and Files Sharing Options | | Lesson 3: Co-Authoring | | | Co-Authoring a file Co-Authoring options | | Lesson 4: Office Online | | | Differences between desktop applications and online apps | Time Management – Level 1 - Learn How to Use Your Time Better | | Lesson 1: Getting Started | | | Pre-Assignment Review | | Lesson 2: Setting SMART Goals | | | The Three P’s The SMART Way; Prioritizing Your Goals; Visualization | | Lesson 3: Prioritizing Your Time | | | The 80/20 Rule The Urgent/Important Matrix Being Assertive | | Lesson 4: Planning Wisely | | | Creating Your Productivity Journal Maximizing the Power of Your Productivity Journal The Glass Jar: Rocks, Pebbles, Sand, and Water Chunk, Block, and Tackle Ready, Fire, Aim! | | Lesson 5: Tackling Procrastination | | | Why We Procrastinate Nine Ways to Overcome Procrastination Eat That Frog! | Time Management – Level 2 - How to Make Time Work to Your Advantage | | Lesson 1: Crisis Management | | | When the Storm Hits Creating a Plan Executing the Plan Lessons Learned | | Lesson 2: Organizing Your Workspace | | | De-Clutter Managing Workflow; Dealing with E-mail; Using Calendars | | Lesson 3: Delegating Made Easy | | | When to Delegate; To Whom Should You Delegate; How Should You Delegate; Keeping Control; The Importance of Full Acceptance | | Lesson 4: Setting a Ritual | | | What is a Ritual?; Ritualizing Sleep, Meals, and Exercise Example Rituals Using Rituals to Maximize Time | | Lesson 5: Meeting Management | | | Deciding if a Meeting is Necessary Using the PAT Approach Building the Agenda Keeping Things on Track Instant Messaging and Chat Rooms Collaboration Applications | Power BI Dashboards - Visually Arrange and Share Your Raw Data |
|
|
|
|