Udemy – Excel 2016 Course - How To Use Excel Comments

This Excel 2016 course will show you how to make better use of Excel comments. It will teach you how to use Excel comments to an advanced level. You will learn how to do cool things

such as:

• Change the colour of an Excel comment
• Delete all comments at once from a spreadsheet
• Resize comments automatically across a workbook

and much more:)This course makes use of the latest version of Excel, although the knowledge can be applied to prior versions too.
This is a bite size course and is also ideal for those wanting a refresher in Excel comments.
Take your Excel skills to the next level by learning how to use this often powerful but taken for granted feature of Excel. VBA is also used for some tasks.
As with all courses by Mach 42 Productions, support is provided via the discussion forums and messaging system.
What are you waiting for?

What are the 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.

What am I going to get from this course?

• Over 9 lectures and 36 mins of content!
• 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

What 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

Curriculum
Section 1: Introduction
Lecture 1 Introduction to course Preview 02:20
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.

Section 2: Changing the colour of Excel Comments
Lecture 2 Changing the colour of Excel comments 05:55
Excel lecture on how to change the colour of Excel comments

Quiz 1 Colours quiz 3 questions
Section 3: Deleting Excel comments all at once
Lecture 3 Deleting Excel comments Preview 02:20
Lecture covers using Excel to delete all comments from a worksheet at the same time

Quiz 2 Deleting comments quiz 1 question
Section 4: Displaying formulas from cells in Excel comments
Lecture 4 Showing Excel formulas in cell comments 06:55
Lecture shows you how to pull through formula text into an Excel comment

Quiz 3 Formulas comments quiz 2 questions
Section 5: Removing the username from Excel comments
Lecture 5 Removing the username from Excel comments 06:35
Lecture uses VBA to show you how to remove the Excel username from commented spreadsheet cells.

Quiz 4 Username comments quiz 1 question
Section 6: Resize comments automatically in Excel
Lecture 6 Resize comments in Excel natively 04:08
Lecture shows you how to dynamically resize comments in Excel

Quiz 5 Resizing comments natively quiz 2 questions
Section 7: Resizing comments across an Excel workbook
Lecture 7 Resizing comments using VBA in Excel across a whole workbook 02:54
Shows you how to resize comments across a workbook using VBA

Section 8: Using Excel comments properly
Lecture 8 How to use Excel comments properly 03:59
Lecture covers how to use comments and what not to do with them:)

Section 9: Wrap up
Lecture 9 End lecture 01:00
Lecture wraps up course







For More Rare Movies Check out my blog!

No Mirrors Please