Excel Essentials: Level 2 - Intermediate/Advanced
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
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)
Excel Essentials: Level 2 - Intermediate/Advanced
