title

You are here: Home : title

 

Power Excel Tips & Tricks

This one-day workshop for intermediate and advanced Excel users is designed to boost your proficiency in a way that will yield immediate results. Learn advanced skills and concepts, time-saving formulas, and how to use common functions more effectively to increase productivity while gaining better insight into your data.

During this boot camp learn how to:

  • Boost budgeting and planning productivity with advanced formula techniques and Pivot Tables
  • Manage data efficiently in Excel
  • Visualize your data with advanced and effective approaches to charting
  • Create corporate finance dashboards that clearly display your performance metrics
  • Make your reports interactive with advanced features like form controls and VBA

 

Customer Service

Do you have comments or questions about CFO products and services. Call CFO customer service at:
888-250-5719

or email: infocfolearning@cfo.com

Power Excel Tips & Tricks


  Click the chapter titles or the play image (  ) to view each video session.


 

play

duration

55m

  • Charting Tips
  • Fill Handle & Custom Lists
  • Working with Text

 

55m

  • Customizing the Toolbar (add favorite buttons)
  • Easily enter Form Data
  • Efficiently Moving or Copying Worksheets
  • Viewing and Working with More than one Worksheet

 

55m

  • Doing calculations inside pivot tables
  • Data visualization and conditional formatting
  • Tables, filtering, and sorting
  • Special Formula Techniques
           - Formula Auditing (trace precedents & dependents)
  • Featured Trick
           - Have Excel Talk to You

 

55m

  • Macros
  • Formulas
  • PowerPivot

 

55m

  • Charting Do's and Don'ts
  • Functions
  • VLOOKUP
  • Array Formulas (Forecasting Examples)
  • Data Visualization