The Excel Club 2007 and 2010

Intermediate to advanced Excel Training

The Excel Club 2007 & 2010

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 online course will enable learners to use Excel to analyze data and speed up tasks and take their skills to the next level
Excel 2007 and 2010 are covered in this course. Although some topics and functions shown in this course are of the same title to that in the Excel Club 2013 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 Formatting
Text in Excel
Date and Time
Custom Formatting
Arrays
Tables
Lookups
Basic Macros

Index and Match
Choose Function
Future Value and Interest
Present and NPV
Depreciation
What IF Analysis
Scenario Manager
Solver
Form Controls
Dynamic Charts
Consolidate function
What’s Included?
Instruction by an expert
2 months access 24/7

How long will it take and how much does it cost?
Completion Time 10 Hours
Cost €130 + Vat
Specialised workbook and course materials
Personalised certificate of completion

Intended Audience: Accountants

Workbook for section 1
1 Basics
Relative and absolute
Beefing up the basics
Section 2 workbook
Logical Basics
IF Statements 1
IF Statements 2
More IF Statements
Conditional formatting
Section 3 workbook
Working with Text in Excel
Understanding Dates in Excel
More on Dates in Excel
Custom Formatting in Excel
Section 4 workbook
Array Formulas
Working with Tables in Excel
Working with Tables 2
Advanced Filters
Pivot tables
Section 5 workbook
An Introduction to Vlookup
Lookup 2
Index and Match
The Choose function
Section 6 Workbook
Future Value
Present Value
Payment function
Depreciation functions in Excel
What if Analysis 1 Variable
What If Analysis 2 Variable
Scenario manager
How to use Solver
Section 7 Workbook
Section 8 Workbook
Form Controls
Form Controls 2
Working with Errors
Protection
Consolidate data in Excel
Financial Modelling tips

Excel 2007

Anne Bergin, 4 months ago

Excellent course with plenty of tips

What's included

  • 34 Video Lessons
  • 9 Text 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.