Excel PRO TIPS Part 4: Data Visualization

Excel PRO TIPS Part 4: Data Visualization

Video: .MP4, 1280x720 | Audio: AAC, 44kHz, 2ch | Duration: 1h 35m

Genre: eLearning | Language: English | Size: 780 MB


 

Welcome to Excel Pro Tips for Power Users!

 

Please note that this is PART 4 of a 6-PART series, and that this is a limited version of the full course. To access additional course materials (including quizzes, 1-on-1 support, and Excel project files), please visit courses.excelmaven.com.

 

__________

 

FULL COURSE DESCRIPTION:

 

This course is NOT an introduction to Excel.

 

It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical "hacks". It's about featuring some of the most powerful and effective tools and techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.

 

Unlike most courses, this one is non-linear, meaning that you can bounce around and explore individual lectures freely. Each video is designed to be an independent and self-contained demo, designed to help you learn these tools and techniques in quick, bite-sized lessons.

 

__________

 

The tips and techniques covered in the full course fall into six parts:

 

PART 1: Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)

PART 2: Formatting Tips (freeze panes, row/column grouping, custom number formats, etc.)

PART 3: Formula Tips (auditing tools, fuzzy lookups, uniques/duplicates, randomization, etc.)

PART 4: Visualization Tips (sparklines, filled maps, custom templates, form controls, etc.)

PART 5: PivotTable Tips (slicers & timelines, custom layouts, value calculations, etc.)

PART 6: Analytics Tips (outlier detection, simulation, forecasting, CUBE functions, etc.)

__________

 

While the level of difficulty varies considerably, the demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying concepts (like PivotTables or advanced formulas, for example).

 

Students who have completed the full Excel Maven stack will be well-positioned to maximize the value from this course:

 

Advanced Excel Formulas & Functions

Data Visualization with Excel Charts & Graphs

Data Analysis with Excel PivotTables

Intro to Power Query, Power Pivot & DAX

__________

 

It's time to start working smarter, not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you.

 

HOMEPAGE

https://www.skillshare.com/classes/Excel-PRO-TIPS-Part-4-Data-Visualization/483304260 

 

Excel PRO TIPS Part 4: Data Visualization


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Solid   |  

Information
Members of Guests cannot leave comments.


SermonBox - Seasonal Collection

SermonBox - The Series Pack Collection

Top Rated News

  • Christmas Material
  • Laser Cut & Print Design Elements Bundle - ETSY
  • Daz3D - All Materials - SKU 37000-37999
  • Cgaxis - All Product - 2019 - All Retail! - UPDATED!!!
  • DigitalXModels Full Collections
  • Rampant Design Tools Full Collections Total: $4400
  • FilmLooks.Com Full Collection
  • All PixelSquid Product
  • The Pixel Lab Collection
  • Envato Elements Full Sources- 3200+ Files
  • Ui8.NET Full Sources
  • The History of The 20th Century
  • The Dover Collections
  • Snake Interiors Collections
  • Inspirational Collections
  • Veer Fancy Collections
  • All Ojo Images
  • All ZZVE Collections
  • All Sozaijiten Collections
  • All Image Broker Collections
  • Shuterstock Bundle Collections
  • Tattoo Collections
  • Blend Images Collections
  • Authors Tuorism Collections
  • Motion Mile - Big Bundle
  • PhotoBacks - All Product - 2018
  • Dekes Techniques - Photoshop & Illustrator Course - 1 to 673
Telegram GFXTRA Group
Udemy - Turkce Gorsel Ogrenme Setleri - Part 2
Videohive Wow Pack Series


rss