Mastering Excel Charts | Mirical Solutions

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 Charts

Mastering Excel Charts

Excel Charts are excellent tools for the visual display of information in a graphical format. Once a person knows how to create one of the many types of Excel charts and how to interpret the information, they will use the tool often to improve their presentations and reporting.

With Excel 2007, there are even more options for Excel charts, lay-outs, formatting, and design. Although it may seem even more complex than with Excel 2003, the basic underlying principles for creating charts stay the same.

We provide you with several options to master Excel charts:

Live classes at various venues and set dates. The courses are short, hands-on and focussed.

Free online tutorials to master specifics in Excel.

Video based online and downloadable courses allowing you to learn everything you need to know about Excel.

From the above information, it can be seen that we have provided you with alternatives to long study courses. If you want to impress colleagues, clients, and financial institutions with your charting abilities, we recommend that you master the required tools. Not only are the charts excellent for presentations, but are also excellent reporting tools ensuring that you can easily identify trends which would otherwise not have been obvious.

We run the Excel Graphing course as part of the Advanced Live Course. This is the ideal program for someone already used to working with Excel. Several aspects of graphing are treated including:

Preparing data for the chart.

Creating a chart from scratch.

Working with the chart area.

Understanding titles and the formatting options.

Working with the legend.

Understanding the Axis.

Showing and printing gridlines.

Working with the plot area.

Setting data points.

Formatting and editing a specific series.

Adding an additional series to the chart.

Master Excel charts by attending a live short one day course or purchase an online course to work though at your own pace. Contact us for more information and pricing on any of the options mentioned.