How to use Microsoft Office

Extract

[...] Microsoft shortcuts: Microsoft Excel: Excel is a general-purpose electronic spreadsheet. Spread-sheeting packages are most commonly used by computer users to organise, calculate, and analyse business data Applications: Reports Statement and financial positions Statement of comprehensive income "what-if" analysis Graphs Using Excel Excel is used to develop models where data is: Analysed Manipulated Processed into meaningful reports That data in Excel is: Easy to change Easy to apply in calculations With Excel: Only one value per cell (thus the new value entered will replace the previous value) Formulas and functions only display output of what is entered and not what you physically entered. [...]

[...] Numerical or alphanumerical numbers Formulas Alphanumerical data: Letters or numbers or combinations Abcde or 1234 or abc123 Numerical data: Only numerical values 1234 Headers and footer: Date on pages Pages in numerical order Headlines on pages Printing headings: If you want certain rows or columns to be shown on each printed page You don't have to type out the heading on each page every time Page layout/ page setup/ dialogue box/ sheet tab If numerical values are too big for a cell, this will show: 1.23E + 11 To fix this: Enlarge the column Double click on the line to the right of the column Wrap text: When text is typed into a cell, it can be too long to fit into one cell and go over into the next cell. It can be a problem when data is also entered into the adjacent cell. To ensure that the content is visible, text can be shown on several lines in a cell It is known as "wrapping text". [...]

[...] How to use Microsoft Office The Different Types of Software Microsoft Word: It is a word processing package used to create, revise, save and print different kinds of documents It also incorporates tools such as spell check and the ability to move or copy text from one document to another It allows you to choose from various available templates, including reports, calendars, resumes, invitations, and many others. Microsoft PowerPoint: It is a software program that allows you to create multimedia presentations, to enhance your oral presentation and to keep the audience focused on your subject. You can create and display sets of slides that combine text with drawn objects, clip art, photos, sound, video and even animated special effects. [...]

[...] Communicate data visually Communicate clearly and effectively Present large/complicated data in understandable visual format Summarise data / give an overview Make it memorable The key is to SIMPLIFY To present relationship, clear pattern or trend in the data To present that there is NO relationship, clear pattern or trend in the data To summarise findings in an easy-to-read, understandable format Reinforce arguments by the facts Ensure the reader sees, understands and remembers the facts The Charts in Excel Different types of charts in Excel: Column Line Pie Bar Area Scatter Plot) With graphs: The X axis = independent variable (the variable that you can change) The Y axis = dependent variable (depends on the x-axis) (the outcome is measured) Column chart: Categorical / discrete data (not continuous) Can compare to other data (categories) Can indicate time Steps: Arrange your data in columns and rows Select your data Insert Charts Column Select data source (choose what you put on which axis) Edit labels and names Line chart: Continuous amount of data Time series data Pie chart: Proportional data Percentages of a part that make up a whole Bar chart: Column chart sideways Can compare things over time Per Categories helpful when descriptions are long Area chart: Graphs similar to line graphs Can be used to track changes over time Stacked area chart shows cumulative amounts Scatter chart: Stock chart: Usually for stock prices Volume traded, high price, low price, closing price Surface chart: 3-D surface that connects data points Helpful to find optimum combinations between two sets of data Scientists and engineers use them Hard to read Bubble chart: Data points replaced by bubbles Size of bubbles represent a dimension of data Doughnut chart: shows the relationships of parts to a whole Can contain more than one data series Radar charts: Plots values around an axis Each data category has its own axis AND - OR - IF statements: Relative reference: A5=A1+A2 If this formula was copied to B5 the formula would automatically change to B5=B1+B2 The cell addresses change automatically in relation to the relative positions of the cells. Absolute reference: A5=$A$1+A2 If this formula was copied to B5 the formula would change to B5=$A$1+B2. [...]

[...] The $ sign makes the reference to A1 absolute Nothing is "in between" the $‐signs $-sign before column reference: the column stays the same $-sign before row reference: the row stays the same What is a function? built-in mathematical calculation in Excel Functions always start with an = sign When the references are defined, the function becomes a formula The result (answer) is displayed in the cell The actual formula is shown in the formula bar If function: Example: You are asked if you want to go to the beach. [...]