Excel for Dummies | Online Excel Training

MAIN PAGES

-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us

BLOG

- Our BLOG

SOFTWARE

-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security

NEW Videos

- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS

Excel Basics

- Function Wizard
- Audit Toolbar
- Good Design
- Add In's

Tips and Tricks

- Identify missing categories
- Check that data within range
- Count error checks
- Check import headers
- CAGR
- Show all formula
- Fill in blanks
- Data Cleanup
- Multi sheet changes
- Automatic Sort

VLOOKUP tips

- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
- Automatic Sorting

Financial

- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table

Database

- Database

Lookups

- Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF

Dates

- DATE
- EOMONTH
- EDATE

Statistics

- Rank
- MAX/ MIN

Logical

- IF
- AND/ OR

Text

- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text

Information

- IS number EVEN/ODD
- Is cell a number
- ISERROR

Maths

- SUMIF/ COUNTIF

Other Tools

- Data Validation
- Group/Ungroup
- Autofilter
- Workbook protect
- External Links
- Goto Special
- Find/ Replace
- Conditional Format
- Pivot Tables
- Data Sort
- Data tables
- Multiple Windows
- Hyperlinks
- Protect cells
- Paste Special

How errors happen

- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing

What If's

- Goalseek
- Data Tables
- Scenarios
- Watch Window

Download All Videos

- Download All

Excel for Dummies

Microsoft Office Excel for Dummies is a book written by Greg Harvey. As indicated by the title, the book is an introductory guide to Microsoft’s spreadsheet program. It teaches novices to build and format Excel spreadsheets, integrate spreadsheets with Web documents (and other Office applications) and analyse and sort data.

Excel for Dummies is the definitive Excel guide and the latest edition has been totally rewritten to reflect the extensive changes in MS Excel 2007. Some of these changes include the redesign of the user interface, now emphasising tasks and sporting more extensive use of graphics. New, too, are the Quick Access Toolbar, the Office Button and the Ribbon.

It starts with the basic and fundamental operations of creating worksheets from scratch and editing them, the creation and editing of charts, inserting graphs, entering formulas, adding hyperlinks to worksheets, using Seek and Find, designing database forms and streamlined document searching. It also demonstrates how to save a worksheet as a Web page and how to e-mail one. It continually emphasises the most efficient and user-friendly way to get things done.

The book has six main parts. The first deals with getting familiar with Excel 2007 and creating your first worksheet. The rest deals with, among others, editing worksheets, getting well organised and data analysis. The reader is guided through common operations like printing the worksheet, and maintaining multiple worksheets. Other skills taught are what-if analyses, transferring data between worksheets from different workbooks and working with Pivot Tables. Charts, graphics, macros and hyperlinks are also dealt with in some detail.

Excel for Dummies has been revised to include numerous full-colour plates in the book’s centre section to illustrate exactly what you will see on the screen as you work. Use it as a reference to solve certain problems or read it in detail to familiarise yourself with Excel.