Questions

Questions people email in will go here.

Question:
What I would like to be able to do is tie the two worksheets together so that when I change a quantity on one page it will change the similar cell on the other page. I believe this is possible but I do not know how to do it or what to call it.

Answer:
The name of what you will be doing is called "Create a link to a cell in another workbook".  Its easy to do, a little awkward to explain.  Its almost as simple as linking to another cell in the same worksheet.  Example "=B2".  However you need to add the name of the 'source workbook' into the destination excel field.

Here is a example of linking to another workbook:

"=[EBAY Bookkeeping.xls]Sheet1'!$C$7."

Notice that the source workbook name is in brackets "[" and "]" followed by the source sheet name "Sheet1" followed by the specific cell info, the "$" make the focus lock on the row and column.

Depending on your version of Excel , this can also be accomplished by "PASTE SPECIAL - LINK" , copy the cell in the source workbook and then paste special - link in the destination cell.

This should be enough to help you get on your way.  If you have follow up questions please include the version of excel that you are using.

Conclusion

Conclusion

Microsoft Powerpoint

Microsoft Excel

Common File functions:
New
Save
Save As
Close
Print
Undo / Redo

Basic Formatting:
Bold
Italics
Underline
Align - Left, Center, Right
Font Type
Font Size
Font Color
Cell Color
Merge Cells
Number format -  Dollar, Percent, Decimal Places

Simple Formulas:
Addition
Subtraction
Multiplication
Division

Sum / Autosum
Average
Count
Min/Max

Find / Replace
Sort / Filter / Autofilter
Insert / Delete Row(s)

Simple Formulas

CELL FORMATTING

 

Spreadsheet Example - Phone Book

Spreadsheet Example - Check Book

 

Microsoft Word

Business Letter Example:

Microsoft basics

For some students, this may be your first exposure to the world of Microsoft or to a computer.  This blog post will contain some tips that will be useful throughout all of the programs we will learn about: Word, Excel and Powerpoint.


Navigation

1) The Start Button

2) Program Menu

3) Desktop Icons

4) The Cursor

3 Main Triggers:

• Left Click Once (sets focus)
• Left Click Once and Hold Down (and drag)
• Right Click (quick functions)

 

 

Universal Functions

5) New, Open, Save, Save As

6) Help

Introduction

Hello and welcome to New To Office.

I published this blog as a teaching and learning tool for the students of my Introduction to Microsoft Office class.  I encourage you to post any questions that you may have in the comments section below.

The class is held once a week for three weeks and each session is about 3 hours long.

The syllabus is roughly broken down as follows:

Week 1: Introduction to Microsoft and the MS Word program.
Week 2: Largely covers the Excel program, expect this class to last the entire 3 hours.
Week 3: We learn about the Powerpoint program and address any remaining questions about Word and Excel.

Attending all sessions, arriving on time,  and actively participating in class is critical for making the most out of this learning opportunity.

Any questions can also be emailed to me at john.duross.mba(at symbol)gmail.com

I look forward to seeing you in class.