This Excel 2016 tutorial course teaches you how to use Excel comments effectively to make better spreadsheets. Learn how to resize comments, change the colour of comments and delete all comments (very quickly).
Course is filmed in Excel 2016 although the material will work in prior versions of Excel.
This course serves as a refresher in Excel comments (under 1 hour!)
This course also makes use of VBA to do uber cool things to comments!
All Mach 42 Productions courses have full discussion forum support.
What are you waiting for?
Overviews Excel course by Mach 42 Productions. Lecture will explain what the course is about, some of thing concepts you will learn on Excel comments, best ways to learn from this course and the overall aim of this course for the student.
Lecture uses VBA to show you how to remove the Excel username from commented spreadsheet cells.
Comments username quiz
Lecture shows you how to pull through formula text into an Excel comment
Quiz on formula comments
Lecture shows you how to dynamically resize comments in Excel
Quiz on resizing comments natively
Shows you how to resize comments across a workbook using VBA
Lecture covers how to use comments and what not to do with them:)
Lecture wraps up course
Our Udemy Excel courses have been developed to cover a wide range of needs for the Excel user. There is a course to suit everyone from beginners level to advanced. We provide all workbooks and full support via the discussion forums. Simply put our Excel courses use real life examples and not just theory to help you learn and improve yourself and give you proper skills you can use in your workplace.
Our Excel IT Consultant/Instructor Navin has been in the IT industry for approximately ten years. Recently featured nationwide in Costco Magazine, Navin has over 6 years experience as an Analyst. Having self-taught himself Microsoft Excel and VBA, he achieved MCAS (now known as Microsoft Office Specialist) certification in Excel in 2010. His work in Excel has been varied having worked on automating and streamlining reports to building and deploying real time dashboards to monitor performance.
During his time as an Analyst, he often assisted colleagues who needed problems solved in Excel. By relating the functions to use, to the context of their problem, his colleagues were able to grasp the concepts of what functions to use and in what context.
This spurned Navin's need to develop these range of Excel courses which to date have over 16,600 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.