3 Excel Tips and Tricks Every Administrative Assistant Should Know

June 10, 2021


Microsoft Excel is the industry-leading spreadsheet program used in administrative jobs today. There is a free version, but that program is not recommended for business use. The full suite of Office 365 programs including Word, PowerPoint, Microsoft Teams, Outlook, One Drive, and Excel is more suitable in the business environment.   This version has so many perks that it takes some time and training to learn how to take advantage of what you have. Fundamentals of MS Excel can help get you started if you’re a newbie. And ASAP can help you with 3 tips and tricks to maximize your experience.

1. Formulas

Formulas are the key to making your Excel experience work. You can enter any kind of data in the Excel sheet: terms, numbers, or dollar amounts. Once you have entered the data, you need formulas to find out what that data means. Your administrative job may include keeping up with production. You can enter the items your company produces, then the daily or weekly production numbers. This gives you a quick view of how the company's production looks.  With formulas, you can total those and see the exact numbers produced. If you have a large outside sales force, you can use Excel to track salespeople. With formulas, you can include and exclude any cells that you choose. You can print these spreadsheets or chart the results. Count on Formulas in Excel will help you with more formula use.

2. Filters

Administrative assistants use filters in Excel to remove extraneous information from the view or print out screens. You may need the salespeople with full names and addresses in your Excel database, but you don’t need to see the address when you are reviewing sales. If you need to present a printed report to the boss, he doesn't want address information, just sales. This is when you can filter those columns from view. Filters make Excel good to the last Drop explains exactly how you can use these Excel tips and tricks to make your data cleaner and simpler. It also shows how to make your reports and graphs show the data that you need to exhibit.

3. Pivot Tables

With the pivot table feature in Excel, administrative assistants can take a large database and only include the information that is relevant for that project. It is more technologically advanced than our other Excel tips and tricks. Once you understand it, you will be able to use the pivot table to create dynamic summary reports. It will take some training to perfect this process, but we have several ways to help you. Pivot Tables: Data They Will Understand is a downloadable guide that you can use to start your pivot table use. We, at ASAP, also have a free prerecorded webinar Pivot Your Tables To Data They Understand. On June 17, 2021, we have a live training: Create Dashboards and Tables! This will be available on-demand.


Microsoft Excel can be an administrative assistant’s best friend, especially if in a data-driven position. If you have only been using Excel as the basic source of spreadsheet tracking, you are missing out on some of the best features it offers. Give yourself time to learn and perfect these processes. They can be a little tricky at first, but once you master them, you will be amazed at the information you can access. Let the experts at ASAP teach you how to use this tool in ways that can help your business with our tips and tricks for Excel.

Join the Conversation

Welcome to the ASAP Circle, a community platform for peer-to-peer conversation on trending topics, professional challenges, and shared experiences. We even have designated spaces for weekly Tuesday Coffee Breaks.

Start Connecting Today!

American Society of Administrative Professionals

Producer of

APC  EA Ignite