Udemy : Excel 2016 Course - How To Use Excel Comments

[caovantan 42]

Udemy : Excel 2016 Course - How To Use Excel Comments

WEBRip | MP4/AVC, ~404 kb/s | 1234 x 720 | English: AAC, 62.4 kb/s (2 ch), 44.1 KHz | 121 MB

Genre: Office Productivity / Microsoft | Language: English | +Project Files

 

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

 

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.