The Excel Club 2013

A comprehensive course on Excel from Intermediate to Advanced - Formula and Functions

The Excel Club is an online Microsoft Excel Course, written by an Accountant, focusing on intermediate to expert Excel. The course is focused on Functions and Formula and a working knowledge of Excel is required. This course has been designed for Accounting and Finance professionals who what to develop their MS Excel skill far beyond a basic level. This course is also suitable for those that completed The Excel Club 2010 & 2007 and require a refresher.
This online course will enable learners to use Excel to analyze data and speed up tasks and take their skills to the next level
Excel 2013 is covered in this course. Although some topics and functions shown in this course are of the same title to that in the Excel Club 2007 and 2010 course, the examples shown are different.
What Will Students Learn and what Topics are Covered?
Relative and Absolute Cell References
Advanced Sum and Average functions
Logical Functions
Conditional FormattingText in Excel
Date and Time
Custom Formatting
Arrays
Tables
Lookups
Index and Match
Choose Function
Future Value and Interest
Present and NPV
Depreciation
What IF Analysis
Scenario Manager
Solver
Form Controls
Consolidate function
Web queries
Power Maps
Much More
Basic Macros

What’s Included?
Instruction by an expert
12 months access 24/7

How long will it take and how much does it cost?
Completion Time 10 Hours
Cost €170

Intended Audience: Accountants

1.1 Excel 2013 basics formulas and auditing
1.2 Excel 2013 relative and absolute cells
1.3 Excel 2013 Beefing up the basics
1.4 Excel 2013 working with errors
1.5 Excel 2014 protecting your workbooks
2.1 Excel 2013 Logical Functions
2.2 Excel 2013 IF statements
2.3 Excel 2013 Net pay and dynamic labels using the IF statement
2.4 Excel 2013 Conditional formatting
2.5 Excel 2013 Data validation and random numbers
3.1 Excel 2013 Text
3.2 Excel 2013 Date and time
3.3 Excel 2013 Custom formatting
3.4 Excel 2013 More Date - Age debtors
4.1 Excel 2013 Intro to arrays
4.2 Excel 2015 Boolean and arrays
4.3 Excel 2013 Tables
4.4 Excel 2013 Advanced filters
4.5 Excel 2013 Pivot tables intro
4.6 Excel 2013 more pivot tables
4.7 Excel 2013 intro to power pivot
4.8 Excel 2013 powerpivot quick tip
5.1 Excel 2013 Vlookup
5.2 Excel 2014 Index and Match
5.3 Excel 2013 Choose
6.1 Excel 2013 Future present and NPV
6.2 excel 2013 NPV
6.3 Excel 2013 Payment function
6.4 Excel 2013 Other finance functions
6.5 Excel 2013 Consolidate data
7.1 Excel 2013 1 Variable What IF
7.2 Excel 2013 2 Variable what IF
7.3 Excel 2013 Scenario Manager and goal seek
7.4 Excel 2013 Solver
8.1 Excel 2013 form controls
8.2 Excel 2013 Form Control and User Interface
8.3 Excel 2013 Simple macros
8.4 Excel 2013 Editing a macro
8.5 excel 2013 Power Maps
8.6 Excel 2013 getting data from the web

What's included

  • 40 Video Lessons

  • Works on all devices
  • Certificate of completion

Paula Guilfoyle

Instructor

My Name is Paula, and I am a qualified CPA with over 15 years’ experience in Accounting and Business. I have worked across a broad range of industries and levels of seniority. During this time I used Excel as my spreadsheet tool of choice, attending many courses and regularly updating my skills. It was my love for Excel that started my journey as an e-learning educator. As a manager and an Accountant, I noticed a skills gap amount Accountants and finance staff in Excel. In 2010 I launched www.theexcelclub.com with 1 course aimed at this market. I am now author and presenter of many online courses and can boast that I have thought over 10,000 students!

In addition to being an Accountant and an Online Educators I am also a wife and a mother of two, my youngest is 2 and eldest is 7. I currently work as an Accountant for a global company, which makes family life very very busy. I am always stuck for time, and finding a balance is very difficult. I’m sure all working parents understand the pressures involved.