microsoft word and excel for engineers - homepages · microsoft wrdo microsoft excel microsoft word...

Microsoft WordMicrosoft Excel

Microsoft Word and Excel for Engineers

Georey Hudson Graham Hawkesworth

2010-2011

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Outline

1 Microsoft WordEquation EditorStylesTable of ContentsList StylesTable Styles

2 Microsoft ExcelTable StylesGraphsFunctions and equationsConditional Formatting

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Outline

1 Microsoft WordEquation EditorStylesTable of ContentsList StylesTable Styles

2 Microsoft ExcelTable StylesGraphsFunctions and equationsConditional Formatting

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Why Equation Editor is Important

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Clicky Clicky method

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Typey Typey method

Word Command Output

\times ×\pm ±\mp ∓\ge ≥\le ≤

\degree

\therefore ∴\because ∵

\Re <\bullet •\alpha α\omega ω\Omega Ω\zeta ζ

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Why use Styles?

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Why use Styles?

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Why use Styles?

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Automatic Table of Contents (Another reason to use Styles)

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Automatic Table of Contents

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Automatic Table of Contents

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Change the Numbers

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Change the Numbers

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Change the Numbers

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Equation EditorStylesTable of ContentsList StylesTable Styles

Pretty colours everywhere!

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Outline

1 Microsoft WordEquation EditorStylesTable of ContentsList StylesTable Styles

2 Microsoft ExcelTable StylesGraphsFunctions and equationsConditional Formatting

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Pretty colours everywhere! Again...

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Pretty colours everywhere! Again...

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Matlab Vs Excel

Matlab

Better able to manipulate

the numbers before

plotting

Easier to do more complex

plots such as 3D plots

Excel

Simpler to use with

smaller data sample that

do not require

manipulating before hand

Easier to export the data

used into various other le

formats

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Styling your Graph

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Styling your Graph

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Styling your Graph

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Styling your Graph

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Styling your Graph

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Styling your Graph

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Styling your Graph

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Insert Function

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Making some cells stand out

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Making some cells stand out

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers

Microsoft WordMicrosoft Excel

Table StylesGraphsFunctions and equationsConditional Formatting

Making some cells stand out

Georey Hudson, Graham Hawkesworth Microsoft Word and Excel for Engineers