Course description
On this course, you will learn how to improve the presentation of your data. This course will introduce you to the basics of creating and formatting charts, as well as helping you understand the different types of charts available within Microsoft Excel.
Additionally you will also learn how to create PivotTables and Pivot Charts, which are incredibly powerful analysis features in Microsoft Excel. This is a great course to follow on from the Online Excel Fundamentals for Real Estate Professionals course.
Upon completion of this course, students will be able to:
- Have an in-depth understanding of all the “insert function” tab features
- Learn the functionalities of different charts
- Understand which chart will suit your data
- Be able to edit and label your charts
- Learn how to create a pivot table
- Improve your presentations by using visualisation techniques.
Included in the Course
- A Bayfield Training Certificate
- 12 Months Access to the Digital Platform
- Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Upcoming start dates
Suitability - Who should attend?
- Professionals who utilise Microsoft Excel
- Customer Service Employees
- Junior employees
- Graduates
Training Course Content
Module One: Exploring the Insert Function
- Tables, Illustrations and Add-ins
- Charts, Tours and Sparklines
- Filters, Links, Comments, Text and Symbols
Module Two: Understanding basic Excel Chart concepts
- Excel Chart elements
- Excel Chart types
Module Three: How to edit a chart
- Add Chart Titles, Data Tables and where to position the Chart legend.
- Display Chart Gridlines and Data Table
- Change the Chart Layout, Style, Type and Source data
Module Four: PivotTable and PivotChart
- PivotTables
- Creating a PivotTable
- Working with PivotTable values
- Creating a PivotChart
Why choose Bayfield Training
Over 25 years in business
Original Content, Unique Delivery
+90% courses review rating from past delegates
Customer Outreach Award 2019
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Expenses
Online: £200 +VAT
Number of days: 4-6 Hours
Course type: Microsoft Excel Fundamentals Level 2
Pre-requisite: Excel Fundamentals for Real Estate Professionals
Request info
Bayfield Training - Real Estate Executive Education
Bayfield Training is a prominent global supplier of investment grade Real Estate executive education. Having begun 25 years ago as pioneers in the field of Real Estate Financial Modelling, today Bayfield has a huge extended network of experts, specialists and...