<h2>Coaching Courses</h2>
<img width="960" height="617" src="http://www.flexicoach.com.au/wp-content/uploads/2019/03/ExcelImage2.jpg" alt="" srcset="http://www.flexicoach.com.au/wp-content/uploads/2019/03/ExcelImage2.jpg 960w, http://www.flexicoach.com.au/wp-content/uploads/2019/03/ExcelImage2-300x193.jpg 300w, http://www.flexicoach.com.au/wp-content/uploads/2019/03/ExcelImage2-768x494.jpg 768w" sizes="(max-width: 960px) 100vw, 960px">
<h4>Microsoft Excel</h4>
<a href="">Introduction</a>

In this course the student will learn the fundamentals of Excel Use, From Formatting, to Creating Formulas, and working with Layout and Print features. This course cover foundation skills and includes the use of Shortcuts to save time and effort in Excel. A Must even for those familiar with this Application.

Excel Tools and Terminology

Enter and Edit Data

Rows, Columns &amp; Ranges

Move, Copy and Paste Data

Using the AutoFill Feature

Creating Basic Formulas

Using Common Functions (SUM, AVERAGE Etc…..)

Working with Absolute Referencing

Formatting

Layout and Printing

Freeze Panes &amp; Split Window

Find, Replace &amp; GoTo

Introduction to Charts

<a href="">Intermediate</a>

Stepping up your knowledge of Excel, from Sort and Filter of your data to working with more advanced functions such as IF, &amp; Vlookup.

Sorting and Filtering Data

Sort and Filter by Colour and Icon

Conditional Formatting

Using Logical Functions (IF, AND, OR)

Using VLOOKUP

The Index, Match Alternative

Using Mixed References

Chart Design and Layout

<a href="">Advanced</a>

Accordion Content

<a href="">VBA</a>

Accordion Content