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 (9 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,839 students enrolled
$60
Take This Course
  • Lectures 37
  • Length 4.5 hours
  • 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 12/2014 English

Course 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.

What are the requirements?

  • Basic Excel skills.
  • Have a desire to learn the 'cause' and 'effect' of things.

What am I going to get from this course?

  • 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.

What 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.

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: Example Benefits Of Sorted Data In Excel
03:12

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.

01:35
What helps you determine if the course is for you?
See How Having More Control Over Your Data Will Save Time and Guesswork
Preview
09:46
04:28

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

Section 2: Importing Your Data From Comma or Tab Delimited Text Files
How To Get All Or Part Of Delimited Text Files Into Excel
05:09
Section 3: Creating Buttons For Each Column & Locating Them In Order
Creating Customized Command Buttons
12:33
Fine Tuning Buttons With Properties
03:34
Button Modifications
2 questions
Section 4: Learning How To Use The Custom Sort Box
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
Section 5: Recording Macro's & Sorting On Two Levels
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
Section 6: Working With VBA Code To Adjust Sorted Data
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
Section 7: Toggle Buttons For Long Data Fields
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
Section 8: Understanding The True / False Options Of Toggle Buttons
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
Section 9: Making Better Use Of Toggle Button Code
Following Thru With Button Captions
02:02
WYSIWYG, Button Caption's Are For The Future
04:31
Toggle Button Coding
1 question
Section 10: Single and Double Level Sorting Options Of Toggle Buttons
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
01:35
Was this course beneficial to you?
Section 11: Advanced Code Options
Advanced Code Tweaking vs Recording Time
12:20
03:11

Download the Overview Report included here. Note the Report if printed should be printed in Landscape format.

Section 12: Bonus Tips
Bonus Tips For Smart Reports
15:35
10:38

Collecting your own data from anywhere, and forming different pictures from the click of a button.

11:30

Instead of adding text to identify which column was last sorted by, you can use a color at the top of that column to make a visual identification for faster recognition.

04:52

Everybody needs a Freebie, here's yours. All you have to do is add your data. Watch the other videos to learn how to modify this as needed.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

David Reynolds, 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.

Ready to start learning?
Take This Course