Upper Menu

Microsoft Excel

Advanced Excel

Class Description

Once you’re familiar with Excel, learning the more advanced tools will help you analyze your numbers for solid business decisions. Upon completion of this Advanced Excel class, you’ll be one step closer to mastering Excel.

Instructional Level

Intermediate to Advanced

Requirements

  • You should have a basic understanding of Excel.
  • Techniques work similarly in Excel 2007, 2010, and 2013 for PC. The screen appearance may look a little different, but the tools function the same way.
  • Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar.
  • It doesn’t matter what version of the PC or Mac operating system you’re using.
  • If you have a laptop, bring it to class.

Who should take this class?

This class is necessary training for business owners and employees looking to analyze data for business decisions, and students and job-seekers looking to boost their employment marketability.

It’s designed for Excel users who want to dive deeper into spreadsheet data analysis. Since we specialize in what you “don’t know that you don’t know,” even seasoned users are guaranteed to glean essential nuggets of information to make using Excel easier than before.

What You’ll Learn

  • How to create Pivot Tables
  • How to create vlookup, date, text, and logic formulas
  • How to sort and filter Data Tables
  • How to use Name Ranges for easy understanding
  • How to protect worksheets to keep them perfect
  • More tools that you can use as soon as you get back to work
  • Valuable tips and tricks to shave time off your daily tasks

About Your Instructor

Alicia Katz Pollock is a Microsoft Certified Trainer, Microsoft Office Specialist, Master Level, and Microsoft Certified Application Specialist in Excel, Word, Access, PowerPoint, and Outlook.

Attend in Person or Online via Webinar

If you are planning to attend our class in person, choose Live @ The Vancouver Chamber of Commerce, 1101 Broadway,Vancouver, WA 98660.

If you live outside the Portland, OR area you can still attend and participate in our live classes via webinar. When you register, choose “Online via Webinar” as your ticket type. We’ll email you an access code and instructions for how to connect.

If you have a busy schedule, but don’t want to miss a class, choose “Watch Later” when you register. After your class has ended, we’ll send you a link to the class recording so you can take the class at your convenience. And, if you have questions, this option comes with a 10-minute followup phone call.

Continue Reading
cpe-credit-icon

We now offer CPE credit!

You can now receive CPE credit for any of our QuickBooks, Accounting, and Excel classes. CPE classes are Continuing Professional Education units for CPAs. Receive 1 CPE credit per hour of class. Whenever you complete a class, webinar, or course from our video library, we’ll send you a Certificate of Completion.

Continue Reading 0
Learn Excel in 3 Hours Flat Class in Portland, OR

Quick Tips: Multiple Selections in Excel

Here’s another one of my time-saving Microsoft Excel tips. If you need to make changes to several parts of your spreadsheet at once, don’t highlight each one and make the changes individually. Make multiple selections at one time instead! In this example, I want to select the labels from my Expenses column and the totals from […]

Continue Reading 0
Conditional Formatting in Use

Excel Cool Tool: Conditional Formatting

Conditional Formatting allows you to automatically apply miniature graphs, colors, and icons based on cell contents, so you can quickly compare your data. It’s an extremely helpful tool for small businesses. For example, if your company has a limited overtime policy, you can set cells with values over 40 hours to show as red and immediately see which […]

Continue Reading 0
Learn Excel in 3 Hours Flat Class in Portland, OR

Knowing Excel Makes You More Money

Did you know that learning Microsoft Excel will earn you a higher wage? It’s true! As reported by this Huffington Post article, a recent analysis of the labor market showed that knowing Microsoft Excel is key to making more money, even if you work in customer service jobs such as retail. This doesn’t surprise me […]

Continue Reading 0
Udemy Course Learn Excel in 3 Hours Flat

Microsoft Excel: Why You Should Learn it Now and How to Learn it Quickly

Excel, the popular spreadsheet application bundled with Microsoft Office, is one of the most useful and versatile computer applications. Everyone from business owners to scientists to teachers to homemakers use it to manage and analyze data. Sure, spreadsheets can be intimidating, especially if you have math anxiety or lack confidence in your computer skills. But […]

Continue Reading 0
Creating Random Numbers in Excel

Creating Random Numbers in Excel

Have you ever needed to generate random dates in an Excel spreadsheet? You may not need it often, but when you do, this tip is quite handy. This is the kind of training we cover in our Advanced Excel class, and help you with in your office! To create random numbers, use this formula: =RANDBETWEEN(DATE(2003,1,1),DATE(2014,9,30)) […]

Continue Reading 2
css.php