CONTACT THE BUSINESS LEARNING INSTITUTE
Name*
Email Address*
Phone Number:
Message:
Please enter the following text in the box below:
captcha
ADDRESS: 901 Dulaney Valley Road, Suite 800
Towson, MD 21204
PHONE: 888-481-3500
FOLLOW BLI:
Excel Hot Topics and Best Practices for CPACOURSE ID: EXCELHOT
DESCRIPTION

In this course we will explore many of the best Excel tips for analyzing data, presenting data in graphic form, linking data from Excel to Word and consolidating worksheets. This presentation applies to Excel 2016, 2013 and 2010. Excel new features will be emphasized. Attendees will receive practical information, many tips and course take-away resources. Course format choices are: instructor-led hands-on group training; or lecture/demonstration with live demo.

DESIGNED FOR: Business Leaders, Corporate Finance Teams, CPA Practitioner, CPAs, Financial ProfessionalsFIELD OF STUDY: Computer ScienceLEVEL: UpdatePREREQUISITES: Familiarity with Microsoft Excel 2010, 2013 or 2016COURSE PRODUCER: Business Learning InstituteCREDITS: 4.0OBJECTIVES:
  • Use Microsoft Excel features for a variety of calculations
  • Compare and contrast the Excel Pivot Table for analyzing one set of data vs the Multiple Consolidated Ranges feature for analyzing multiple sets of data that are dissimilar in structure
  • Explore Pivot Table analysis in date ranges
  • Use new Conditional Formatting and Sparkline presentation graphics to show patterns and trends in data and build a digital dashboard
  • Incorporate new data visualization reporting features
  • Use the data linking features between Excel and Word that automatically expand and contract the linked picture as the Excel data range expands and contracts
  • Use many of the best Excel productivity tips for accountants
HIGHLIGHTS:

*Analyze one set of data with a Pivot Table and multiple sets of data with PowerPivot
*Incorporate the benefits of the Multiple Consolidated Ranges feature for analyzing multiple sets of spreadsheet data
*Explore the pros and cons of using each feature
* Use date grouping within a Pivot Table
* Filter a Pivot Table using the Report Filter and the new Slicer and Timeline
* Explore the pros and cons of using each feature
* Communicate patterns and trends in data visually with interactive color and icon based conditional formatting rules and also the new Sparkline graphic
* Explore how to choose the best graphic feature for your analysis
* Explore and compare the use of paste Excel range as picture, paste Excel range as linked picture, paste interactive named Excel range as linked picture, update the link, and fix a broken link
* Demonstrate the best Excel productivity tips for accountants
* AutoFill vs FlashFill
* Convert dates and use text to columns for parsing data
* Troubleshoot formula errors quickly
* Automate repetitive tasks with the macro recorder
* Use new criteria based functions
* Explore graph types including: pie, bar, sideways bar,100% stacked bars, and waterfall chart
* Use multiple worksheet tips
* Protect Excel data from changes
* Compare two Excel files to determine what has changed

UPCOMING SCHEDULED COURSES
DATE NAME LOCATION ORGANIZATION PUBLIC/PRIVATE CREDITS
04/06/17Excel Hot Topics and Best Practices for CPAsThe Loyola Graduate Center TimoniumMaryland Association of CPAsPublic4.0
11/02/17TNCPA Excel Hot Topics and Best Practices for CPATennessee Society of CPAs BrentwoodTennessee Society of CPAsPublic8.0
Download the 2016 Business Learning Institute Course Catalog DOWNLOAD PDF
Business Learning Institute - Course Catalog
SUBSCRIBE TO THE BLI BLOG