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,845 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,845 students enrolled
Created by David Reynolds
Last updated 5/2016
English
Current price: $10 Original price: $60 Discount: 83% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • Basic Excel skills.
  • Have a desire to learn the 'cause' and 'effect' of things.
Description

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
04:40:37
+
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
04:28
+
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
05:09
+
Creating Buttons For Each Column & Locating Them In Order
2 Lectures 16:07
Creating Customized Command Buttons
12:33

Fine Tuning Buttons With Properties
03:34

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

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

Associating The Macro To Your Buttons
05:51

Making Smart Buttons
3 questions

Associating The Macro To Your Buttons Continued
10:39

Double Level Sorting
10:07

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
06:49

Making Your Buttons Do Double Work For You
05:50

Putting Your Buttons To Work
2 questions

Creating More Room To Add Data Without Re-Recording
05:39

Allowing Your Data File To Grow
2 questions

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

Adding 'If, Then, Else' Intelligence To Your Toggle Buttons
09:32

Toggle Button Smartness
2 questions

Adding Intelligence To Your Toggle Buttons Dual Logic
07:44

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
10:18

True Is In, False Is Out, And Which Is Which
06:47

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
02:02

WYSIWYG, Button Caption's Are For The Future
04:31

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
07:16

Header Room Precautions
1 question

More Toggle Button Code Modification
05:45

Toggle Sorting Using Related Columns, & Keeping The Buttons Cleaner
07:29

Double Level Sorting With Toggle Buttons
10:26

More Control By Double Sorting To Filter Hidden Data
09:03

Benefit Of 3 Level's Of Sorting With Toggle Buttons
04:19

Was this course beneficial to you?
Factors In Reviewing a Course
01:35
2 More Sections
About the Instructor
David Reynolds
4.7 Average rating
30 Reviews
4,595 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.