Home | Back to Courses
Microsoft Excel Tables- Ultimate Master Program
Partner: Udemy
Affiliate Name:
Area:
Description: Excel Tables offer an easy way to create dynamic ranges that adjust when data changes. This makes tables perfect for pivot tables, charts, and dashboards that need to show the latest data. This course covers the key benefits of tables, including a detailed review of structured references, the special formula language for tables. Examples include VLOOKUP, INDEX and MATCH, and SUMIFS. The course also covers, table styles, slicers, filtering, sorting, and removing duplicates. What you'll learnThe basicsWhat is an Excel Table, and why would you want to use one?How to quickly create and name a tableHow to use the right terminology to describe tables and table partsHow to get rid of a table when you don't want one anymoreThe four key options that control table behavior, and their unlikely locationsHow calculated columns work, and how to manually override the automatic behaviorTable skillsHow to control table rows and columnsHow tables create dynamic ranges and how to use themHow table filters work, and how to quickly hide and display the filterHow to sort a table by one or more columnsThe special shortcuts you can use to work with tablesHow to add and customize the totals row in a tableHow to quickly remove duplicates in a tableHow to extract unique values from a tableStructured referencesWhat structure
Category: Office Productivity > Microsoft > Excel Formulas and Functions
Partner ID:
Price: 79.99
Commission:
Source: Impact
Go to Course