Microsoft Excel Titles

  • Most of these titles apply to both PC & Mac platforms.
  • Deliveries available for Corporate Training & Conferences
  • (*) Asterisk indicates the course is currently available in the RedCape Academy

“Organize and manage your lists effortlessly using Excel tables”

Frustrated with the amount of time you spend fixing and formatting your lists in Excel?  Discover the true power of Excel to make your life so much easier when managing lists of data. If you are working with marketing lists, membership lists, inventory, or a list of employees and customers, you want to ensure that the information is accurate and easy to consume. Learn how to quickly make sense of your information and get it in the right format you need to get the job done. You’ll work smarter and faster than ever before!  In this session, you will learn how to:

  • Use Excel tables to manage your lists
  • Easily find and remove duplicates
  • Find the right information using one-click filtering and conditional formatting techniques
  • Discover how to prevent Excel from dropping leading zeros in your zip codes or other numbers
  • Truly manage data more effectively than you thought possible

“Excel Back to Basics”*

Excel is simple to use. Just open it up and start typing. But if you really want to understand the nuances of the program and why it behaves the way it does, take a step back and review the best practices when setting up spreadsheets and managing your data:

  • Navigate effectively in the Excel Environment
  • Format spreadsheets effortlessly
  • Set page layout and workbook options

“Excel Tips & Tricks: Manage and format data like never before using jaw-dropping tips & tricks”*

Whether you are an Excel guru or you just “get by”, learn simple and practical tips & Tricks that will help you produce professional-looking spreadsheets with minimal effort. This course is perfect for business users and for the experts!!

  • Use timesaving shortcuts to improve efficiency and accuracy
  • Manage and format data with minimal effort and a whole lotta confidence using Tables
  • Discover ways to fix problems with your data and reduce errors

“Excel Formulas & Functions Part 1″*

Create simple and valuable calculations in Excel to get the right information and to prevent mistakes. In this session, we will first review the two types of calculations and walk through Excel’s Order of Operations. Then we’ll use how-did-I-ever-live-without-you functions to easily analyze and fix common problems, such as:

  • Logical Functions (If)
  • Change case functions (Proper, Lower, Upper)
  • Combine two fields together (Concatenate)
  • Clean up and extract data (Trim, Left, Right)

“Excel Formulas & Functions Part 2”

Expand on your basic knowledge of formulas and functions and easily create calculations to help you get the answers you need quickly. In this session, we will create our calculations from scratch as well as leverage the Formula Wizard to help us build our how-did-I-ever-live-without-you functions, shedding light on our data and allowing us to work with the information we need, when we need it. We’ll work with:

  • Calculations across worksheets
  • Nested functions
  • Date and time functions (DAYS, EDATE, EOMONTH, NETWORKDAYS, TIMEVALUE, DATEVALUE)
  • Information functions (ISBLANK, ISERR, ISERROR, ISNA)

“Excel Conditional Formatting”

Learn how conditional formats in Excel will improve your accuracy and response time, help you make critical business decisions, and give you confidence in your work.  Not only will you be more productive, you’ll deliver better looking reports and have more time now to focus on what matters most — not sitting for hours in front of a spreadsheet (unless you’re admiring your awesome work).

  • Learn various conditional formatting features that will save you time
  • Understand how the story behind your data can help prevent bad things from happening
  • Identify successful results and new opportunities for you and your team

“Excel Lookups and Validation Tips & Tricks”

Automate your work and get 3x more done when managing your data in Excel by using lookup functions and validation lists. In this session we will explore Vlookup and related lookup functions to automatically populate the data we need. We’ll also create validation lists for easy data entry to help save time and reduce errors!

“Excel Pivot Tables 101: Introduction to Pivot Tables”*

PivotTables are a powerful feature to help you manage and view information in meaningful ways. In this session, we will explore how a Pivot Table can be a great solution for creating numerous reports from one data source such as a list of contacts, expenses or employee lists.  Whether the words “Pivot Table” terrify you or turn your pupils into little hearts, you’ll leave this session with more confidence and understanding of how a Pivot Table can help you deliver accurate results fast. The session begins with an overview of Excel’s new Format as a Table feature to effectively prepare your data for Pivot Table analysis.

“Introduction to Power Pivot for Excel”

Microsoft Power Pivot for Excel is an add-in that you can use to perform powerful data analysis in Microsoft Excel 2010 and above, bringing self-service business intelligence to your desktop.  In this 75-minute online session, we’ll cover:

  • What Power Pivot is and the benefits of using it
  • Essential tasks: Creating relationships, calculated fields and pivot reports
  • Best Practices

“Excel Pivot Table Best Practices”

As a follow up to Introduction to Pivot Tables, learn best practices when creating and managing various Pivot Tables and fall even more in love with this powerful tool. This session will identify common traps and problems when working with Pivot Tables and ways to minimize errors when creating Pivot Reports. Understand how to ensure your data is in the best possible format for reporting; discover timesaving tips & tricks when creating professional reports; and learn practical solutions for day-to-day problems.

“Tips & tricks when working with Excel Charts”

Your data has a story to tell and charts are the perfect way to find out what that story is. Use charts to provide you with critical information before a meeting, patterns and trends to help you make intelligent decisions, and the visuals to help persuade your audience. Join us for this session to discover tips & tricks to help find out the story behind your data, and learn how to:

  • Easily create and modify charts
  • Navigate the various chart elements
  • Correctly paste your charts in Word or PowerPoint

“How’d they do that?  Magical formatting tricks to help you deliver professional results in less time”

Have you ever used a template or seen a co-worker’s Excel spreadsheet and asked yourself: How’d they do that? How in the world did they find the time to create this? Why am I talking to myself? In this session, we go beyond formulas, functions, and charts to examine amazing formatting techniques that will make your spreadsheet look amazing in very little time. No design skills necessary! Attend this session to learn how to:

  • Instantly format tables, charts, images, SmartArt and more, using built-in Styles.
  • Create a consistent look and feel throughout your workbook using Office Themes, Color Sets, Font Sets, and Effects
  • Automate your spreadsheet using links and buttons to make it easier to navigate
  • Access pre-built templates and use tips & tricks of the pros to help you customize the template and make it your own