Excel 2016 Course - How To Use Excel Comments
4.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,558 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Course - How To Use Excel Comments to your Wishlist.

Add to Wishlist

Excel 2016 Course - How To Use Excel Comments

Excel 2016 course : Learn Spreadsheet Comments skills
4.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,558 students enrolled
Last updated 2/2016
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 36 mins on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn how to use Excel comments more effectively for your spreadsheets
  • Learn how to use Excel comments to an advanced level
  • Increase your productivity by using Excel comments more concisely
View Curriculum
Requirements
  • A copy of Excel 2007-2016. Prior versions of Excel will work but are not supported for this course.
  • Students should be aware of what is VBA. This course does not delve too much into the technical side but will just explain in plain English what certain code lines do.
Description

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?

Who is the target audience?
  • Beginners-intermediate users of Excel
  • Analysts both data and business who frequently prepare reports
  • Anyone wanting to save time and money by learning more on Excel
  • Those wanting a quick refresher course on Excel comments
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 12 Lectures Collapse All 12 Lectures 37:43
+
Introduction
2 Lectures 02:27

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.

Preview 02:20

+
Deleting Excel comments all at the same time
1 Lecture 02:20

Lecture covers using Excel to delete all comments from a worksheet at the same time

Preview 02:20

Quiz on deleting comments

Deleting comments quiz
1 question
+
Excel comments - changing the colour of them
1 Lecture 05:55

Excel lecture on how to change the colour of Excel comments

Preview 05:55

Quiz on colours

Colours quiz
3 questions
+
Taking out the username from Excel comments
1 Lecture 06:35

Lecture uses VBA to show you how to remove the Excel username from commented spreadsheet cells.

Removing the username from Excel comments
06:35

Comments username quiz

Username comments quiz
1 question
+
Displaying formulas from cells in Excel comments
1 Lecture 06:55

Lecture shows you how to pull through formula text into an Excel comment

Showing Excel formulas in cell comments
06:55

Quiz on formula comments

Formulas comments quiz
2 questions
+
Automatically resizing comments in Excel
1 Lecture 04:08

Lecture shows you how to dynamically resize comments in Excel

Resize comments in Excel
04:08

Quiz on resizing comments natively

Resizing comments natively quiz
2 questions
+
Resizing comments across an Excel workbook
1 Lecture 02:54

Shows you how to resize comments across a workbook using VBA

Resizing comments using VBA in Excel across a whole workbook
02:54
+
Excel comment tips
1 Lecture 03:59

Lecture covers how to use comments and what not to do with them:)

How to use Excel comments properly
03:59
+
Course conclusion
2 Lectures 01:18

Lecture wraps up course

End lecture
01:00

Please consider leaving feedback
00:18
+
Bonus Section
1 Lecture 01:15
Bonus coupons to our other Excel courses
01:15
About the Instructor
Mach 42 Productions
4.5 Average rating
452 Reviews
14,675 Students
13 Courses
Excel Consulting- 14,600+ Students

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 14,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.