A tutorial that shows how to use excel & covers all basics in just a few easy steps
Steps: To begin open Microsoft Excel. Then, if necessary, click on the in the upper right corner of the task pane to close the task pane. The screen shown here will appear…
A tutorial that shows how to how to format text and perform basic mathematical calculations
Steps: Microsoft Excel enables you to choose a default font. The default font is the style of typeface that Excel will use unless you specify a different style. For the exercises in this lesson, you want your font to be set to Arial, Regular, and Size 10. To set your font to Arial, Regular, and Size 10….
A tutorial that shows how to use reference operators, functions, filling cells automatically etc in just a few easy steps
Steps: Microsoft Excel has many functions that you can use. Functions allow you to quickly and easily find an average, the highest number, the lowest number, a count of the number of items in a list, and make many other useful calculations…
A tutorial that shows how to create charts in just a few easy steps
Steps: Using Microsoft Excel, you can represent numbers in a chart. You can choose from a variety of chart types. And, as you change your data, your chart will automatically update. You can use Microsoft Excel's Chart Wizard to take you through the process step-by-step…
A tutorial that shows how to use drawing & graphic tools in just a few easy steps
Steps: Microsoft Excel is equipped with drawing features that can be used to embellish a worksheet. If you have used Microsoft Office long enough, you are probably aware of its drawing tools. They allow you to draw lines, other geometric shapes, and various flowcharts, connectors, banners, etc …
A tutorial that shows how to use financial functions in just a few easy steps
Steps: Start off by starting a new movie: File»New. Then go to Modify»Movie and change the width and height to whatever your preference might be. The one I'm making is Width: 550 Height: 400. Then create the up and down arrows as it is on the left. Then select the Up Arrow and choose Insert»Convert to Symbol.Name the up arrow, "Arrow 1" and the bottom arrow, "Arrow 2", both as behavior button….
A tutorial that shows how to format text with style in just a few easy steps
Steps: Start Microsoft Excel and fill out Sheet1 as follows. Once you have finished, press Ctrl + A to select the whole worksheet and press Ctrl + C to copy
A tutorial that shows tips & techniques for working with Autofilters
Autofilter is a great feature in Excel. Find out more about how to use this feature to enhance the data analysis of your spreadsheets…
A tutorial that shows how to to create drop down boxes for use in Excel workbooks in just a few easy steps
Drop down boxes (or drop down lists) provide a list from which only a certain set of data can be selected. To create drop down boxes in Excel we will need to use the Name range feature and Validation. …
A tutorial that teaches you how to create a "database" of names & addresses in an Excel spreadsheet and then use them to populate a Mail Merge for Word in just a few easy steps
For the most common Mail Merge process, you need to first setup and populate a database in Excel, and then employ the Mail Merge Helper in Word….