Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This Microsoft Excel – Tables Deep Dive training course from Infinite Skills takes you beyond the basics of Excel, diving deep into creating and using tables in this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.
You will start out by the learning the basics of Excel tables, such as how to prepare data for tables, creating and naming tables, and converting tables back to ranges. From there, you will move into working with table records, including how to add and delete records, use the data entry form, and sort and filter table records. Erin will teach you how to format tables and modify and create custom and default table styles. This video tutorial will also teach you table calculations, including how to create calculated columns, understand structured references, and work with table rows. Finally, you will learn how to work with table tools, such as moving tables, removing duplicates, and how to create charts from tables.
By the completion of this computer based training course, you will be fully capable of creating, using, modifying, and customizing tables in Excel. Working files are included, allowing you to follow along with the author throughout the lessons.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Excel Tables Overview|
Important - Download These First - Working Files
0101 Why Take The Deep Dive Into TablesPreview
0102 What You Will LearnPreview
0103 Learning The Way You NeedPreview
0104 Using The Working Files
|Section 2: Skimming The Surface Of Tables|
0201 Skimming The Surface Of Tables
0202 Why Do We Need Tables
0203 Preparing Data For Tables
0204 Creating Tables
0205 What Changes With Tables
0206 Naming Tables
0207 Converting Tables Back To Ranges
|Section 3: Working With Table Records|
0301 Working With Table Records
0302 Adding And Deleting Records
0303 Using The Data Entry Form
0304 Adding Columns To Tables
0305 Sorting Table Records
0306 Filtering Table Records
0307 Using Slicers In Tables
|Section 4: Formatting Tables|
0401 Formatting Tables
0402 Working With Quick Styles
0403 Modifying Table Style Options
0404 Creating Custom And Default Table Styles
|Section 5: Calculations In Tables|
0501 Calculating Data In Tables
0502 Excel Calculations Refresher
0503 Creating Calculated Columns
0504 Understanding Structured References
0505 Tweaking Absolute References In Tables
0506 Working With Table Rows
|Section 6: Using Table Tools|
0601 Working With Table Tools
0602 Moving Tables
0603 Removing Duplicates
0604 Summarizing Table Data With Pivot Tables
0605 Creating Charts From Tables
0606 Printing Tables
|Section 7: Course Closing|
0701 What You Now Know
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.