How To Sort In Excel Large Data Files With Custom Buttons
4.7 (10 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.
1,851 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How To Sort In Excel Large Data Files With Custom Buttons to your Wishlist.

Add to Wishlist

How To Sort In Excel Large Data Files With Custom Buttons

Excel: Sort Any Size Data File With Excel Macros & Custom Buttons, Learn Visual Basic to Customize Your Excel Reports.
4.7 (10 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.
1,851 students enrolled
Created by David Reynolds
Last updated 5/2016
Price: $60
30-Day Money-Back Guarantee
  • 4.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Sort any size Excel data file with rows of data by any column you chose at the click of a custom button you learn to make.
  • Learn to customize the macro's you record to give your reports a professional look.
  • Learn some basic VBA skills to have more control of Excel's powerful features.
View Curriculum
  • Basic Excel skills.
  • Have a desire to learn the 'cause' and 'effect' of things.

From The Instructor,

This Excel course is strongly focused on Creating Excel Macro's and Button's, and some Excel Visual Basic so you can have more control over large amounts of data files. We go Step-by-Step, Line-by-Line so anyone with an interest in this is Guaranteed to learn how. This is NOT a surface level teaching of general Excel topics.

Have more control over large Excel data files with lots of Column's and Row's to get faster results with Sorting your data in several ways with less repetitious work.

If you have large Excel data files with lots of columns and rows to sort through, this will save you hours of back and forth searching. We go beyond basic Button and Macro creation, I show you how to customize them to your needs. Reusable for other data files, just cut-and-paste to replace, or add more data to existing files that automatically sorts itself, no more inserting copied rows.

You'll discover:

  • How to get a tab or comma delimited file into Excel
  • How to adjust the size, location, and appearance of all your buttons at one time.
  • How to use Visual Basic to create professional looking reports.
  • How to Record Macro's and associate the code to buttons.
  • How to control several levels of data within the Custom Sort box to get exactly the reports you're wanting.
  • How to make the Buttons multitask and save you time and effort.
  • How to make Toggle Buttons to sort A-Z and Z-A.
  • How to use a counter to track your data as it grows.
  • How to add more data without 'Inserting' and let the Buttons automatically sort the data for you.
  • Make one file sort multiple ways so you'll have several files and reports in one.
  • Learn a skill that can be carried over to other file needs.

Since the buttons are doing the work for you, error's become very rare, and your reports are regarded as more trusted.

Included in this course are Bonus Tips that grow the longer you stay with the course.

Who is the target audience?
  • With even the basic knowledge of Excel, You can follow this course to grow. Business individuals who want more control over large amounts of data for Excel to sort.
  • This course might not be for you if you're happy with how things work straight out of the box and don't want to dig any deeper.
Compare to Other Excel Courses
Curriculum For This Course
37 Lectures
Example Benefits Of Sorted Data In Excel
4 Lectures 19:01

Short 3 minute preview of what its like to be in control of your large data files. Fastest way to see multiple reports from one data file is to have pre-defined sort criteria so that you can just 'Click' on a button and let all that data fall into the order that you need instantly.

Preview 03:12

What helps you determine if the course is for you?
Preview 01:35

What you will learn, Guaranteed, that will make you more effective.

Quick Overview and Download of What To Expect
Importing Your Data From Comma or Tab Delimited Text Files
1 Lecture 05:09
How To Get All Or Part Of Delimited Text Files Into Excel
Creating Buttons For Each Column & Locating Them In Order
2 Lectures 16:07
Creating Customized Command Buttons

Fine Tuning Buttons With Properties

Button Modifications
2 questions
Learning How To Use The Custom Sort Box
2 Lectures 23:54
Defining How The Sort Results Will Look

Use The Custom List Within the Custom Sort Box, You Can Have More Control.
Recording Macro's & Sorting On Two Levels
4 Lectures 32:11
Using The Record Macro Feature

Associating The Macro To Your Buttons

Making Smart Buttons
3 questions

Associating The Macro To Your Buttons Continued

Double Level Sorting

Double Level Sorting
2 questions
Working With VBA Code To Adjust Sorted Data
4 Lectures 29:39
Working With Visual Basic Code To Customize Your Reports

Making Your Buttons Do Double Work For You

Putting Your Buttons To Work
2 questions

Creating More Room To Add Data Without Re-Recording

Allowing Your Data File To Grow
2 questions

Optional Methods To Customize Your Sorted Headings
Toggle Buttons For Long Data Fields
3 Lectures 26:59
Adding Toggle Buttons Easily

Adding 'If, Then, Else' Intelligence To Your Toggle Buttons

Toggle Button Smartness
2 questions

Adding Intelligence To Your Toggle Buttons Dual Logic

Labeling Your Toggle Buttons Captions
1 question
Understanding The True / False Options Of Toggle Buttons
2 Lectures 17:05
Learning The VBA's Of Toggle Buttons True / False Options

True Is In, False Is Out, And Which Is Which

Toggle Button Properties, When Is True Really True?
2 questions
Making Better Use Of Toggle Button Code
2 Lectures 06:33
Following Thru With Button Captions

WYSIWYG, Button Caption's Are For The Future

Toggle Button Coding
1 question
Single and Double Level Sorting Options Of Toggle Buttons
7 Lectures 45:53
Adding Header Room & Adjusting Your Code To Match

Header Room Precautions
1 question

More Toggle Button Code Modification

Toggle Sorting Using Related Columns, & Keeping The Buttons Cleaner

Double Level Sorting With Toggle Buttons

More Control By Double Sorting To Filter Hidden Data

Benefit Of 3 Level's Of Sorting With Toggle Buttons

Was this course beneficial to you?
Factors In Reviewing a Course
2 More Sections
About the Instructor
David Reynolds
4.6 Average rating
32 Reviews
4,613 Students
6 Courses
My Job Is Making Your Job Easier

Being in the Engineering field for over 30 years, David has worked much with Excel and knows how data overload can feel overwhelming unless you have some kind of control of your Excel files. 15 of those years included Online Marketing, promoting businesses through Pay Per Click and Search Engine Optimization, which required downloading traffic reports to track efforts and success.

So much data from so many directions, David developed a way to dissect it faster. Applying some of his programming skills proved beneficial in merging a lot of this together, so the schooling was definitely worth the time.

During the process of developing a unique method of discovering a person's Natural Talents and Gifts, David discovered a way that allowed a person to 'express in words' their own natural talents in ways they couldn't before.

Some of his includes 'Breaking down the complex to simplify things by making quick reference guides for consistency', 'Creating a process to understand things easier by making a Step-by-Step guide for an assembly line smoothness using flow-chart type logic to remove questions that prevents progress.' Teaching seemed like a perfect match for this natural gift.

Sharing things in detail of what he's found that made his work easier shows up in his teachings. Selecting specific topics and digging deep instead of just touching the surface is what makes his work stand out.