Course Highlights:
- Over 15 hours of lecture content across 300 modules
- Exercises and quizzes available to monitor progress
- Covering a range of topics from printing on Excel to complex formulas
- Learn button functions and how to use for presentations
- Learn to use Excel for business and professional purposes
- Covers five topics: Excel Hacks/Tips, Advanced Charts, Power Pivot, Dashboards, and Macros
Course Includes:
- My Top Ten (10) Hacks and Tips
- Excel Interface
- Workbooks and Worksheets
- Formatting
- Organising and Working with Data
- Numbers, Dates and Formulas
- Tables and Pivot Tables
- Charts
- Creating, Resizing and Modifying Charts
- Formatting and Customising Charts
- Updating and Printing Charts
- Working With Text, Pictures, Shapes and Effects
- Basic Chart Types
- Master Excel Charts
- Get Started With Power Pivot and Power View
- Calculated Fields - Columns and Dax Formula Language
- KPI, Key Metrics and Design Your Dashboard > PART:1
- Design Your Dashboard > PART:2
- Create an Amazing Sales Map With Power View
- Completing Your Dashboard
- Analysing a Dashboard With Functions
- Beginners: Introduction to Charts
- Beginners: Basic Build-in Chart Types
- Formatting and Customising Charts
- Graphics for Charts and Dashboards
- Dashboards Components: Sparklines - Mini Charts
- Advanced Charts and Dashboard Components
- Interactive Charts and Dashboards Controls
- Analysing a Dashboard With Pivot Tables and Charts
- Dashboards: Putting it All Together
- The Basics of Macros
- Enter the world of VBA
- Get in-depth with Macros
- How to create your First Piece of Code
- Supercharge Macros and VBA with Loops
- Ready-to-use Excel Macros
- Quiz
For full course information click here.
About OfCourse Learning:
OfCourse Learning is a lifestyle and self-improvement online learning platform. They cater for a variety of needs from well-being courses such as, CBT and NLP to career based courses covering relevant topics for personal assistants and human resource employees. They also carry a good selection of hobby style courses such as music, art and many more.
All of the courses are video led, with supplementary PDF material and the majority include multiple choice assessments. Once a purchase has been made you will receive instant unlimited access to the course, tutor and other fellow students via the course forum. An automatically generated certificate will be awarded on completion of any of their courses.
Conditions
Valid from Mar 12, 2019
Expires Jun 12, 2019
Limit: 10 per user and 10 as gift for others
Customers need to register with OfCourse in order to take part in the course. One coupon is valid for one course only. Valid only for the specified course. Non-transferable. Course must be completed by the original purchaser or gift recipient only. Cancellation of registration/enrollment will make the coupon void. No refunds unless required by law. No cashback. Not to be used with any other offer.
See the rules that apply to all deals.
Sold by
OfCourse Learning
Business in Trade