Ebooka przeczytasz w aplikacjach Legimi na:
Odsłuch ebooka (TTS) dostępny w abonamencie „ebooki+audiobooki bez limitu” w aplikacji Legimi na:
Ebooka przeczytasz na:
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
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
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.
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.
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
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 the cell you want to use in your formula.
Insert a New Worksheet
To insert a new worksheet;
Click on the insert worksheet icon in the name tab at the bottom of the worksheet or use Shift+F11
You can then rename the new worksheet if you want.
Rename a Worksheet
To rename a worksheet;
Right-click on the worksheet name e.g. Sheet1 and Click rename from the option list or double-click the sheet name.
The name will be selected and you can now write the new name.
Click anywhere inside the worksheet.
Delete a Worksheet
To delete or remove a worksheet from a workbook;
Right-click on the worksheet name e.g. Sheet1.
Click delete from the option list.
Move a Worksheet
To move a worksheet within a workbook;
Right-click on the worksheet name e.g. Sheet1.
Select the position you want to move it to from the dialog box.
Click the Ok button.
Hide a Worksheet
To hide a worksheet within a workbook;
Right-click on the worksheet name e.g. Sheet1.
Right-click
Click “Hide” from the option list.
To unhide the hidden worksheet, right-click on any other worksheet and click “Unhide” from the option list.
Select the cell you want to unhide from the dialog box and then click the OK button.
Merge Cells
To merge cells;
Select the range of cells you want to merge.
Go to Home>Alignment tab>Click on the drop-down arrow on “Merge & Center” icon.
Click on the type of merge (Merge Across, Merge & Center, Merge Cells and Unmerge Cells.
Unmerge Cells
To unmerge cells;
Opinie o ebooku Microsoft Excel - Steven Bright