- Duration: Flexible
Course details
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!
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 â
Updated on 14 October, 2018About OfCourse
OfCourse Learning is one of the UK's leading e-learning providers, with over 700 expert-led online courses. Their course categories range from well-being and health to personal and career development. Their courses contain numerous video-lectures, downloadable written materials and engaging assessments. Whether you want to learn sign language, become an excel whizz, or need the latest stress-busting techniques, OfCourse has something for everyone.
There are several reasons why students are choosing OfCourse to learn a new skill.
- All courses are taught by verified experts
- Students enjoy 24/7 access to their courses
- Courses can be accessed on any device
- Students get lifetime access to their courses so they can work at their own pace
- On completion, students receive a course certificate from a recognised educational institution
- Become a part of a global learning community where you can talk with teachers and students about the course
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Excel for Accounting and Bookkeeping Course GateUSD 13
USD 260Duration: Upto 10 Hours - Learn Microsoft Excel in Arabic Alpha AcademyUSD 25
USD 200Duration: Upto 3 Hours