-
Section 4
8 Lessons-
Preview4.1 Excel 2013 Intro to arrays
-
Start4.2 Excel 2015 Boolean and arrays
-
Start4.3 Excel 2013 Tables
-
Start4.4 Excel 2013 Advanced filters
-
Start4.5 Excel 2013 Pivot tables intro
-
Start4.6 Excel 2013 more pivot tables
-
Start4.7 Excel 2013 intro to power pivot
-
Start4.8 Excel 2013 powerpivot quick tip
-
The Complete Excel Formulas Course Excel 2013
A comprehensive course on Excel from Intermediate to Advanced - Formula and Functions
Course Summary
| 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 | |
Course Curriculum
Paula Guilfoyle
After over 10 years in Accounting and Operations Paula turned her career to subject matter expert, consultant, content creation and online education. In 2010 Paula began teaching online and can now boast over 250K students in 186 different countries. In 2016 Paula began her learning journey around Blockchain and Cryptocurrency. By 2022 Paula pivoted her consultancy, content creation and online education to focus on Blockchain, Web3 and Digital Assets.
