
Learn to tell compelling business stories with PowerPoint, Excel, and Word by mastering formatting, charts, master slides, storyline, and diagrams while reducing text, with quality checks and a course test.
Learn to use a primary font and a secondary font: Proxima Nova for content and Garamond for headers, and ensure color consistency with RGB values across PowerPoint slides.
Master PowerPoint slide design by using a slide master, cover page guidelines, and consistent headers and captions. Utilize icons, image labels, and uniform image sizing for clear, engaging visuals.
Explore when to use bar, line, and pie charts in PowerPoint, detailing axes, legends, data labels, primary and secondary axes, and sourcing data for clear visual communication.
Craft a clear storyline by organizing slides in a logical sequence that flows from city context to micro-market, campus, and amenities, turning a collection of facts into a coherent narrative.
Prioritize research for presentations, allocating roughly 70% of your time to quality data and tracking sources using Excel. Discard irrelevant data and craft a reader-focused, data-driven story in PowerPoint.
Explore formatting rules for financial modeling in Excel, including headings, formats, fonts, colors, lakhs and crores. Learn center across selection as an alternative to merge and do's and don'ts.
Learn essential Excel formulas and tools such as sumif, sumifs, vlookup, sumproduct, and offset, and use pivot tables for investment summaries and data analysis.
Explore edate and eomonth, filter, CAGR, data tables, and sensitivity analysis; master goal seek, iferror, count, and trace dependence and dependents for robust financial models.
Practice applying Excel basics, from formatting headers and decimal places to core formulas like if, vlookup, and pivot tables, to build muscle memory and a personal formula glossary.
Master basic word features for business letters and reports, including letterhead, headers and footers, tables, and track changes with comments.
Learn to perform quick quality checks across PowerPoint, Excel, and Word, using spell check (F7), remove circular references, break external links, and review with fresh eyes before sharing with stakeholders.
Storytelling and presentation is a key communication skill in business and being able to organise and present data in an effective manner makes good professionals great! Knowing your way around the basic tools used in the business world which are the 3 programs available in the Microsoft office suite - Excel, PowerPoint and Word are absolutely crucial in ensuring work is done in a faster, more-efficient manner.
Through this course new real estate professionals will learn the basics of how to present work in a professional way and important tools and tips to increase speed and efficiency with everyday work.
The course includes:
1. Introduction to Formatting Rules and Font Library
2. Microsoft PowerPoint
- Master Slide Format and Cover Page
- Charts and their usage
- Storyline and articulation
- Research work and citing of sources / assumptions
3. Microsoft Excel
- Formatting Rules
- Important Formulas
4. Microsoft Word
- Letter / Report formats
5. Quality checks (incl 1 min for independent review, circular ref, external links, spell check before hitting send)
Through use of methods and techniques taught in this course students will be surprised to find the increase in speed and efficiency of completing tasks in Microsoft office and will also help enhance the readability and presentation of deliverables like reports, illustrations, letters, financial models, among others.
However, considering this is a short beginner course and serves as an introduction to some of the most basic tools, students are encouraged to continue to practice and learn from co-workers and advanced courses to continually improve themselves by learning new formulas and shortcuts.
Microsoft Office version used in this course: Version 16.71 for Mac