Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Example Benefits Of Sorted Data In Excel|
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.
|What helps you determine if the course is for you?|
See How Having More Control Over Your Data Will Save Time and GuessworkPreview
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
|Section 3: Creating Buttons For Each Column & Locating Them In Order|
Creating Customized Command Buttons
Fine Tuning Buttons With Properties
|Section 4: Learning How To Use The Custom Sort Box|
Defining How The Sort Results Will Look
Use The Custom List Within the Custom Sort Box, You Can Have More Control.
|Section 5: Recording Macro's & Sorting On Two Levels|
Using The Record Macro Feature
Associating The Macro To Your Buttons
Making Smart Buttons
Associating The Macro To Your Buttons Continued
Double Level Sorting
Double Level Sorting
|Section 6: Working With VBA Code To Adjust Sorted Data|
Working With Visual Basic Code To Customize Your Reports
Making Your Buttons Do Double Work For You
Putting Your Buttons To Work
Creating More Room To Add Data Without Re-Recording
Allowing Your Data File To Grow
Optional Methods To Customize Your Sorted Headings
|Section 7: Toggle Buttons For Long Data Fields|
Adding Toggle Buttons Easily
Adding 'If, Then, Else' Intelligence To Your Toggle Buttons
Toggle Button Smartness
Adding Intelligence To Your Toggle Buttons Dual Logic
Labeling Your Toggle Buttons Captions
|Section 8: Understanding The True / False Options Of Toggle Buttons|
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?
|Section 9: Making Better Use Of Toggle Button Code|
Following Thru With Button Captions
WYSIWYG, Button Caption's Are For The Future
Toggle Button Coding
|Section 10: Single and Double Level Sorting Options Of Toggle Buttons|
Adding Header Room & Adjusting Your Code To Match
Header Room Precautions
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?|
|Section 11: Advanced Code Options|
Advanced Code Tweaking vs Recording Time
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
Collecting your own data from anywhere, and forming different pictures from the click of a button.
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.
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.
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.