Course: Advanced Excel Wizardry – 4 training hours

Whether you are a beginning or advanced Excel user, this course will demonstrate how you can be more efficient, productive and improve your presentations.

Topics covered in the course include:
– Formatting
– Making stunning custom graphs
– Key formulas
– Database normalization
– Using Pivot Tables
– Using Goal seek to find the solution
– Conditional formatting as a tool to make legible and cool looking spreadsheets
– Creating macros to make your spreadsheet work more efficiently

* bringing a laptop with any version of Microsoft Excel is highly recommended

An example of an apartment dashboard tool created in Excel:
AdvancedExcelWizardryExample

Register for this or any other course at www.canteraconsultants.com/cca2015 .

Additional information about your international award winning instructor can be found at www.toddclarke.com

Course: Ethical use of Social Networking and today’s latest technology

This day long course covers the ins/outs of navigating the social networking minefield as well as the latest in technology and how to use it to make you more efficient in your daily work.

Learn how to:
– Develop a social networking policy for you and your agents
– Determine which social networking tools will work best with your customers
– How to tap in to the Gen Y market and what they are looking for in terms of information and content
– What software and tools you can use to manage social networking
– How to engage clients using social networking
– What tools you need to take your office paperless
– The latest in market trends and how they impact your business
– The latest tech to separate the time wasters from those tools that can make you more efficient
– How to make your iPad or Droid tablet an effective marketing/presentation and business tools (including top apps)
(You can see Todd Clarke and Todd Kuhlman present over 100 mobile apps in 90 minutes at the national CCIM conference in Denver, CO – click here – https://www.youtube.com/watch?v=Wjj3bhxHS44)

One of my former students kindly offered this testimonial:

“Todd’s got his eye on the ball when it comes to technology. He knows what works and perhaps more importantly knows what doesn’t work and can help you steer away from traps.” – Richard E. Juge, CCIM, SIOR (National CCIM president 2010)

Register for this or any other course at www.canteraconsultants.com/cca2015 .

Additional information about your international award winning instructor can be found at www.toddclarke.com

Course: Confessions of a Commercial Real Estate Consultant – 8 hours of CE training

The course is hands on discovery course that covers how you can offer additional non-transaction services to your clients and shift some of your income from commissions to assignment or hourly fees.

Additional topics include:
– Where does a consultant add value?
– How to negotiate services and pricing
– Discovering hidden value in clients properties
– Common services offered by consultants
– Overview of market feasibility, site/location feasibility, financial feasibility and political/legal feasibility in the development process
– Discussion on running stakeholder meetings and/or focus group sessions
– Information resource for assignments
– How to avoid conflicts of interest
– Skill sets and experience levels required
– S.W.O.T. analysis of your potential to migrate some of your business away from commission based to pre-paid hourly engagements

Register for this or any other course at www.canteraconsultants.com/cca2015 .

Additional information about your international award winning instructor can be found at www.toddclarke.com