How do administrative assistants use excel

Log In 0 Items. This course is part of the Essential Excel Series : Essential Excel for Finance Essential Excel for Business Administration Financial Reporting for Executive Assistants Specifically designed for business administrators who need to take their Excel skills to the next level, this intensive full day course focusses on the technical Excel skills required in everyday administration roles.

Prerequisites The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already using spreadsheets. At minimum, it is assumed that participants will know how to: Navigate confidently in Excel Create and use simple formulas Link between workbooks Who should Attend? 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.

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. On June 17, , we have a live training: Create Dashboards and Tables!

This will be available on-demand. 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. It is mandatory to procure user consent prior to running these cookies on your website. Table of Contents. Data Filters. Data Sorting. Pivot Tables.

Excel Shortcut Keys. Cell Formatting. Learn without limits. Get Access to All Courses. Globally Recognised. Managing Page Layout. Data Validation. Microsoft Excel Complete Bundle. The course is endorsed by TQUK, an established Ofqual-regulated Awarding Organisation which assures your qualification is professional and recognised.

Enrol today. Pivot Charts. Flash Fill. Quick Analysis. Power View. Conditional Formatting. Moving Columns into Rows. IF Formulas. Auditing Formulas. If you want to explore some of the above-mentioned skills, watch the video below.

Want to advance your employment opportunities? Excel Course is a must! Read more How to Become a Florist? October 6, Leave a Message Cancel reply You must be logged in to post a comment.

We use cookies to improve your experience.