PACE Certification Program

The Professional Administrative Certification of Excellence was established to raise the awareness of the Administrative Professional field and provide a clear standard that symbolizes excellence.  The PACE designation signifies that participants have demonstrated work-related knowledge, skills, and competencies required to excel in their roles and organizations.

Earning the PACE Certification and placing the PACE designation after their name will enable participants to demonstrate their depth of knowledge, expertise, and commitment, positioning them as highly credible professionals who are serious about professional development, career advancement and serving their organization to the best of their abilities.  The PACE credential places participants in an exclusive group of admins whose skills and expertise are recognized and acknowledged. 

Topic includes:

  • Interpersonal Communications

  • Task and Project Management

  • Computer and Internet Technology

  • Management Skills

Get the Job Done Faster in Word

Create and manage your business reports with ease by using Styles and creating the Table of Contents in NANO seconds.  Eliminate the frustration when creating agenda and menu using simple techniques in Word.

Topic includes:

  • Understand the positive uses of Styles

  • Learn how to use Styles that will create Table of Contents

  • Learn how to create and manage the information with Styles along with the Navigation Pane

  • Understand how to create leaders to help you create your company’s agenda

 

Power Query and Flash Fill

Frustrated with cleaning data in Excel? Using Power Query with its Query Editor, a powerful tool for shaping and transforming data so it’s ready for your models and visualizations. Flash Fill will give you the power to be productive and eliminate the need to create complicated formulas like RIGHT, LEFT, MIN, and CONCATENATE. Learn the hidden secrets of these two techniques.

Topic includes:

  • Parse out the information that comes in one cell and find duplicates in two tables.

  • Transform data into a normalized table and fill in blank cells.

  • Use Flash Fill to combine names, extract names, format numbers, move text around in order to create new information, and extract names from email accounts

  • Also use Flash Fill to separate dollars and cents; combine text, currency and date, and separate hours from minutes

 

Unleash the Power of Excel

Harness the power of overlooked and advanced features of Excel. Stop wasting time using outdated formulas and procedures. Learning the power of Excel will make the employee the Excel guru of the office.

Topic includes:

  • Learn which function and formula is the most valuable:

    • Subtotal

    • SumIf

    • Vlookup

    • Insert table

    • Filters

    • Pivot Tables

    • Slicers

    • Timeline

    • Validation List

 

Excel Dynamic Charting

Excel offers built-in charts. This course demonstrates how to create our own unique charts as well. In this course you will learn how to create charts in Excel to interpret the data with visualizations. These charts are not found in Excel. These charts are not only functional by dynamic (charts are in motion).

Must have a strong use of Excel.

Excel Dashboards and Power BI (Business Intelligence)

In Excel, dashboard is one pager (mostly, but not always necessary) that helps managers and business leaders in tracking key KPIs or metrics and take a decision based on it. It contains charts/tables/views that are backed by data. A dashboard is often called a report, however, not all reports are dashboards.

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.

Create Extraordinary Power Pivot Tables with Power Maps, Slicers & TimeLine

You create Pivot tables using one table. Image creating a Pivot Table where it takes information from multiple sheets using Power Pivot! Now add 3D Maps where you can plot geographic and temporal data on a 3D globe or custom map, show it over time, and create visual tours you can share with other people. Then add Slicers and Timeline to quickly filter your data. Combining these visualization tools provide an immersive experience for making discoveries in your data that might have never been see in traditional spreadsheet manner.

Create Compelling, Interactive Presentations in PowerPoint

Learn how to plan and create a PowerPoint presentation that speaks to the audience. Successful presentations should deliver the critical information in a natural and engaging way. Adding navigational tools like hyperlinks can make the presentation feel conversational – even improvisational – which increases the likelihood the audience, or boardroom, will engage with the content and retain what they’ve heard. See how clickable items, interesting transition and animation schemes, and segmenting the presentation into logical chunks make it compelling for the audience, while keeping it easy for the presenter to deliver.

Topics include:

  • Creating hyperlinks for navigating to relevant information as questions are asked.

  • Take advantage of Morph, Zoom, and other transition functions to create a ‘big picture’ slide.

  • Building charts and diagrams one piece at a time to clarify the message.

  • Download fonts, music, sound, and gif to make amazing presentation

FastTrak Excel

If you have a good understanding of Excel, this course teaches you advanced techniques for you to become more efficient and effective in Excel.

Topics include:

  • Tips and Techniques

  • When to use the right tools in Excel

  • Tables and Slicers

  • Pivot Table and Power Pivot with Slicers

  • Data Validation with Multiple Selections

  • TextJoin, Switch and IFS

FastTrak Word

If you have a good understanding of Word, this course teaches you advanced techniques in order for you to create a professional document efficiently and effectively in Word.

Topics include:

  • Section Breaks

  • Mail Merge

  • Creating Table of Contents

  • Using Styles and Navigation Pane

  • Headers and Footers

FastTrak PowerPoint

If you have a good understanding of PowerPoint, this course teaches you advanced techniques in order for you to create captivating presentations.

Topics include:

  • Animations

  • Transitions

  • Manipulating Images