|
Volume 1, Issue , 26 10/31/2007 |
|
Visit Us Online! www.bytesavvy.com ■Training ■Disaster Planning & Recovery ■Web Design ■Software, Hardware & Network Solutions ■Video Conferencing |
|
Visit Us Online www.bytesavvy.com If you have questions or comments, or if you wish to be removed from our mailing list please e-mail us at debi@bytesavvy.com or call 406-257-5050 Byte Savvy Computing Services, LLC, 309 S. Main St. Kalispell, MT 59901 |
Microsoft Office Tip —Office Online Training |
|
Like a sheet of graph paper, an Excel spreadsheet is divided into rows and columns that intersect to create cells. Columns are labeled alphabetically (A, B, C...); rows are labeled numerically (1, 2, 3...). Both alpha and numeric data can be entered into the cells. Numeric data can be calculated, charted, or graphed.
In cell A3, enter the word Expenses. In cells A5 to Ax enter expense categories, such as mortgage or rent, phone, food, and entertainment. Adjacent to the expense categories, in cells B5 to Bx, enter projected expenses. In the cell below Bx (if x equals 25, this would be B26), enter the formula to total your expenses: =SUM(B2:B25) or click on the AutoSum symbol (Greek letter E) in the toolbar and hit Enter. Now the magic begins. Change any number in cells B2 to Bx and watch your expense total change.
Locking columns and rows If you want to freeze a row of titles or categories so that you can keep them in sight as you enter data further down your spreadsheet, Microsoft Excel has a handy Freeze Panes function. To lock a pane, use your mouse to select the row below or the column to the right of where you want to freeze. On the Window menu, click Freeze Panes
To read the rest of the tips go here. |
|
You may use Microsoft Excel to create spreadsheets, but do you take advantage of its viewing capabilities and create customized shortcuts or charts to let a picture tell your story? |
|
Excerpted from Microsoft.com article, “4 quick tips for using Excel” |
Top 3 digital shooting mistakes—and how to prevent them |
|
Excerpted from Microsoft.com article, “Top 3 digital shooting mistakes-and how to prevent them |
|
There are some cool features in Excel 2007, especially those surrounding formula's, formula shortcuts, conditional formatting and using pivot tables to call-out important data |
|
The Office Online training portal has some excellent training podcasts, videos and webcasts starting with this three part series. Complete two via the Office Genius portal and get a free t-shirt Use a PivotTable report to analyse and summarize your data Filter to hide and display selected data in Pivot-Table reports Advanced ways to use Excel PivotTable
|
|
Compact digital cameras are great devices, offering far more capabilities than conventional, film-based models. The increased versatility makes a high-tech camera very useful for serious image making. For the very best results though, it's important to recognize common mistakes and learn how to prevent them. That's the process I've gone through while testing many digital cameras. Fortunately, these common mistakes have been great teachers, prompting me to find creative solutions. I invite you to learn from my mistakes. To maximize your own enjoyment of digital imaging, consider the following common errors and preventative measures. |
4 quick tips for using Excel |