Creating Custom Macro Buttons To Do The Work For You.

Name: Creating Custom Macro Buttons To Do The Work For You.
Rating: 4.5 (14 reviews)

Excel: Sort Any Size Data File With Excel Macros & Custom Buttons, Learn Visual Basic to Customize Your Excel Reports.

Created byDavid Reynolds

Last updated 9/2023

English

English [Auto],

What you'll 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.

Course content

12 sections • 37 lectures • 4h 40m total length

Quick Overview Of What You'll Learn, Guaranteed!3: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.
Factors In Selecting A Course1:35
What helps you determine if the course is for you?
See How Having More Control Over Your Data Will Save Time and Guesswork9:46
Convert raw data into organized formats in Excel using custom macro buttons that sort, group, and filter with a click. Build and customize macros to speed data analysis and reporting.
Quick Overview and Download of What To Expect4:28
What you will learn, Guaranteed, that will make you more effective.

Defining How The Sort Results Will Look11:01
Learn how to use color bars as safety markers, select full data ranges, and apply single and multi-level sorting to keep related data in sync, with a future macro.
Use The Custom List Within the Custom Sort Box, You Can Have More Control.12:53
Learn to use the custom sort box and custom lists to control sorting by month, color, day, and other categories, including creating new lists and reversing order.

Using The Record Macro Feature5:34
Record macros with the developer tab, name the macro without spaces, and stop recording after selecting data and applying custom sort to create a smart button that sorts a column.
Associating The Macro To Your Buttons5:51
Associate the recorded macro to a button by inserting its code into the button's shell in Visual Basic, creating a smart button that preserves data during sorting.
Making Smart Buttons
Associating The Macro To Your Buttons Continued10:39
Associate a second macro to a button, record and edit the macro in Visual Basic, and explore single and double level sorting—including reverse order—to automate data sorting in your sheet.
Double Level Sorting10:07
Record a macro to create a double-level sort in Excel, sorting by column C (days) then column D (time) in ascending order, via custom macro buttons.
Double Level Sorting

Working With Visual Basic Code To Customize Your Reports6:49
Making Your Buttons Do Double Work For You5:50
Automate data sorting with multi-level buttons in the back office Visual Basic area, sorting by months, then days and time descending.
Putting Your Buttons To Work
Creating More Room To Add Data Without Re-Recording5:39
Learn how custom macro buttons auto sort data by months descending, extend data and columns without rerecording, and update related code across targets using find-and-replace.
Allowing Your Data File To Grow
Optional Methods To Customize Your Sorted Headings11:21
Create custom macro buttons to mark and display sorted headings with cell markers, blanking others as needed, and indicate ascending or descending order across columns.

Adding Toggle Buttons Easily9:43
Learn to build and integrate toggle sort buttons in Visual Basic from scratch, enabling ascending and descending order for any column with unlimited rows.
Adding 'If, Then, Else' Intelligence To Your Toggle Buttons9:32
Master creating macros and toggle buttons with if-then-else logic by recording sorts, naming macros, and turning two macro routines into smart buttons with conditional code.
Toggle Button Smartness
Adding Intelligence To Your Toggle Buttons Dual Logic7:44
Learn to imbue toggle buttons with intelligence by pasting and tweaking macro code inside button shells, using if true else logic to control ascending or descending sorts and captions.
Labeling Your Toggle Buttons Captions

Adding Header Room & Adjusting Your Code To Match7:16
Header Room Precautions
More Toggle Button Code Modification5:45
Record and modify toggle button macros for column B, rename them, apply sort on column A from smallest to largest, and paste the code into Module 1 and Sheet 1.
Toggle Sorting Using Related Columns, & Keeping The Buttons Cleaner7:29
Double Level Sorting With Toggle Buttons10:26
Create a macro-driven toggle button to perform double-level sorting: sort by column c alphabetically, then sort by column d within each group.
More Control By Double Sorting To Filter Hidden Data9:03
Benefit Of 3 Level's Of Sorting With Toggle Buttons4:19
Factors In Reviewing a Course1:35
Was this course beneficial to you?

Requirements

Basic Excel skills.
Have a desire to learn the 'cause' and 'effect' of things.
Excel version 2007 or above is best.

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 this course is for:

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.

Creating Custom Macro Buttons To Do The Work For You.

What you'll learn

Explore related topics

Course content

Example Benefits Of Sorted Data In Excel4 lectures • 19min

Importing Your Data From Comma or Tab Delimited Text Files1 lecture • 5min

Creating Buttons For Each Column & Locating Them In Order2 lectures • 16min

Learning How To Use The Custom Sort Box2 lectures • 24min

Recording Macro's & Sorting On Two Levels4 lectures • 32min

Working With VBA Code To Adjust Sorted Data4 lectures • 30min

Toggle Buttons For Long Data Fields3 lectures • 27min

Understanding The True / False Options Of Toggle Buttons2 lectures • 17min

Making Better Use Of Toggle Button Code2 lectures • 7min

Single and Double Level Sorting Options Of Toggle Buttons7 lectures • 46min

Requirements

Description

Who this course is for: