Use Excel Buttons to Sort Data & Find Answers Quicker!

Course

Online

Save 51%
£ 19 VAT inc.

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

Online

Start date

Different dates availableEnrolment now open

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • How to use Excel
  • MS Excel

Course programme

The Benefits
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!

£ 19 VAT inc.