Microsoft Excel: Build Better Lists. Get More from your Data
4.5 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
28 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel: Build Better Lists. Get More from your Data to your Wishlist.

Add to Wishlist

Microsoft Excel: Build Better Lists. Get More from your Data

This course includes all you need should know to get started building great lists from raw data. Start learning now.
4.5 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
28 students enrolled
Created by Tom Vorves
Last updated 1/2014
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 40 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
By the end of this course you will understand what is required to produce amazing reports in Microsoft Excel by creating well-formed lists
View Curriculum
Requirements
  • A basic understanding of Excel is helpful but not necessary
Description

In these next few videos I will show you what it means to have a well-formed list and the advantages of taking the time to ensure your lists are well-formed.

If you take the time to prepare your data lists to comply to these simple standards, you can have Excel working for you rather than you having to work for Excel.

Visit www.tomvorves.com for questions and links to other classes on Udemy

Who is the target audience?
  • This course is designed to help novice as well as seasoned Excel users format lists to create Excel based reports
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 9 Lectures Collapse All 9 Lectures 39:46
+
My First Section
9 Lectures 39:46

In these next few videos I will show you what it means to have a well-formed list and the advantages of taking the time to ensure your lists are well-formed.

If you take the time to prepare your data lists to comply to these simple standards, you can have Excel working for you rather than you having to work for Excel.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Preview 01:28

Headings are an important start to building well-formed lists.

In this demonstration you will learn by building well-formed lists that we can quickly sort, filter, update, pivot, calculate, export, import, and link data in Excel spreadsheets.

Organized data is more easily used and re-used, updated and manipulated. I will show you how to organize your data to produce well-formed lists allowing reports to be built easily.

We can have Excel working hard for us instead of us working hard for Excel by using the standards I teach you in these videos.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Preview 02:40

Ensuring our data and headings are contiguous is the next important step in building well-formed lists.

In this demonstration you will learn by building well-formed lists that we can quickly sort, filter, update, pivot, calculate, export, import, and link data in Excel spreadsheets.

Organized data is more easily used and re-used, updated and manipulated. I will show you how to organize your data to produce well-formed lists allowing reports to be built easily.

We can have Excel working hard for us instead of us working hard for Excel by using the standards I teach you in these videos.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Well-Formed Lists - Contiguous
02:18

By formatting our headings differently than our data, we help Excel to determine how to work with our well-formed list more accurately.

In this demonstration you will learn by building well-formed lists that we can quickly sort, filter, update, pivot, calculate, export, import, and link data in Excel spreadsheets.

Organized data is more easily used and re-used, updated and manipulated. I will show you how to organize your data to produce well-formed lists allowing reports to be built easily.

We can have Excel working hard for us instead of us working hard for Excel by using the standards I teach you in these videos.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Well-Formed Lists - Formats
02:01

This short video will demonstrate how easy it is to manage a list when it is well-formed.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Basic Sorting and Filters
03:46

In this video I will show you how to identify intrinsic groups in your data which we can use to build Excel reports

Business data reporting is commonly based on aggregates and summaries. Individual data records are not as informative to a business decision maker as a collection of grouped historical data: groups.

Lists have common data elements such as City, State, Country, Department, as well as unique data elements like Customer Number, Social Security Number, SKU, First Name, Last Name, Hire Date, Order Date.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Identify Groups - Intrinsic
04:49

In this video I will show you how to mine your data to produce derived groups which we can use to build Excel reports.

Business data reporting is commonly based on aggregates and summaries. Individual data records are not as informative to a business decision maker as a collection of grouped historical data: groups.

There are times when group values are buried in other data columns. A column called “date of hire” may be quite unique, but with some data mining techniques, we can extract the year, month or day from the date and produce a grouping column.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Preview 06:04

This video will demonstrate how easy it is to use well-formed lists. Sorts, filters and Pivot Tables are all easier and faster if you follow the standards I have shared with you in this series videos.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Summary Demonstration - Data Preparation
03:42

Your bonus video will teach you how to harness the power of a function that replaces the standard Sum, Average and Count functions that are designed to calculate on contiguous ranges. The Subtotal function though, is designed to calculate based only on the visible cells making it the perfect option for filtered lists.

Learn what every business Excel user should know about creating list based reports

Visit www.tomvorves.com for questions and links to other classes on Udemy

Bonus Video - Filters and Functions: Harness the Power of the Subtotal Function
12:58
About the Instructor
Tom Vorves
4.3 Average rating
22 Reviews
1,121 Students
3 Courses
Collaboration Evangelist

With more than 25 years of teaching experience, I have the knowledge and ability to break down the complexities of technology, making it simple to understand and learn.

My professional yet casual teaching style make for a successful and enjoyable learning experience.

Is it a goal to update your Microsoft Office skills? Are you interested in learning the latest version of software? Perhaps you need to implement SharePoint company wide. I am able to help you plan and deliver training that will meet your needs.

Small businesses, one-on-one, large corporate events, classroom style training, webinars, video training, whatever your situation, we will work together to create the best training experience specifically for you.