->

Mastering Excel Tables: How to Make and Use Them Like a Pro


Mastering Excel Tables: How to Make and Use Them Like a Pro


https://www.skillshare.com/classes/Mastering-Excel-Tables-How-to-Make-and-Use-Them-Like-a-Pro/391875829?via=search-layout-grid
Excel Tables is a relatively unknown feature within Excel, but mastering it elevates the quality of dashboards, data analysis tasks, and formatting for seamless handoff to colleagues. Join Al as he walks us through how to create Excel Tables, Structured References and beautifully formatted tables.


What you'll learn



  • The benefits of Excel Tables 

  • How to create an Excel Tables from scratch 

  • How to filter and sort your Excel Table as well as add Calculated Columns

  • Different ways to create formulas with Structured References within Excel Tables  

  • How to use the VLOOKUP formula to look up an Excel Table and incorporate it into your main table of data 

  • How to build a dropdown list using Excel Tables 

  • How to format your Excel Table well for your colleagues


Mastering Excel Tables: How to Make and Use Them Like a Pro


 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.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss