Microsoft Office Productivity Pack: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint

Table of Contents

Microsoft Office Productivity Pack

Microsoft Excel

Image of Worksheet Solution

Image of Worksheet Solution

Image of Worksheet Solution

Microsoft PowerPoint

Microsoft Word

Sign up for Steven Bright's Mailing List

Microsoft Office Productivity Pack

Microsoft Excel, Microsoft Word, and Microsoft PowerPoint

––––––––

By

Steven Bright

––––––––

Copyright Steven Bright 2016

This eBook is licensed for your personal enjoyment only. It may not be re-sold or given away to other people.

––––––––

Also By Steven Bright:

JavaScript Fundamental: A Step by Step Guide

Photoshop Fundamental: The How of Photoshop

Tools and Function Lists: Engineering Tools Manual

CorelDRAW How: The Fundamental of CorelDRAW

Microsoft Word Fundamental: A Step by Step Guide

The Best of Microsoft PowerPoint: Brand Exposure Techniques

Computer Fundamentals: An Introduction to Computer Science

Hacking Through Microsoft Excel Skills: A Step by Step Approach

The ABC f eBook Publishing: Kindle Direct Publishing, Draft2Digital, Smashwords, Writing, Formatting, Creating an Active Table of Content, and Marketing Guide

Master Cascading Style Sheets (CSS) Quickly: CSS Properties, CSS Property Definitions, Inline CSS, Internal CSS, External CSS and Sample Codes

Amazon Kindle Direct Publishing Complete Guide: Account Opening, Formatting, Cover Design, Publishing, Promotion/Marketing, Get US Payoneer Bank Account to Receive Your Royalties

BUNDLE CONTENT

Introduction

Microsoft Excel Skills

Microsoft PowerPoint

Microsoft Word

About the Author

INTRODUCTION

This is a bundle of three books on Microsoft Excel, Microsoft PowerPoint and Microsoft Word. It will give you the opportunity to learn these Microsoft office programs in one single pack to enhance your productivity in their applications in business and in everyday life activities.

With a good knowledge of Microsoft Excel, you can create and manage data, create charts to demonstrate and analyze data, create an expense report or perform general financial account management, perform mathematical operations, and carryout statistical analysis.

With Microsoft PowerPoint, you can create, design and deliver presentations. It is a great tool that can be use to effectively promote a brand, a product or an organization.

With Microsoft Word, you will be able to professionally typeset or edit your manuscript or any other official or personal document, and then format it to the required standard. You can even convert the document to PDF using the export feature or print it.

Microsoft Excel

Microsoft Excel User Interface, Excel Basics, Function, Database, Financial Analysis, Matrix, Statistical Analysis

By

Steven Bright

––––––––

Copyright Steven Bright 2016

This eBook is licensed for your personal enjoyment only. It may not be re-sold or given away to other people.

––––––––

Also By Steven Bright:

JavaScript Fundamental: A Step by Step Guide

Photoshop Fundamental: The How of Photoshop

Tools and Function Lists: Engineering Tools Manual

CorelDRAW How: The Fundamental of CorelDRAW

Microsoft Word Fundamental: A Step by Step Guide

Web Design and Development Technology: Website How

Microsoft Office Productivity Pack: A Step by Step Guide

Computer Fundamentals: An Introduction to Computer Science

The Best of Microsoft PowerPoint: Brand Exposure Techniques

COMPUTER SOFTWARE: Categories, Functions and Associated Professions

The ABC of eBook Publishing: Kindle Direct Publishing, Draft2Digital, Smashwords, Writing, Formatting, Creating an Active Table of Content, and Marketing Guide

Master Cascading Style Sheets (CSS) Quickly: CSS Properties, CSS Property Definitions, Inline CSS, Internal CSS, External CSS and Sample Codes

Amazon Kindle Direct Publishing Complete Guide: Account Opening, Formatting, Cover Design, Publishing, Promotion/Marketing, Get US Payoneer Bank Account to Receive Your Royalties

TABLE OF CONTENT

HOW TO USE THE BOOK

INTRODUCTION

MICROSOFT EXCEL USER INTERFACE

EXCEL BASICS

CUSTOMIZING THE QUICK ACCESS TOOLBAR

FUNCTION

DATABASE

FINANCIAL ANALYSIS

MATRIX

STATISTICAL ANALYSIS

PUBLISH AS PDF or XPS

SHORTCUT AND THEIR FUNCTION

ABOUT THE AUTHOR

HOW TO USE THE BOOK

This book outlined step by step procedures for the most important tasks performed with Microsoft Excel. It is the product of practice and experience. It is a documentation of know-how and not just knowledge.

To get the best from it, you have to practice each and every step described here. So, install Microsoft Office, Open Excel and happily get to work.

INTRODUCTION

Microsoft Excel is one of the most popular and powerful spreadsheet applications. It is use to manage data, create charts, balance a checkbook, create an expense report, build formulas, carry out financial analysis, perform mathematical operations, and perform analysis of variance (ANOVA), regression, and other statistical Analysis.

MICROSOFT EXCEL USER INTERFACE

The main components of Microsoft Excel User interface are listed below, so that you will become familiar with them.

The Home Menu

The Data Menu

Page Layout Menu

The Clipboard Viewer

The Insert Menu

The Formulas Menu

The Review Menu

The View Menu

The Developer Menu

The Ribbon

EXCEL BASICS

In this section, I will be introducing you to Microsoft Excel basic tools which if well understood will ensure a good foundation for the remaining sections of this book.

Define Name

To define a name for a cell entry so that you can refer to that cell entry in a formula by that name, do the following:

Enter a value or data in the cell of your choice

Select that cell

Go to the Formula Menu

Click Define Name

In the define name dialog-box, type in the name you want to give to the cell in the Name space provided

Click OK.

To apply a named cell in a formula, do the following:

Type your formula in the formula bar as usual

When you get to the point you want to refer to the defined cell name, go to the Formula Menu

In the Name manager, click Use in Formula

From the list of named cells in the worksheet, click the defined name you have previously defined for