Excel Basics | 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 Basics

Excel Basics For Beginners

An Excel beginner is someone who can at least switch on a computer and navigate around a spreadsheet with a mouse. Miricle Solutions only lists these prerequisites to people wanting to attend their Excel basics course. Other public courses are Advanced Excel, Pivot Tables, Graphing in Excel and Financial Modelling. You will find the training facilities are conveniently located in Johannesburg near banks and other corporate establishments. In-house courses are also available and the facilitators will customise the content to suit your requirements. Schedules, pricing and registration forms of all the courses can be found on the website.

Focusing on Excel 2003 and Excel 2007 delegates attending the fundamentals course will learn what a spreadsheet is and how the layout works. The beginners program teaches you the Microsoft Excel interface and how to navigate around the spreadsheet. A facilitator will explain the functions and location of the Status bar, Title Bar, Office Button, Quick Access Toolbar, Formula Bar and Ribbon. You will also do a lot of practical exercises and create your own workbook where you will manage, sort and processes data. The next part in Excel basics will teach you how to perform mathematical calculations manually or automatically; align cell data; and copy, cut and paste.

Excel can handle complex mathematical calculations like finding the average, counting numbers in a list or finding the lowest or highest number. You will be trained to use all formulas so that Excel automatically performs these calculations for you.

Read the testimonials on our website and find out for yourself how the Excel basics course changed many individuals’ careers. With their new found confidence, they were able to grow in their organisations and contribute to the success of their departments. You can also improve your skills by starting with a fundamental course; all you have to do is contact Miricle Solutions who will schedule a convenient time for you.