ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.
5/3073391.jpg5/5763717.jpg5/5275115.jpg5/4485510.jpg

Our highly effective computer training courses designed for Architects will help to guide your staff by enhancing their current skills and improving their overall productivity.

Microsoft Excel for Architects (Advanced)

7 Self Directed Learning Hours

Overview

If you have ever had to make a decision based on manually tracked data, you will greatly benefit from this workshop! You will learn, by using Electronic forms you can save hours of time, giving you a better scope for decision making and improve communications between departments.

Discover how to capture and link data from different files, track changes and create simple macros. Become educated in auditing and tracking data and data validation. Understand about file security. These features save hours of manual effort and help keep numbers confidential.

Gain a better comprehension of consolidating data from disparate reports, master the ability to create, analyze and compare budget scenarios electronically. Discover the capacity to manipulate and analyze databases via pivot tables and to create management analysis reports. Microsoft Excel is an essential tool to learn for anyone tracking data.

Topics

  • Creating spreadsheets to last
  • Industry best practices for creating spreadsheets
  • Reviewing and Re-using Complex Spreadsheets
  • Consolidated Results
  • Filters: Live reporting and Analysis, Formulas
  • Subtotals: Static Reporting
  • Pivot Tables
  • Using Excel as a Database
  • Creating and Maintaining Macros
  • Complex Formulas
  • Linking other Workbooks - Best Practices
  • Templates, Forms and Tables of Information

Price: $329 + applicable taxes

Max Students: 12



Schedule

There are currently no sessions scheduled for this course. The course can be held at your site if you have a minimum of five people interested in taking the course. Please contact us for details.

ES Computer Training Workshops, continuing education, sessions, accredited courses for construction, finance, insurance, business.

© 2019 ES Computer Training, a division of ESCTT Inc. All Rights Reserved.