Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 40 Minute(s)
Language
English
Taught by
David Reynolds
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Excel: Sort Any Size Data File With Excel Macros & Custom Buttons, Learn Visual Basic to Customize Your Excel Reports.
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.
Course Content
- 12 section(s)
- 37 lecture(s)
- Section 1 Example Benefits Of Sorted Data In Excel
- Section 2 Importing Your Data From Comma or Tab Delimited Text Files
- Section 3 Creating Buttons For Each Column & Locating Them In Order
- Section 4 Learning How To Use The Custom Sort Box
- Section 5 Recording Macro's & Sorting On Two Levels
- Section 6 Working With VBA Code To Adjust Sorted Data
- Section 7 Toggle Buttons For Long Data Fields
- Section 8 Understanding The True / False Options Of Toggle Buttons
- Section 9 Making Better Use Of Toggle Button Code
- Section 10 Single and Double Level Sorting Options Of Toggle Buttons
- Section 11 Advanced Code Options
- Section 12 Bonus Tips
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.
Skills covered in this course
Reviews
-
MMelissa Wilson
Good outline of the course
-
RRashed Al Naamani
I learned allot in terms of how to automate my reports...really appreciated ...specially the toggle buttons was really useful of getting around my analytics and filtering data ...thanks
-
BBernd Nitzschmann
Auch ohne Vorkenntnisse machbar, gut verständliche Aussprache. Der Kurs beschränkt sich auf das Spezialthema von eingebetteten Sortier-Buttons, aber die Ideen lassen sich gut erweitern auf die Einbettung anderer interaktiver Elemente in Tabellenblätter.
-
CCharlie
Concepts and content are spot on but the narration is tedious. It would be better with some modulation of intonation or pitch in the voice.
