Skocz do zawartości

Aktywacja nowych użytkowników
Zakazane produkcje

  • advertisement_alt
  • advertisement_alt
  • advertisement_alt
caovantan

Udemy : Excel 2016 Course - How To Use Excel Comments

Rekomendowane odpowiedzi

03be33d3c065e4c1e884c9f36c0e29b3.jpg

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

 

8faa5344d53198871c556ecae351735e.png

 

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.

Udostępnij tę odpowiedź


Odnośnik do odpowiedzi
Udostępnij na innych stronach

Dołącz do dyskusji

Możesz dodać zawartość już teraz a zarejestrować się później. Jeśli posiadasz już konto, zaloguj się aby dodać zawartość za jego pomocą.

Gość
Dodaj odpowiedź do tematu...

×   Wklejono zawartość z formatowaniem.   Usuń formatowanie

  Dozwolonych jest tylko 75 emoji.

×   Odnośnik został automatycznie osadzony.   Przywróć wyświetlanie jako odnośnik

×   Przywrócono poprzednią zawartość.   Wyczyść edytor

×   Nie możesz bezpośrednio wkleić grafiki. Dodaj lub załącz grafiki z adresu URL.

    • 1 Posts
    • 7 Views
    • 1 Posts
    • 10 Views
    • 1 Posts
    • 12 Views
    • 1 Posts
    • 10 Views
    • 1 Posts
    • 16 Views

×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Korzystając z tej witryny, wyrażasz zgodę na nasze Warunki użytkowania.