Excel Tutorials

Working With Text & Numbers Tutorial

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…

Text Formatting & Mathematical Calculations Tutorial

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….

Playing with Numbers & More Functions Tutorial

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…

Charts Tutorial

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…

Working with Graphics & Drawing Tutorial

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 …

Use of Financial Functions Tutorial

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….

Style & Formatting Tutorial

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
….

Autofilter Tutorial

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…

Drop Down Box Tutorial

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. …

Mail Merge List Tutorial

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….

Related Articles On Excel Tutorials

• Excel Tutorials