Webinar: Excel Guru - Tips to Make Your Head Spin

WK268  |  Partner Virtual Events  |  Advanced  |  Scheduled


How much do you know about Excel and the features and functionality it provides that could make a difference in your personal day-to-day productivity? Most accountants and other business professionals use less than 20% of the functionality of this product. Are you taking advantage of the features that are best for you? This session is sure to deliver many thought-provoking ideas and tips for getting better results with less effort and in less time.


Number of Credits Type of Credits
2 Other


Good working knowledge of Excel


Use the Data Model and cube formulas to improve analysis and reporting Memorize complex formulas, constants, or array constants for future use Utilize statistical procedures in the Data Analysis ToolPak to your advantage Add slicers to individual or multiple Tables, Pivot Tables, or Pivot ChartsUse advanced functions such as AGGREGATE, RANDBETWEEN, EOMONTH, and WEEKDAYUse SUMIFS to create analytical reports without using PivotTablesUse the Data Model effectively without PowerPivot


Upon completing this course, you should be able to:

  • Identify key productivity-enhancing Excel functionality and features
  • Differentiate between Excel functionality to select the best features for your objectives
  • List capabilities that have direct application to your practice or business
  • Apply the knowledge gained to improve your personal productivity




This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.


Member (Early Bird)
Non-Member (Early Bird)
Your Price: $79.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations. Early Bird rates will be applied to all registrations made prior to December 20, 2017.


Lawrence McClelland, MBA, JD

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Back to Facilitators