Loading Events

« All Events

Excel part 3: Automating Excel with Macros and Analysis Tools

May 27 @ 9:00 am - 5:00 pm

Course Content

Module 1: Working with Multiple Worksheets and Workbooks 

  • Working with Named Ranges
  • Link Cells Across Worksheets and Workbooks
  • Use 3D References to Calculate Across Worksheets
  • Consolidate Data

Module 2: Use Formula Auditing and Error Checking

  • Reveal Formulas
  • Trace Cell Precedents and Dependents
  • Locate Errors in Formulas
  • Watch and Evaluate Formulas

Module 3: Reviewing and Protecting Workbooks 

  • Control Data Entry via Data Validation
  • Protect Workbook Access
  • Protect Worksheets and Cell Content
  • Add and Edit Comments
  • Prepare a Workbook for Distribution
  • Modify Excel's Default Settings

Module 4: Using Macros to Automate Workbook Functionality

  • Create Macros via Recording
  • Run Macros via Buttons and Shortcuts
  • Assign Macros to the Quick Access Toolbar and Ribbon
  • Assign Macros to Objects
  • View Macro Code

 Module 5: Forecasting and Analysis Data

  • Use Conditional Formatting to Highlight, Sort and Filter Key Data
  • Advanced Conditional Formatting using Formulas
  • Create Sparklines to Visualise Data
  • Add Trendlines to Charts to Visualise and Forecast Trends
  • Use Data Tables and Scenarios to Project Potential Outcomes
  • Use Goal Seek to Calculate Outcomes
  • Forecast Data Trends Using Solver

IA Members €140

Book your place by emailing maureen@dppskillnet.ie

Details

Date:
May 27
Time:
9:00 am - 5:00 pm
Event Categories:
, , , ,

Organiser

Design, Print & Packing Skillnets
Email:
maureen@dppskillnet.ie
Website:
http://dppskillnet.ie/index.php/events/adobe-photoshop-cs6/

Venue

New Horizons
22 – 24 Great Strand Street
Dublin 1, Ireland
+ Google Map

Skip to toolbar