Udemy

Excel Tables (Beginners' Guide) Mini Free Course

All you need to know about Excel Tables
Free tutorial
Rating: 4.2 out of 5 (534 ratings)
8,734 students
30min of on-demand video
English
English

Excel Tables are a must know feature of Excel, but few Excel users know about them.
Learn to format your Data in an Excel Table .
Learn how to use filter buttons to filter and sort your Data.
Learn how to add a total row.
Learn how change the style and design of your Excel table .
Learn how to format Data cells in your Excel table.
Learn how to add Data to your table .
Learn how to move columns and rows and how to resize your Excel Table.
Learn to visualize your Tables using charts and slicers.
Learn how to understand formulas used with Tables.
Learn the difference between using Excel tables and Data range with Pivot Tables.
Learn how to change your Excel table back into a Data range.
Learn how to quickly remove duplicates in your Data.

Requirements

  • Microsoft Excel for Windows
  • This course is for Excel Beginners .
  • No prior Microsoft Excel knowledge is required.
  • Mac users are welcome, but note that the course was created in Excel for windows. Excel interface varies across platforms.

Description

If you are not using Tables in Excel, you are missing out on a huge efficiency gain . They include amazing features that will change how you analyze and summarize your data .

This is a very short course that will introduce you to Excel Tables in less than 35 minutes .

You will learn all about excel tables and how you can style , format , sort , filter  and summarize your Data.

You will learn how to easily understand and write formulas with tables and automatically fill them down the sheet

In addition we will visualize the Data in Excel tables through inserting charts and slicers, that will provide valuable insights to your Data .

You will learn why Excel pivot tables are prefer over Data range when used with Pivot tables.

Tables will save you a lot of time and increase your productivity .They are one of the most useful easy to use tools of excel.

The course is broken down into short lectures so you can watch them around your schedule and can easily refer back to them if you need .

I hope you are excited as I am to start learning about Excel Tables and implement them in your daily work

Let’s get started!

Who this course is for:

  • People who are in Accounting, Finance, Management, Auditing, Admin, Banking, Marketing and any field that used Data.
  • Anyone who wants to learn about Excel Tables.
  • Those who want to quickly analyze their Data sets to provide them with useful insights.

Instructor

Founder, Excel with Sama
  • 4.5 Instructor Rating
  • 559 Reviews
  • 8,833 Students
  • 2 Courses

As a CPA, Sama has worked as an external auditor for over 10 years in one of the big four audit firms. During which she taught several courses across offices of the firm and earned the second-best presenter reward in the middle-east.

In addition, she has taught several accounting and finance classes in a number of educational institutions in Egypt early in her career.

Sama worked over 5 years as Group Reporting Manager / Financial Controller for one of the leading multinational home appliance manufacturer in Cairo, Egypt. During her career, Excel was her best friend in analyzing, reconciling Data and generating reports.

Sama enjoys teaching and sharing her knowledge. She is running her own YouTube channel that provides short Excel tutorials and Excel tips and tricks, Her goal is to help you improve your Excel skills through courses to level up the quality of your work.

Sama is currently living in Melbourne, Australia with her family.


Top companies trust Udemy

Get your team access to Udemy's top 30,000+ courses