Microsoft Excel INTERMEDIATE Training Course (Level 2) 3hrs

Training that is fun & easy so that you can be confident, more productive, and save time @ work!

Excel INTERMEDIATE Training Course (Level 2)

Duration: 3 hours | 1:00-4:00pm EST.

Course Delivery: Instructor-led live online training using Microsoft Teams.

Course Pre-requisite: Excel INTRO Level 1, or users with some experience and understanding of the basic concepts. Beginners may also be interested in Microsoft Office BASICS Word Excel PowerPoint (3in1 Bundle).

Next Course in Series: Excel ADVANCED Level 3.

Certificate of Completion: Upon your course completion, a Certificate of Completion will be provided upon request.

Included Course Materials: You will receive 1) A comprehensive digital Training Manual, 2) Practice files if applicable, and 3) Quick Start Guide (MS Office only).

Course Overview:

Join us for an interactive and 'hands-on' training session that will upgrade your skills to the next level!

This Microsoft Excel INTERMEDIATE Level 2 course is designed to help you expand and master your skills so that you feel even more confident working with Excel:

--> New Features

--> Top Tips & Tricks

--> Keyboard Shortcuts

--> Navigating

--> and much more.

Course Outline & Topics:

1. NEW MICROSOFT OFFICE INTERFACE

The File tab. The Ribbon. Program tabs vs Contextual tabs. The Quick Access toolbar (QAT).

2. EXCEL 201

Review of Level 1. The Excel Window. Quick Reference & Shortcuts.

3. WORKSHEETS & WORKBOOKS

Grouping Worksheets. Linking Cells. Linking Linking Worksheets & Workbooks. Hyperlinks.

4. FORMATTING

Troubleshooting text and number formats. Format Painter. Go To Special.

5. NAVIGATING & NAMED RANGES

Shortcuts for Navigating. Name Box, Named Ranges.

6. FORMULAS

Review of AutoSum. Intermediate Formulas - IF, Nested IF, CountifIF, SumIF, Right, Left, Trim, Mid, Round, Substitute, Concatenate, Lookup, VLookup, HLookup.

7. DATABASE MANAGEMENT

Importing & Exporting Data. Sorting Data. Custom Sort. Filtering Data.

8. STYLES

Intermediate Conditional Formatting.

9. DATA TOOLS

Text to Columns. Data Validation. Goal Seek.

10. PROTECTION

Protect Sheet, Unprotect Sheet. Protect Workbook, Password to Open, Modify, or Read-only.

11. CHARTS

Chart Contextual tabs. Chart Types, Column or Bar Chart, Line Chart, Pie Chart. Creating a Chart. Modifying a Chart. Resizing & Moving a Chart.

12. PIVOT TABLES

Data Source. PivotTable Contextual tabs. Creating a PivotTable. PivotTable Fields. Modifying a Pivot Table. Subtotals & Grand Totals. Refresh a PivotTable. Change Data Source. Creating a PivotChart. PivotChart Contextual tabs.

MICROSOFT OFFICE

BUSINESS SKILLS

WELLBEING PROGRAMS

Option to Add-on a 1hr OR 3hr Private 1:1 Training Session @ checkout.

Maybe you’re looking for a new job, or you just started a new job, and need customized training on specific topics (ie Word and PowerPoint combined in one session)? Do you have lots and lots of questions and/or prefer one-on-one training?

Customized Training

Do you need training for just one or two employees, maybe Customer Service training or Time Management training for a new hire, or for a new position? Whatever the scenario, we can completely customize a personalized training session to fit your needs.

Corporate Training

We can work with you to improve your Employee Onboarding Program, and/or a migration to a new version of Microsoft Office, SharePoint, or OneDrive. We are experienced in onboarding programs, software migrations/upgrades. We can help with training and upgrading existing and new employees with computer and business skills. We also train on PC Computer Basics, and Keyboard & Typing Skills.

Ready to schedule your onsite group training?

info@INTrainingSolutions.com

Melissa@INTrainingSolutions.com

Be confident. More productive. Save time and $$$.

Meet your Instructor

Melissa Bowers, MOS, MCT, CTDP

Your training session will be delivered by Melissa Bowers. Melissa is a Corporate Trainer & Mindfulness Teacher, Certified Grief Educator, and past Chapter Chair for The Institute for Performance and Learning (I4PL). With an extensive background in Learning & Development, she holds several professional designations, including Microsoft Office Specialist (MOS) Master Instructor, Microsoft Certified Trainer (MCT), Certified Training & Development Professional (CTDP), and is a qualified Adult Education Instructor.

Clients

Commitment to Your Success.

Melissa Bowers has a proven track record working with businesses in a range of industry sectors. From Top 100 corporations, not-for-profit organizations, government, small businesses, and individuals, she has delivered training programs to 10,000+ learners globally over the past two decades, and helped hundreds of organizations save time and money.

Instructor-led live online training using Microsoft Teams (free download).

Once registered, you will receive a Microsoft Teams training link & password. You will require the current version of TEAMS installed on your computer. You will also receive 1) A comprehensive digital Training Manual, 2) Practice files (if applicable), and 3) Quick Start Guide (MS Office only).

*If you are new to TEAMS please watch this intro video for more info: Attend a live Teams event