• 1800 111 274
  • Contact
  • Search
  • Login
  • Find a Property Professional
  • Become a Member
  • The Hub
    • 2021 AGM HubFind all the latest information on our upcoming Board elections, Annual General Meeting, and any upcoming motions.
    • Student HubWant to kickstart your career in the property industry?
    • COVID-19 HubFind all of our communications in response to COVID-19.
    • Professional Indemnity Insurance HubFind out what the API is doing to support our Members.
    • The HubThe Hub of all API articles, alerts, videos and more.
  • About
    • About APILearn more about about our Organisation, what we do and where we came from.
    • Our StaffFind out who does what within our teams.
    • API Ltd Board & GovernanceCommitted to operating in the best interests of our Members.
    • Our CommitteesEnsuring API remains firmly connected to the property industry.
    • Media CentreSubmit an enquiry with us or sign up to our mailing list.
    • Annual ReportsFind our comprehensive collection of annual reports from previous years.
    • Work for the APISee what positions we currently have vacant within our organisation.
  • Membership
    • API MembershipBecome an industry recognised professional today!
    • Which membership is right for you?See which option is best to progress your career in the property industry.
    • Member RewardsAPI Members are entitled to receive multiple benefits from a range of companies and brands.
    • Re-admission to MembershipBegin your application process to re-apply for API Membership.
    • CommunityStay connected within the property industry outside of education opportunities.
  • Education
    • Events, Webinars and Online CoursesSee what CPD opportunities API currently has on offer.
    • CPD Rules & RequirementsFind out everything you need to know about CPD obligations and policy.
    • SpecialisationSee how you can progress your career by specialising within API.
    • CertificationsBuild your career with our specialised certifications, and find out where a career in property can take you.
    • Practical Valuation TrainingThe new PVT Program ensures that all applicants for RPV or CPV are well prepared for transition from student to a professional Valuer.
    • Accredited CoursesSee which universities offer API Accredited Courses and kick start your property career today!
  • Standards
    • Professional MisconductFind out more about our Misconduct processes and procedures.
    • TIPs and Guidance NotesFind what you’re looking for with our handy quick access links!
  • Products & Services
    • PropertyPROAccess current information, documentation and previous editions of the PropertyPRO Supporting Memorandum.
    • Cyber SolutionAPI’s robust risk management solution for cyber security regulations.
    • APIVUnderstand the purpose of the company and its value to practicing valuer Members of API.
    • APIXLearn more about the API Property Exchange.
    • ValcoverProviding a stable insurance environment and increased certainty regarding Professional Indemnity.
    • Valuer NominationsFind documents for rental determinations and rent reviews to nominate a Chair.
    • TextbooksAPI offers a wide range of textbooks for our students studying property.
  • Our Profession
    • AwardsFind our list of industry awards and previous award winners.
    • AdvocacyFind out what API is doing for the property industry and community.
    • Research / ScholarshipsAPREF is the research arm of the API and supports the growing of our industry knowledge.
    • Request to change Company NameChange or update your employer or company name for your member profile.
    • Careers in PropertyFind out what positions are vacant in the property industry at our Career Centre.
  • The Hub
  • About
  • Membership
  • Education
  • Standards
  • Products & Services
  • Our Profession
    • 1800 111 274
    • Contact
    • Search
    • Login
    • Find a Property Professional
    • Become a Member
    • Call 180 111 API
  • The Hub
  • 2021 AGM Hub
  • Student Hub
  • COVID-19 Hub
  • Professional Indemnity Insurance Hub
  • The Hub
  • About
  • About API
  • Our Staff
  • API Ltd Board & Governance
  • Our Committees
  • Media Centre
  • Annual Reports
  • Work for the API
  • Membership
  • API Membership
  • Which membership is right for you?
  • Member Rewards
  • Re-admission to Membership
  • Community
  • Education
  • Events, Webinars and Online Courses
  • CPD Rules & Requirements
  • Specialisation
  • Certifications
  • Practical Valuation Training
  • Accredited Courses
  • Standards
  • Professional Misconduct
  • TIPs and Guidance Notes
  • Products & Services
  • PropertyPRO
  • Cyber Solution
  • APIV
  • APIX
  • Valcover
  • Valuer Nominations
  • Textbooks
  • Our Profession
  • Awards
  • Advocacy
  • Research / Scholarships
  • Request to change Company Name
  • Careers in Property
Home / Events, Webinars & Online Courses / Excel Skills Workshop Series – Full Series

Excel Skills Workshop Series – Full Series

Description

Presented by First for Knowledge on behalf of API, this workshop series will consist of 3 hours filled with techniques and tips to increase your confidence and knowledge in Excel.

These workshops were held on 1 October, 21 October and 12 November 2020.

Want to register for individual workshops instead?

  • Please click here to register for Workshop 1 only
  • Please click here to register for Workshop 2 only
  • Please click here to register for Workshop 3 only

Workshop 1

Are you a regular Excel user who is self-taught or has not had formal training in recent versions of Excel?

This workshop with help you achieve more, faster and easier. Effective, well presented Excel spreadsheets will enhance your credibility and impress your clients. Register now to catch up and brush up your skills in Excel and work smarter not harder.

What you will learn

  • Pros and cons of working in different Excel environments
  • Best practices for setting up Excel spreadsheets
  • Creating effective formulas using cell referencing
  • Working with multiple sheets
  • Use Flash fill to merge or separate data

Workshop 2

Data is readily available; in fact, we’re often inundated with it. But data is meaningless unless we can interpret that data and communicate the message persuasively and confidently.

This workshop with help you tame large amounts of data so you can analyse the information and then communicate your findings with clarity and impact. Register now to increase your data analysis and presentation skills.

What you will learn

  • Sorting and filtering data for analysis
  • Using Conditional Formatting
  • Creating Data Tables
  • Getting started with Pivot Tables and Pivot Charts
  • Creating charts including line, column, pie and combo

Workshop 3

Are you a ready to move beyond basic formulas and functions? Learn to create user proof spreadsheets for financial modelling.

This workshop with extend your skills and build your confidence in working with calculations. Building on basic skills you will learn techniques to create sophisticated spreadsheets. Register now to master essential skills for financial modelling.

What you will learn

  • Creating and working with named ranges
  • Setting up Data Validation
  • Creating financial functions (PV, FV, PMT)
  • Creating logical functions (IF)
  • Creating a lookup functions (VLOOKUP)

What you will get for each episode

  • Opportunity for hands on practice
  • Exercise files for during and post-workshop practice
  • Keyboard shortcuts
  • Reference guide

Requirements

  • Windows based PC or laptop
  • Microsoft Excel
  • Browser – we recommend Google Chrome
  • Optional – Dual monitors – If available

Pre-Requisites

Basic computer literacy (ability to create, name, save, open and close files).

Pricing

Member Prices
$180
Non Member Prices
$285
Student Prices
$120

All fees include GST

Log in to view your member pricing
Not a member? Enquire about joining today

Presenters

Kim McKillop - Founder and Owner, First for Knowledge

Founder and owner of First for Knowledge, Kim has extensive experience in designing and delivering training.

 

Her skills include end-user technical training, facilitating professional development skills and technical writing. As an accomplished facilitator Kim has worked with individuals and companies Australia wide as well as in New Zealand, Singapore and Vietnam.

Webinar details

Event type

Recorded

CPD Points

3

Buy Tickets

Location

Online - Webinar Recording


Contact Information

Nicolle Stubbs

Events and Conference Officer

1800 111 274
education@api.org.au

Related

Webinar Recording

ACT Industry Forum – Episode 2 – Commercial Property Market Update

CPD Points: 1

The second event in the ACT Industry Forum webinar series will explore the cyclical and structural implications for Canberra's commercial property markets.

Webinar Recording

ACT Industry Forum: Episode 3 – ACT and Local Region – Residential Market Update

CPD Points: 1

For the final event in the ACT Industry Forum webinar series, we will discuss Canberra's housing market being the quiet achiever in a number of sectors throughout COVID in 2020.

Webinar Recording

Excel Skills Workshop 1 – Working Smarter, Not Harder in Excel

CPD Points: 1

This workshop will help you achieve more, faster and easier. Effective, well presented Excel spreadsheets will enhance your credibility and impress your clients.

Webinar Recording

ACT Industry Forum – Full Series

CPD Points: 3

Join us for the ACT Industry Forum event series where our speakers will discuss the ACT economy and how it interacts with the national economy, the commercial property market and the residential market in ACT and the local region.

Webinar Recording

Economic Indicators – Implications for the 2021 Property and Finance Markets

CPD Points: 2

Economic Indicators 2021 explored the forecasts and implications to the property and finance markets. The projections are now strongly indicating a U-shaped recovery.

Webinar Recording

NSW Property Market Outlook 2021 Residential

CPD Points: 2

In this webinar recording, our panel of experts unpack the year that was 2020 and look at the trends that we can expect to see in the residential sector in 2021.

  • Find a Property Professional
  • Become a Member
  • 1800 111 API
  • Contact
  • Search
  • Login

  • The Hub
    • 2021 AGM Hub
    • Student Hub
    • COVID-19 Hub
    • Professional Indemnity Insurance Hub
    • The Hub
  • About
    • About API
    • Our Staff
    • API Ltd Board & Governance
    • Our Committees
    • Media Centre
    • Annual Reports
    • Work for the API
  • Membership
    • API Membership
    • Which membership is right for you?
    • Member Rewards
    • Re-admission to Membership
    • Community
  • Education
    • Events, Webinars and Online Courses
    • CPD Rules & Requirements
    • Specialisation
    • Certifications
    • Practical Valuation Training
    • Accredited Courses
  • Standards
    • Professional Misconduct
    • TIPs and Guidance Notes
  • Products & Services
    • PropertyPRO
    • Cyber Solution
    • APIV
    • APIX
    • Valcover
    • Valuer Nominations
    • Textbooks
  • Our Profession
    • Awards
    • Advocacy
    • Research / Scholarships
    • Request to change Company Name
    • Careers in Property

  • Media Centre
  • FAQs
  • Terms & Conditions
  • Privacy Policy
  • Website Feedback & Improvements

Digital Agency Brisbane - Vivo Group