Use Excel Buttons to Sort Data & Find Answers Quicker!
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
Do you do battle with Excel every day at work? Row after row of data that you wish you could analyse quickly?This course focuses on create macros and buttons, with a bit of Excel Visual Basic, so you can control large amounts of data more effectively. If you have large Excel data files with columns and rows to sort through, this course will save your hours of back and forth searching.You will be able to customise buttons and macros for your needs, and they will be resuable for other files. Or simply start adding data to existing files that will automatically sort itself – no more inserting copied rows!
Facilities
Location
Start date
Start date
About this course
Sort any Excel file with rows of data by any column you choose at a click of custom button you make yourself. Learn basic VBA to give you control over Excel's most powerful features. Customise the macros you record to give your reports a professional look Get Excel working for you!
Anyone
None
Reviews
Subjects
- Excel
- How to use Excel
- MS Excel
Course programme
Say hi to your fellow students!
Share your new course with your friends!
Quick overview
Getting more control over your data
Importing
Sorting with buttons and macros
Creating buttons
Overview of what we're going to learn
Creating your first buttons
Screen lock
Custom Sort Box
A safety feature and a box
The Custom Sort List
Recording Macros
Using the record macro feature
Learning code
Assocating macro to button
Double level sorting
Working with VBA Code
Adding toggle buttons
Adding intelligence to your toggle buttons
Adding even more intelligence to your toggle buttons
True or False?
Understanding true or false in toggle buttons
Which is which?!
Toggle button code
Understanding toggle button code
WYSIWYG
Room for headers
Toggle button code modification
Toggle sorting
Double level sorting
Filter hidden data
Benefits of 3 levels of sorting
Advanced code options
Advanced code tweaking v recording time
BONUS TIPS!
Use Excel Buttons to Sort Data & Find Answers Quicker!