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
$19
$20
5% off
Take This Course
  • Lectures 9
  • Length 40 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2014 English

Course 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

What are the requirements?

  • A basic understanding of Excel is helpful but not necessary

What am I going to get from this course?

  • By the end of this course you will understand what is required to produce amazing reports in Microsoft Excel by creating well-formed lists

What is the target audience?

  • This course is designed to help novice as well as seasoned Excel users format lists to create Excel based reports

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: My First Section
01:28

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

02:40

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

02:18

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

02:01

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

03:46

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

04:49

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

06:04

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

03:42

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

12:58

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Tom Vorves, 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.

Ready to start learning?
Take This Course