Excel Essentials: Level 2 - Intermediate/Advanced

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 7 Hours | Lec: 82 | 1.44 GB

Genre: eLearning | Language: English

Excel: From User To Super-User - Learn To Use Excel Like The Professionals Easily,And Step-By-Step

So, What’s Inside?

Over 70 bite-sized lectures

6 hours of quality content

All the source files for each project

Access to me (in case you have any questions)!

You will learn powerful and little known techniques to enable you to build your own powerful spreadsheet solutions. We will do this by creating multiple projects together, step-by-step, and in depth to guarantee your understanding. Each projects builds on the last, so your skills develop cumulatively.

You will learn how to combine multiple functions in a simple way to create powerful solutions that most users believe can't be done in Excel!

Each project in the course is designed to introduce a range of concepts that showcase the true power of Excel, and show you what is really possible.

In project one:

The fastest way to create powerful dynamic templates (by cheating!)

Custom formatting

Manipulating calculations with time and dates

Conditional formatting

Simple and nested logical testing

Building complex and dynamic text strings

ActiveX controls (and how to customize them)