Using MS Excel in Data Analyses

Microsoft Office

is an integrated software package that enables you to share information between several applications. The applications (also referred to as apps) available in Office are Word, PowerPoint, Excel, Access, Outlook, OneNote, Publisher, InfoPath, Lync, Project, SharePoint Workspace, and Visio. The applications are available on your computer depending on which Office suite is installed and the options that were selected during the installation. Microsoft offers several different Office suites, such as Office 365. Each suite offers a different combination of applications. Each Office application performs specific tasks. Table 1.1 provides a brief description of the Office 2013 applications available.

Access

A database application that enables you to organize, manipulate, and analyze information such as addresses and inventory data

Excel

a spreadsheet application that enables you to work with text, numbers, and formulas to create worksheets, tables, charts, and statistical analysis

OneNote

a digital notebook application that enables you to gather, manage, and search notes and information

outlook

an email and scheduling application that enables you to manage emails, contacts, appointments and events, and tasks efficiently

Powerpoint

a presentation application that enables you to create multimedia slide shows, outlines, organizational charts, handouts, and speaker’s notes

Publisher

a desktop publishing application that enables you to develop a brand identity and design professional-looking marketing materials such as brochures, calendars, signs, and posters

Word

a word-processing application that enables you to create edit, print, and share documents such as letters, memos, and reports