Microsoft Excel Tables- Ultimate Master Program
What you'll learn
- A solid, step-by-step program to learn Excel Tables
- Guided practice - each video comes with a practice worksheet
- Both Windows and Mac shortcuts in all videos
- What is an Excel Table, and why would you want to use one?
- How to quickly create and name a table
- How to use the right terminology to describe tables and table parts
- How to get rid of a table when you don't want one anymore
- The four key options that control table behavior, and their unlikely locations
- How calculated columns work, and how to manually override the automatic behavior
- *****How to control table rows and columns*****
- How tables create dynamic ranges and how to use them
- How table filters work, and how to quickly hide and display the filter
- How to sort a table by one or more columns
- The special shortcuts you can use to work with tables
- How to add and customize the totals row in a table
- How to quickly remove duplicates in a table
- How to extract unique values from a table
- What structured references are and how they work with tables
- How to use formulas to access different parts of a table
- How structured references behave inside a table (vs. outside a table)
- How to copy structured references and lock references when needed
- How to use formulas to do a conditional sum with a table using SUMIFS
- ****How to use VLOOKUP and MATCH with a table together for dynamic column referencing****
- ****How to use INDEX and MATCH with a table, and the key benefit this offers****
- How to set up a running total in a table using structured references
- How you can use the INDEX function to get the first row in a column
- How to quickly add (and remove) a slicer to a table
- How to create your own custom style
- How to remove all formatting from a Table, and override local formatting
- At end of this course you will lot more......
Requirements
- Having microsoft excel
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 learn
The basics
What is an Excel Table, and why would you want to use one?
How to quickly create and name a table
How to use the right terminology to describe tables and table parts
How to get rid of a table when you don't want one anymore
The four key options that control table behavior, and their unlikely locations
How calculated columns work, and how to manually override the automatic behavior
Table skills
How to control table rows and columns
How tables create dynamic ranges and how to use them
How table filters work, and how to quickly hide and display the filter
How to sort a table by one or more columns
The special shortcuts you can use to work with tables
How to add and customize the totals row in a table
How to quickly remove duplicates in a table
How to extract unique values from a table
Structured references
What structured references are and how they work with tables
How to use formulas to access different parts of a table
How structured references behave inside a table (vs. outside a table)
How to copy structured references and lock references when needed
Formulas and Tables
How to use formulas to do a conditional sum with a table using SUMIFS
How to use VLOOKUP and MATCH with a table together for dynamic column referencing
How to use INDEX and MATCH with a table, and the key benefit this offers
How to set up a running total in a table using structured references
How you can use the INDEX function to get the first row in a column
How to set up conditional formatting in a table with a formula
How to use data validation in a table + how to use a table to create a dynamic list
How to use named ranges when Excel won't let you use structured references
How to set up a formula to display how many items in a table are visible
Slicers
How to quickly add (and remove) a slicer to a table
How to add more than one slicer to to table
How to stop slicer buttons from moving around
What options are available for slicers, and how they work
How to define and apply a custom style to control how slicers look
Table styles
How tables are formatted with styles, and what you can include in a style
How to quickly apply a style and see what style is applied
How to remove all formatting from a Table, and override local formatting
How to create your own custom style
How to move a custom style from one workbook to another
How to set up Excel to use your custom style by default
Practical table examples
How to use a table to create a dynamic pivot table
How to make a dynamic chart based on table data
Who this course is for:
- Everybody who want to learn Excel
Instructor
- 4.2 Instructor Rating
- 545 Reviews
- 46,902 Students
- 7 Courses
Rajesh Reddy is a seasoned IT professional and distinguished educator with over 13 years of experience in the tech industry. As an expert in database management, ETL processes, cloud computing, and test management, Rajesh provides high-quality training and consultancy to empower individuals and organizations with cutting-edge technical skills.
Specializations:
Database Management: Rajesh is an authority in Oracle SQL/PLSQL, Microsoft SQL Server, and MongoDB. His in-depth knowledge covers essential topics such as database design, performance tuning, and advanced SQL techniques. Rajesh’s courses are designed to equip learners with practical skills for managing and optimizing databases efficiently.
ETL Tools and Data Integration: With extensive expertise in Informatica PowerCenter, Rajesh offers comprehensive training on ETL processes, workflow design, and data integration. His courses provide hands-on experience in building robust data pipelines and handling complex data transformations.
Programming and APIs: Rajesh specializes in NodeJS and Deno.js, focusing on REST and GraphQL API development. He covers essential topics such as authentication, database integration, and secure API design, helping developers build scalable and efficient web applications.
Cloud Computing and AI: Rajesh offers training on AWS Glue and Azure AI Studio, covering cloud-based data integration and artificial intelligence solutions. His courses are tailored to help learners leverage cloud technologies for data processing and AI-driven insights.
Testing and Quality Assurance: Rajesh’s expertise in test management ensures thorough understanding of test planning, execution, and reporting. His training emphasizes best practices in software quality assurance, helping teams deliver reliable and high-quality software products.
Teaching Philosophy:
Rajesh Reddy combines theoretical knowledge with practical application in his teaching approach. He is committed to providing engaging, hands-on training that equips learners with real-world skills. His courses are designed to foster a deep understanding of complex technical concepts while preparing students for practical challenges in the industry.