Excel Video

Apr16

Tagged in:, Comments: YourThoughts?

Make A Multiplication Table Using Microsoft Excel

selection arrow over keyboard keys

Create your multiplication table using Microsoft Excel by creating a workbook and typing the number 1 in cell B1. Grab the bottom right corner and press CTRL the same time and drag horizontally. You'll see Excel counting up until you reach the number that you want your table to go up to.

While your numbers are selected right-click inside of the selection and press copy. Move to cell A2, left click inside of the cell then right-click and then select paste-special. In the dialog box...

Share

Apr04

Tagged in:, Comments: YourThoughts?

Getting Started With Excel Part 3

windows users

Continuing with the previous Excel beginner tutorials series, this video builds on your new knowledge. You will be introduced to mathematical calculations, and operators. Shortcuts and tips and tricks will be demonstrated too.

How to make calculations with mouse clicks, selections and using the Excel Autosum feature.

Demonstration of using Excel to: Total, Average, Max, Min and Count.

Easy to follow and helpful video tutorial for beginners. Or, seasoned pros who need a...

Share

Feb05

Tagged in:, Comments: YourThoughts?

How To Make A Gantt Chart Using Microsoft Excel

computer screen changing appearance with single indicator bar

Henry Gantt is responsible for the "gantt chart" so popular today. He created many different charts designed basically so anyone interested in project management could see where a project had been, where it should be when completed, and it's current status.

Gantt charts are very flexible and you can track tasks whether performed by machine or men or a combination of both.

This video explains the process of making a gantt chart in an Excel worksheet. A couple of helpful hints on...

Share

Feb05

Tagged in:, , Comments: YourThoughts?

How To Use A Formula In An Excel Worksheet

kllckety

Some simple Excel formulas based on a hypothetical business situation. Also, some basic formula syntax.

The speaker has a cough but makes formulas simple and easy in his demonstration.

He covers how to set up your worksheet, then shows us some handy shortcuts and areas to watch out for.

Share

Feb04

Tagged in:, Comments: YourThoughts?

Getting Started With Excel Part 2

source moc

Excel basics are tought in this tutorial including entering data, editing data, changing column widths, rows and Autofill.

Calculations are also covered.

Shortcuts like what happens when the ESC is pressed and when to press F2 to edit a cell. What to expect when you press the HOME key and when to press ENTER.

Share

Feb03

Tagged in:, Comments: YourThoughts?

Getting Started With Excel

setup assistant

Setting up a simple spreadsheet in Excel. Really simple explanation on the video on how to open a spreadsheet in the Micorsoft program and begins by explaining some basics of Excel.

Sometimes Excel seems so over-bearing and complex. I don't know if it's the grid pattern or what, but once you see someone else show you how to get around it's really easy to get started.

 

Share

Download What?

Download Microsoft Excel of course! And all the stuff you need like worksheets and templates. How about discussion on formulas and cell tagging? Tutorials and lists of "how-to" for everything Excel. Oh yeah, there are Excel downloads too.

About