1 - 2 CPE Excel expert David Ringstrom, CPA, takes you step-by-step through the process of creating and using macros—one of Excel’s most powerful features. In this comprehensive presentation, he introduces the concept of Excel macros as well as the Visual Basic for Applications (VBA) macro. David also explains step-by-step how to use the Record Macro feature and Excel’s Personal Macro Workbook. After completing this course, you’ll be equipped to use macros immediately.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Topics Covered:
- Making sense of the Enable Content prompt related to macros in Excel.
- Uncovering macro-related commands within Excel’s user interface.
- Automating a repetitive task, such as formatting a set of phone numbers consistently.
- Utilizing the Relative References setting for creating Excel macros to be played back on any cell versus specific cells.
- Understanding the purpose and nuances of Excel’s Personal Macro Workbook.
- Recording a contact info macro.
- Deciphering and managing Excel’s macro security prompts.
- Converting .XLS workbooks to the up-to-date .XLSX format with just two keystrokes.
- Understanding how macros are used in Excel, along with the risks and benefits associated with them.
- Learning the risks and frustrations of using merged cells in Excel worksheets.
- Learning how to use Excel’s Record Macro feature to create simple macros, without having any knowledge of programming.
Course Series
This course is included in the following series:
4 CoursesExcel Efficiency: Macros
- Excel Efficiency: Intro to Macros Part 1
- Excel Efficiency: Intro to Macros Part 2
- Excel Efficiency: Intro to Macros Part 3
- Excel Efficiency: Intro to Macros Part 4
Learning Objectives
- Discover how to create general-use macros with the Relative Reference setting for Excel’s Macro Recorder.
- Recognize when to use the Hide and Unhide commands in an Excel Personal Macro Workbook.
- Identify how to apply Visual Basic for Applications (VBA) macros in Excel.
Last updated/reviewed: March 4, 2024
Included In Certifications
This course is included in the following Certification Programs:
17 CoursesExcel Modeler Certification
- Excel Efficiency: VLOOKUP
- Excel Efficiency: Logic Functions
- Excel Efficiency: Filtering and Formatting Data
- Excel Efficiency: Intermediate Pivot Tables
- Excel Efficiency: Auditing Spreadsheets
- Excel Efficiency: Minimizing Worksheet Errors
- Excel Efficiency: Workbook Links
- Excel Efficiency: What-If Analysis in Microsoft Excel
- Excel Efficiency: Quick and Easy Financial Statements in Excel
- Excel Efficiency: Budget Spreadsheets
- Hands-On Excel: Waterfall Calculations
- Excel Efficiency: Table Feature
- Excel Efficiency: Intro to Macros Part 1
- Excel Efficiency: Intro to Macros Part 2
- Excel Efficiency: Excel Chart Speed Tips
- Excel Efficiency: Taming Large Spreadsheets
- Excel Efficiency: Internal Controls
174 Reviews (548 ratings)
Reviews
Anonymous
(CPA)
This course was a fantastic introduction to macros, especially for someone who has not used macros before. The instructor was clear and helpful, and moved at an adequate pace to keep track of each step in creating a macro. On one or two minor occasions, the video program didn't follow the same order as the slides, so I would possibly edit the video to fix these issues. I would also consider increasing the amount of CPA credits from 2 to 2.5 CPE credits, as between listening to the video, pausing to follow the instructor's steps on a separate Excel document, and taking the final exam, the course took more than 2 hours.
tom granger
( at Washington Eductation Association)
I had limited experience w macros prior to taking this course, but had familiarity with some functionality that was covered. what was really helpful was the fairly comprehensive review of macros generally, and a lot of details that I knew nothing about, such as the "personal" workbook that stores macros, use of "relative references", and the errors avoided by using shortcut keys rather than the mouse when building a macro.
Anonymous
(Senior Auditor)
Great information. Would be nice if the instructor talked a little about the sample workbook provided - do we need to make separate copies. The one workbook, Sales_by_Customer or something like that just came out of nowhere. I have years of Excel experience and I'm a quick learner, even in a virtual environment, but found myself having to do a lot of backtrack and reviewing in this course.
Anonymous
(Director)
David is very good. I will take more of his courses. His way of presentation is very helpful where he will start with specific instruction/steps and then he will demonstrate it. I always thought macro is very complicated but David made it simple. Right after taking this course (in fact while taking this course), I was able to create at least three macros that save me time at work.
Anonymous
(Accountant)
Intro to Macros Part 1 provides a good start to simple macros. I am looking forward to the future macro courses to have more advanced functionality especially how to prompt for a file location. Just learning about Center Across Selection versus Merge was helpful to avoid some problems with spreadsheets. David is a good instructor.
Anonymous
(Finance)
Helpful bite-sized course that focuses on simple Macros for an appropriate introductory course. General familiarity with MS Excel is super useful to make this more fruitful. Good reminder to use broader keystroke commands during this course. Focus on the Learn Function keeps this course from getting too complicated.
Anonymous
(Senior Accounting & Reporting An..)
I did not do continuous play but the sections seemed to cut off when doing the individual plays - it was confusing at first because I thought the subject of information was complete when the instructor had not yet gone through the example. Overall though the instructor was very clear and presented at a good pace.
Jewel Eronson
(Sr Financial Analyst at Robert W Baird)
I liked the visual that showed all the steps before we went through it together. Very helpful for someone who has never used macros. I would have liked to move through the demos a little faster. In a couple instances I found myself finishing the demo before the webcast so I would fast forward.
Anonymous
(Associate Director, CFCC Assurance)
Great beginner course into macros. I had limited experience in macros and did not bother to learn their usage because they seemed complicated. However, this course outlines their functionality and limitations in a seamless approach. Will definitely be taking David's other macro courses.
Robert Stellato
( at DS Smith)
Another Excellent course.. I now know how to created and use macros and can apply this knowledge to my actual job, which is fantastic. So.. not only do I earn the CPE credits I need to renew my CPA license I have enhanced my skills in Excel greatly
Vickie Jackson
(Accounting Manager at NewStar Sourcing and Service)
David Ringstrom's courses are very thorough and this one is no exception. He gives many examples and explains each one as if it's the first one so the repetition sticks. The examples he provides are ones that most people will find useful.
William Lathrop
(- at Artful Home, LLC)
I enjoy David's courses. They are interesting, thorough and have a great work flow. I like how he outlines what he is about to do through explaining the relevant issues and then demonstrates. I think that reinforces the learning.
Excellent presentation informative and easy to follow instructions, i am impressed the way Mr.Ringstorm explained the the topic he made it very simple and clear.
definitely going to take more courses with hum in the future
Thanks
Tyler Hooks
(Derivatives Intern at Novelis)
Easy to follow course. I would prefer that he skip the powerpoint parts and jump straight into the macros (it doubles the length in most cases). It is informative, but it does not get into any VBA. I assume that is in future parts.
Anonymous
(AP Specialist - Payments Team)
Very useful introduction to macros for a beginner! I did not have experience in dealing with them other than running them, but now I feel confident I have a better understanding of the process of creating a macro after this lesson.
Judith Moscova
(Accountant at N/A)
I learned a lot about macros in this session. David explained the topic and demonstrated the steps very well and I look forward to extending my knowledge on the topic. I also would not mind doing another class with David.
Anonymous
()
Best class I have found covering this topic yet. Finally not just informative, but walks through process in detail and provided helpful examples to make daily tasks way easier. Centering across will save me so much hassle.
Anonymous
(Controller)
Great course. I will be taking the remaining Macro courses provided by David. His pacing is excellent and his visual guides are thoughtful and thorough. I already have uses for implementing macros into my responsibilities.
Anonymous
(Senior Accountant)
My favorite Excel instructor. Shows the steps prior to taking them, makes it easy to follow, pace is easy to follow. I have already used the macro recorder but this course showed me many things I did not know.
Ted Feher
(Owner at Feher, PC (CPA))
Have not done much work with Macros, thought it too technical a subject, but this was an excellent beginning course and provided some very practical examples on how powerful and simple the Macro can be.
Jeff Bone
(Financial Advisor at Northwestern Mutual)
Good teaching to build the foundation, macros are tricky to first time users and this helped me understand alot of the little mistakes I did not know before. Looking forward to the next 2 macro lessons!
Easy to follow instruction. Creating onscreen example of how everything worked was most helpful. I am a visual person.
Check the first section - begins over again instead of covering the last slide.
David Lugviel
(Senior AR Rep at Yelp)
Great intro to creating macros in Excel. Focuses on the Macro Recorder feature, which is an easy way to begin learning the macro process. Looking forward to taking more in depth courses on this topic!
Christopher Kidwell
(Senior Accountant at Charter Communications)
Interesting course, and the videos are well done. I would suggest reviewing the order you have your clips listed. It seems like some are our of order and a couple of the clips end at odd places.
Anonymous
(Mgr, Accounting/Reporting, Internal Repo..)
Very basic plus this instructor is very repetitive, but oddly the exam had more excel based questions not really any around creating a macro which is what this course was suppose to be teaching.
Anonymous
(Controller)
Great introduction to Macros. Covered the very basics and gave a few examples of macros that could be very helpful. Also pointed out some of the pitfalls to look out for when using macros.
Anonymous
(Attorney)
Macros are something I seem always forget once I have set up what I need. I appreciated the different examples of types of Macros, which was aslo a refresher on those features in general.
Rachel Cauthon
(AVP, Corporate Tax Manager at UMB Financial Corporation)
Very helpful, I liked that the topic was overviewed by the speaker with pictures and numbered steps and then demonstrated. Easy to follow along with the instructor and apply hands on.
Lori Sherrill
(CPA at TIM THOMAS CPA LLC)
I wish I had have taken this course a long time ago. It would have saved me much time! The presenter was very knowledgeable and engaging. It is well worth the time to take this course.
Anonymous
(Accountant)
I already knew how to use the macro recorder, but this course helped fill in some gaps in my knowledge. It also helped me get a broader view and added some features to my tool kit.
Anonymous
(Director, Research)
A very solid course for getting both a basic understanding of Excel Macros, as well as the ability to walkaway with a clear understanding of how they can be applied in your work.
Anonymous
(Sr. Financial Analyst)
This course is a great introduction for Macro novices like myself. Notes from this course will serve as valuable reference material as I move on to more Macro classes.
Sheila Mehta
(N/A at PSSI group)
instructor makes too many typing errors which can be distracting. Also he repeated some steps over and over...especially about the icon for the recorder at the bottom.
Edward Thill
(Consultant at None)
Great course for someone who has never used macros before - very introductory but that's what I needed. Goes no further than explaining use of the record button.
Anonymous
(Senior Accountant)
I like that the course was clear and concise. It was also nice that there was preview of the tasks that he was going to do before actually executing the example.
Raveendran Madappattu
View Instructor Profile
Great lesson. It gives insight into the basics of MACROs in Excel. Definitely worth recommending for those looking for automating some repetitive tasks in Excel.
Anonymous
(Corporate Controller)
Course is great to provide a starting point. There are very good examples and demonstrations on how Macros work and how it can be set up. Worth the 2 hours
Anonymous
(CFO)
Instructions were clear and uncomplicated. i liked that the instructor first told us what steps we were going to take and then demonstrated those steps.
Jacob Rothman
(Portfolio Manager at Rothman Investment Management)
Great intro to macros. This course explained what a macro is, and a couple different ways to record them as well as examples of when they are useful.
Keith Baker
(Data Analyst at Charter Communications)
Lots of really good information on creating the macros and creating shortcuts. The phone number clean-up is spot on for what I need, great example.
Anonymous
(Sr Accountant Lead)
Informative course on how to create and use Macros. I like how David numbers the steps while explaining the process then shows the steps in action.
Anonymous
(Accountant)
Macros are great! These make my job so much easier. I did not know about assigning icons and using Alt+ number to quickly run my Macro. Nice!
Kim Hughes
(Accounting Manager at Lagoon Water Midstream)
In addition to macro recorder basics, I learned a couple of excel features! I appreciated the thorough explanations, common issues, and risks.
Sandra Heelan
(CPA, CFE, MBA at None)
Another great Excel class that will be very useful and great reference material. Covered how to create Macros and provided good practice.
Anonymous
(Director)
A great introduction to macros. David also provided many other tips throughout this course. I look forward to putting these into action.
ERICA CARPER
(Controller at MWP)
Great process with screenshots explaining key steps then actually performing. Appreciate not feeling like he's just reading from text.
Anonymous
(State Report)
The course was very interesting and I learn more about macros. Thank I recommend you take the course if you work with high levels of data
Anonymous
(CPA)
Great pace and good examples! The instructor was very easy to follow and good at explaining step by step how to create and use macros.
Sergey Bulychev
(internal auditor at Transneft Finance LLC)
И как всегда, великолепный курс от Дэвида! Все актуально и все интересно!
Anonymous
(Finance & Accounting Consultant)
Approach used with slides first before showing in Excel is very effective. Slides will also be a useful reference for the future.
Norman West
(Financial Manager at Lockheed Martin)
There was some repetition, but overall a useful course. I can think of several tasks I could automate using a macro in Excel.
Rahman Ullah
(Senior Accountant at Cardtronics)
Great comprehensive instruction to the macro recorder function. Love Davids courses but wish they could be condensed slightly.
Anonymous
(Accountant)
This was a great intro to macros. I liked flow of the information, and I have already used the record macro in my daily work.
Anonymous
(Fund Accountant)
This is the first time I have ever used a macro.
I found the course easy to understand and moved at just the right pace.
Anonymous
(Accountant)
Good course on Macro 1. Slides were sometimes cutting off or ending abruptly but that did not take away from the experience.
Anonymous
(Founder)
Great introduction to what macros are about and how to use the basic functions. Will enroll in Parts II through IV as well.
Monica Banman
(CPA, CMA at NJB Accounting Services)
As a beginner, it was very basic and taught in a simple fashion just to grasp the concept of a macro...not over my head!!
Anonymous
()
I liked the fact David told us what he was going to do and then showed us. This helped focus and reinforce the learning.
Terri Salazar-Rodriguez
(None at None)
The visual step by step examples very helpful. Great class to learn basics and how to avoid errors when creating macros.
Anonymous
(Senior Auditor)
Very thorough explanation on how to begin using macros! Looking forward to completing additional courses in the series.
Anonymous
()
Great introduction to macros. Mr. Ringstrom provides several great examples where macros can provide work efficiencies.
Anonymous
(Controller)
Good course, but it would have been so much better to see the actual Excel work rather than just looking at the slides.
Torin Campbell, CMA
(Controller at Form-A-Fab)
A very good outline of the steps to create and manage macros. It opens the door to some pretty powerful stuff in Excel!
Anonymous
(solo)
Great course. Ringstrom is a great instructor. Very good illustrations along with actual walkthroughs is very helpful
Anonymous
(Senior Internal Auditor)
this course provided a solid overview of the use of macros in excel. It further provided good examples and walkthroughs
Janae Dacut, MBA, CIA
(Auditor at Kaiser Permanente)
Very informative class on intro to creating macros! Since I am relatively unfamiliar with macros, this helped a lot.
Sabir Khan
(Admin at IT)
Good Refresher course by a knowledgeable instructor for those who don`t deal with it every day or are the novice.
Scott Anderton
(CFO at HCA)
I have enjoyed a couple of your courses and am having fun creating my own macros now. Thank you for the knowledge!
Anonymous
(Wireless Data Analyst)
The training was very easy to follow-up. I learned so much, andknow will start implementing what I learned today.
Emma Harrington
(Audtor at Carnival Corporation Internal Audit)
Course is well designed - the explain, show and work through approach at a sensible pace is perfect for learning.
Anonymous
(Finance Director)
Good pace, allows beginners time to follow the examples and learn by doing the steps along with the instructor.
Elaine Chang
(Operations Manager at Kapiolani Community College)
Instead of still screen shots, live action video while the instructor is explaining would be easier to follow.
Anonymous
(Controller)
It was helpful. I'm glad the slides had all the information from the presentation so I could refer back to it.
Anonymous
(President)
The handouts provide step by step guidance and the demonstration allows viewers to see the macros in action.
Anonymous
(CPA/Investment Advisor)
Very simple beginners course for recording basic macros - best for those who have never used macros in Excel
Anonymous
(Director)
Good introduction to macros and how to use. Repetitive process helps for those not as familiar with excel.
Anonymous
(Accountant)
Good intro to macros. Appreciate the examples provided. Prereq should be listed as some knowledge of Excel.
Mark Eastman
(Accountant at Self)
Nice introdution to Macro creation via the Recorder feature. Look forward to remaining parts of the suite.
Jacob Daniel
( at United Community Bank)
Good class - really enjoyed the content. I do not enjoy having to write reviewed for each class though
Anonymous
(Senior Accountant)
This was a challenging course but well worth the effort for the skills learned. The instructor is good.
Anonymous
(Technical Accountant)
Short and Sharp - very simple to understand. Also additional tips of use of status bar was good one.
Eric Oosta
(Senior Associate at Grant Thornton LLP)
Loved it. Many thanks. Definitely will be looking for areas to build macros into my workflow now.
Anonymous
(CFO)
The instructor took time to explain the concept first before showing it practically on the excel.
Robert Workman
(Senior Lean Development Officer at Confidential)
New to macros, this was a good introduction - will have to practice getting the language correct.
Alyssa Angell
( at Inspirato)
This course was very informative and taught me several macro tricks that I didnt know. Thank you!
Monica Berdejo
(Controller at ICI Development)
Instructor does a great job of explaining how to use macros and other tips and tricks of Excel.
Anonymous
(CFO)
End of automating center across selection sound is the beginning, not what the screen is showng
Jeff Marcacci
(Senior Tax Manager at Intuit Inc.)
Very good teaching technique; explains goal and steps and then shows actual execution of steps.
Anonymous
(Research Service Analyst)
This a really great course. I would recommend it to anyone who does the same tasks every month.
Miriam Endoso
(None at County of San Dieego)
Good introduction to Macros and found it useful especially with the quick access to the Macros
Anonymous
(Accounting Clerk)
Great introduction to macros. The tips about relative references in macros are very helpful.
John Russell
( at The Master's University and Seminar..)
Good introduction to macros. Could provide more info on the text of the macros themselves.
Zulfiqar Haider
(None at None)
Very well introduction to Macros, which is usually daunting for most of the accountants.
Anonymous
()
Good introduction to Excel macros for beginners (creating macros using the macro recorder)
Anonymous
(-)
Great to learn how to automate repetitive things we do in every excel sheet we work with.
Anonymous
(Senior Financial Analyst)
Good introductory course at a good beginning pace. I hope to start recording macros soon!
Anonymous
(Director)
This was an ok survey of a broad range of Excel topics. Not much on actual macro coding.
Jing Li
(Sr Manager at Leadiant)
The tutor is great at explaining and showing examples. I learned a lot from this class.
Marquis Huntsman
(CFO at Castle Breckenridge Management)
Great intro to macros. A little repetitive but that reinforced what was being taught.
Anonymous
(CPA)
Glad to find out about the Personal Macro Workbook and other aspects of Excel macros.
Wei Han Koh
(Finance at Private)
Great for beginners to macros and VBA. Thank you, David, for producing this content.
Rhonda Unthank
(Sr. Accountant at 84.51 LLC)
Excellent overview of macro basics. Can't wait to start using this functionality.
Gwen Pfeifer
(Sr. Payroll Rep. at RW Baird)
I like the speaker; he is easy to follow. The screens are very well presented.
Martin Smith
(owner at M. Ward Smith, Inc.)
Can't say what it would take to make this work for me. Impossible to follow.
Fay Chen
(Finance Manager at Kowa Research Institute Inc.)
Really helpful for introducing Macro which I didn't have any idea before.
Anonymous
(Manager)
This course is at the right pace to learn the basic steps to add a macro.
Pamela LaPlaca, CPA
(Controller at EG USA)
I thought I was an advanced excel user but I learned a few new tricks!
Scott Weber
(VP/Manager ACL Models at UMB Financial Corporation)
Great refresher course on macros. Easy to follow and very applicable.
Juliana Veiga
(Controllership Coordinator at Novelis)
pdf file really helpful, so many ways to make easier the excel work.
Lucas Kysely
( at Edcetera)
Picked up a few tricks from this course. Liked the examples provided.
Libby Antognoli
(CFO at LSI (Landscape Services Inc.))
I like to see all the steps and then watch you do the steps on excel.
Jan Stammer
(Administrative Assistant at Alloya Corporate Federal Union)
I'm not very familiar with macros and this course explained it well.
Bruce Reed
(Chief Financial Officer at PracticeLink)
I really like the labelled examples. Great way to clarify the steps.
Dinah Sarman-Moschetti
(Accounting Manager at Global Executive Management Services)
Great - I am a beginner with Macros so this gets a very good start.
Sheilah Brown
(Controller at SMB LTC)
Very thorough review of how to get started with macros in Excel.
Anonymous
(APS)
Easy to understand for someone without a lot of macro knowledge.
Geoff Bosley
(Corp Controller at Aperture Credentialing, LLC)
Easy to follow, David did a great job explaining macro basics.
Erin Peabody
( at IIAT)
Learned lots of new info that I can use in my job right away.
Anonymous
(Sr Accountant)
This course is a great introduction to using Macros in excel.
Rachael Smith
(Senior Internal Auditor at FJ Management)
I would recommend this course - it's a good starting point.
Anna Gerstenberger
(Senior Tax Staff at EKS&H)
This was excellent, I had no idea how much Excel could do.
Anonymous
(Controller)
Like that he talks about the steps and then executes them
Alex Bermudez
(N/A at N/A)
I wish the starter course was more in-depth or tangible.
Jennifer Bor
(Sole Practitioner at Accounting and Business Management Consu..)
works for what i need to renew my cpa and cia licenses.
Anonymous
(Senior Accountant)
This was a very good course that was presented well.
Anonymous
(Consultant)
Good overview and refresher of the basics of macros.
Michele Harris
(Sr. Accountant at Novelis)
The instructor was thorough and very easy to follow.
Anonymous
(CPA)
Great slides and easy to follow. Highly Recommend!
Anonymous
(Chief Financial Officer)
Good information, things are different on a Mac.
Anonymous
(Collections Analyst II)
Instructor is precise and easy to understand.
Anonymous
()
well presented, it simplifies learning Macros
Anonymous
(None)
Guidance was clear and it was well presented.
William Peden
(Finance at RHMR)
Nice simple introduction to recording macros.
Rudy Fischer
(Partner at RKFischer & Associates)
great examples which I could use immediately
Matt Osmundsen
(Category Finance Director at Energizer Holdings, Inc.)
Great course! Very informative and helpful.
Jeff Politte, CFA, CTP
(Portfolio Manager at State Auto Insurance)
Ready to move on to the next part of macros
Amy Dyer
(Finance Director at Modern Pest Services)
Great information. It will be very useful.
Peter Abader
(- at BMO)
Really a good start for understanding Macro
Siva Vinay
(Controller at Park n Fly)
easily understandable, clear explanation.
Anonymous
(Sr. Director, FP&A)
Very helpful to get started with macros.
Brian Johnson
(Self Employed at Self Employed)
Very clear and thorough presentation.
Anonymous
(Accounting Manager)
excellent information. easy to follow.
Anonymous
(Controller)
good course for basic intro to macros
Becky Williams
(Manager of Operations Accounting at CONSOL Energy, Inc.)
Very practical and presented well.
Shelly Woods
(Market Controller at KTXS News)
He is very clear in his explanations
Anonymous
(Sr Financial Analyst)
Very useful and easy to understand.
Anonymous
(Controller)
good reminders and tips for macros
Charles Elwis
(Insurance Broker at Health Guys)
Effective introduction to macros
Anonymous
(-)
Great class - learned so much.
Darcie Saunders
(Director of Finance and Contracts at Cardinal Engineering, LLC)
Thorough introduction to macros
Anonymous
(Senior Director & Controller, Financ..)
Great course. Well presented.
Anonymous
(Chief Financial Officer)
Thought it was a good course.
Joe Fleming
(Finance Controller at Cisco Systems)
Great tips on creating Macros
Anonymous
(CM)
The tutor is very informative
Anonymous
(None)
Simple intro. Straighforward.
Anonymous
(auditor)
Like this training very much
Anonymous
(-)
Very effective presentation.
Susan Kolarchick
(Accounting Specialist at Acme Industrial Supply)
Content was very thorough.
Anonymous
(Attorney)
Much better than expected!
Jack Lim Chin Soon
(Finance, HR, IT and Administration Manag.. at Atlantic Forwarding Pte Ltd)
Very easy to understand
Ramakrishna Nalluri
(Senior Financial Analyst at LifeWorks Inc)
effective presentation
Chris Grimes
(Rules Master at Cisco)
Good intro to macros
Anonymous
(Credit and Collections Manager)
awesome and helpful
Lindsey Coburn
(Accountant at Seabury Group)
Good introduction.
Anonymous
(Treasury and Fixed Asset Accountant/Reco..)
Clear and concise
Patricia Mayou
(Senior Treasury Analyst at Nypro)
Good information
Douglas Ronald
(---- at ------------)
Good Excel tips!
Margaret Winn
(Accounting Professional at .)
Helpful intro.
Kerry Reeves
(Senior Internal Auditor at Ms.)
Good refresher
Anonymous
(Farm and Nursery Manager)
Love the info
Robert Godfrey
(CPA at Robert Godfrey, CPA)
Very helpful
William O'Donnell
(Chief Financial Officer at Rochdale Investment Management)
good class
Anonymous
(AR Specialist)
helpful
Sweta Patel
(Transactional Payment Representative, Ac.. at Yelp)
nice
Prerequisites
Course Complexity: Foundational
No Advanced Preparation or Prerequisites are needed for this course.
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA
95113
Contact:
For more information regarding this course, including complaint and
cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to
.
Course Questions and Answers(2 Questions)
David RingstromCPA, author, Microsoft Excel trainer and consultant
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 1608 W Campbell
- Av #221, Campbell, CA 95008
© 2024 Illumeo, Inc.
Hi, I'm working on a macro and trying to add to my macro commands to identify and delete empty text files in Excel 10. Any suggestions? Thanks
You can adapt the macro that gets discussed in this thread:
http://www.xtremevbtalk.com/excel/323419-delete-empty-folders-zero-kb-files.html