14.4: Part IV- Office Professional Applications

Last updated
Save as PDF

Page ID: 36474

$ \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $

$ \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} $

$ \newcommand{\id}{\mathrm{id}}$ $ \newcommand{\Span}{\mathrm{span}}$

( \newcommand{\kernel}{\mathrm{null}\,}\) $ \newcommand{\range}{\mathrm{range}\,}$

$ \newcommand{\RealPart}{\mathrm{Re}}$ $ \newcommand{\ImaginaryPart}{\mathrm{Im}}$

$ \newcommand{\Argument}{\mathrm{Arg}}$ $ \newcommand{\norm}[1]{\| #1 \|}$

$ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$

$ \newcommand{\Span}{\mathrm{span}}$

$ \newcommand{\id}{\mathrm{id}}$

$ \newcommand{\Span}{\mathrm{span}}$

$ \newcommand{\kernel}{\mathrm{null}\,}$

$ \newcommand{\range}{\mathrm{range}\,}$

$ \newcommand{\RealPart}{\mathrm{Re}}$

$ \newcommand{\ImaginaryPart}{\mathrm{Im}}$

$ \newcommand{\Argument}{\mathrm{Arg}}$

$ \newcommand{\norm}[1]{\| #1 \|}$

$ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$

$ \newcommand{\Span}{\mathrm{span}}$ $ \newcommand{\AA}{\unicode[.8,0]{x212B}}$

$ \newcommand{\vectorA}[1]{\vec{#1}} % arrow$

$ \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow$

$ \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $

$ \newcommand{\vectorC}[1]{\textbf{#1}} $

$ \newcommand{\vectorD}[1]{\overrightarrow{#1}} $

$ \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} $

$ \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} $

$ \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $

$ \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} $

$\newcommand{\avec}{\mathbf a}$ $\newcommand{\bvec}{\mathbf b}$ $\newcommand{\cvec}{\mathbf c}$ $\newcommand{\dvec}{\mathbf d}$ $\newcommand{\dtil}{\widetilde{\mathbf d}}$ $\newcommand{\evec}{\mathbf e}$ $\newcommand{\fvec}{\mathbf f}$ $\newcommand{\nvec}{\mathbf n}$ $\newcommand{\pvec}{\mathbf p}$ $\newcommand{\qvec}{\mathbf q}$ $\newcommand{\svec}{\mathbf s}$ $\newcommand{\tvec}{\mathbf t}$ $\newcommand{\uvec}{\mathbf u}$ $\newcommand{\vvec}{\mathbf v}$ $\newcommand{\wvec}{\mathbf w}$ $\newcommand{\xvec}{\mathbf x}$ $\newcommand{\yvec}{\mathbf y}$ $\newcommand{\zvec}{\mathbf z}$ $\newcommand{\rvec}{\mathbf r}$ $\newcommand{\mvec}{\mathbf m}$ $\newcommand{\zerovec}{\mathbf 0}$ $\newcommand{\onevec}{\mathbf 1}$ $\newcommand{\real}{\mathbb R}$ $\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}$ $\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}$ $\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}$ $\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}$ $\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}$ $\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}$ $\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}$ $\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}$ $\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}$ $\newcommand{\laspan}[1]{\text{Span}\{#1\}}$ $\newcommand{\bcal}{\cal B}$ $\newcommand{\ccal}{\cal C}$ $\newcommand{\scal}{\cal S}$ $\newcommand{\wcal}{\cal W}$ $\newcommand{\ecal}{\cal E}$ $\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}$ $\newcommand{\gray}[1]{\color{gray}{#1}}$ $\newcommand{\lgray}[1]{\color{lightgray}{#1}}$ $\newcommand{\rank}{\operatorname{rank}}$ $\newcommand{\row}{\text{Row}}$ $\newcommand{\col}{\text{Col}}$ $\renewcommand{\row}{\text{Row}}$ $\newcommand{\nul}{\text{Nul}}$ $\newcommand{\var}{\text{Var}}$ $\newcommand{\corr}{\text{corr}}$ $\newcommand{\len}[1]{\left|#1\right|}$ $\newcommand{\bbar}{\overline{\bvec}}$ $\newcommand{\bhat}{\widehat{\bvec}}$ $\newcommand{\bperp}{\bvec^\perp}$ $\newcommand{\xhat}{\widehat{\xvec}}$ $\newcommand{\vhat}{\widehat{\vvec}}$ $\newcommand{\uhat}{\widehat{\uvec}}$ $\newcommand{\what}{\widehat{\wvec}}$ $\newcommand{\Sighat}{\widehat{\Sigma}}$ $\newcommand{\lt}{<}$ $\newcommand{\gt}{>}$ $\newcommand{\amp}{&}$ $\definecolor{fillinmathshade}{gray}{0.9}$

Office Suites

Microsoft® Office 365® products are the most common office applications used in business firms, and students and professionals alike will need skills using them. The following list names each of the Office 365® applications (apps) with their corresponding functions.

Word® = word processing for writers of narrative text, and also includes advanced features such as tables, graphics, spell-check, and advanced formatting.
Excel® = tables (spreadsheets) for mathematical functions, such as calculations and reports, and includes powerful automatic features.
PowerPoint® = slides used for presentations, and includes formatting, graphics, and design elements.
Outlook® = email sending, receiving, and storage with integrated calendar (with reminders) and contact list.
Publisher® = desktop publishing with graphics, layout, and design tools to create flyers and illustrations.
Access® = database designer with complex capabilities to create and build custom-designed databases.
OneNote® = note-taking screen that includes typing text, writing with a stylus, and recording video and audio.

Google has a suite of similar products, including word processing, spreadsheets, and presentation slides. Google Docs is the word processing app; Google Sheets is the spreadsheet app; and Google Slides is used for presentations. All of the products can be started or opened through Google Drive.

Word Processing

While Microsoft® may be the most popular type of word processing software for business, Google also has a word processing application popular for personal use. One of the primary differences is that Microsoft® products must be purchased, while Google apps are free.

Differences between the two word processing applications, Microsoft® Word® and Google Docs, follow.

Microsoft® Word®

Purchase from Microsoft®
Advanced features
APA citations and references available

Google Docs

Free via Google Drive
Simple features
APA citations and references not available

Students may be able to access Microsoft® Word® (different versions / student version) by various methods:

Bundled with a computer when initially purchased.
Purchased online from Microsoft® (annual or monthly fee).
Use a student version online (free or purchased, depending on the college).

Also, for students who attend participating colleges, Microsoft® Office 365® can be downloaded free from Microsoft:

https://www.microsoft.com/en-us/education/products/office

Microsoft® Office 365 can be purchased for monthly, annual, or one-time fees directly from the Microsoft® website:

Office Home and Student 2021 one-time purchase for PC or Mac $149.99
Microsoft 365 Personal subscription for PC or Mac $69.99/year
Microsoft 365 Family subscription for PC or Mac $99.99/year

https://www.microsoft.com/en-us/microsoft-365/buy/compare-all-microsoft-365-products

Practice Zone

One useful feature of Google apps is that documents are easily shared and worked on by more than one person. Create and share a document using Google Drive and Google Docs.

Spreadsheets

As with word processing, Microsoft® Excel® continues to be the most popular spreadsheet software for business. Individual spreadsheets are called worksheets, and documents with multiple worksheets are known as workbooks. For personal or student use, Google Sheets is one of the most popular, and it’s free.

Examples of using spreadsheet applications for students include:

Budgeting: Track income and expenses to manage personal finances. Create categories for different spending areas (food, entertainment, transportation) and record income from allowances or part-time jobs. Use formulas to calculate totals and analyze spending habits.
Assignment/GradeTracker: Monitor academic performance across different subjects. Create a table with columns for course name, assignment name, due date, earned points, and possible points. Use formulas to calculate percentages and track overall grades for each course.
Charts and Graphs: Create charts and graphs for research papers and other assignments.

Examples of using spreadsheet applications in real estate include:

Client Lead Tracking: Organize and manage potential client information. Create a spreadsheet with columns for client names, contact details, property interests (e.g., size, location, price range), and notes from interactions.
Listing Comparison: Compare key features of different properties for sale. Create a table listing properties with columns for address, asking price, square footage, number of bedrooms/bathrooms, amenities, and agent contact information.
Profit Estimating: Estimate potential revenue, expenses, and profits on investment property.
Mortgage Calculating: Calculate principal and interest for mortgage payments; compare interest rates.
Commission Calculating: Compute and track commission payments.

To become proficient in computer software and applications necessary for professional business career success, students will need to learn and practice important skills while they are in college. Microsoft® offers many training segments online, including YouTube videos, which students can watch or listen to. Some recommended resources for students to learn and become proficient with Microsoft® 365® products include:

Getting help with Microsoft® 365 tutorials and training

Microsoft® 365 online training site
Microsoft® 365 channel - YouTube video tutorials
Your college technology center or help desk

Microsoft® 365 Online tutorials and training

Video Tutorials for Microsoft® Word® (playlist)

https://www.youtube.com/watch?v=2H5XG4ZNuD0andlist=PLXPr7gfUMmKwYuvq-VCwcxmpGm2hlqOWi

Video Tutorials for Microsoft® Excel® (playlist)

https://www.youtube.com/watch?v=NRUuKafamxEandlist=PL66F62F9E936D9077

Presentation Software

A third important type of software is the presentation software, commonly known as slides or slide deck. Students use these for class presentations. In real estate, presentations are commonly used by real estate agents to present marketing and property information to a potential seller. Other popular uses include marketing a listing and, for real estate brokers, recruiting agents or weekly training classes. While Microsoft® PowerPoint® is the business standard for presentation software, other popular apps include Keynote, Prezi, and Google Slides.

Microsoft® PowerPoint®

Purchase from Microsoft®
Advanced features
Stock photos and license-free images available to insert in slides

Other Presentation Programs

May be free
Simpler features
Variety of templates and formats available

Practice Zone

Using Google Slides, prepare six slides related to your real estate career goals, or other life goals. Include at least two images. Keep the slides simple.

Tags recommended by the template: article:topic

Search

Text Color

Text Size

Margin Size

Font Type