Skocz do zawartości

Aktywacja nowych użytkowników
Zakazane produkcje

  • advertisement_alt
  • advertisement_alt
  • advertisement_alt
caovantan

Microsoft Excel in.75 minutes - Part 5

Rekomendowane odpowiedzi

d2c1bda8c83a9ce683d5f8d554aa06ad.jpg

Microsoft Excel in 75 minutes - Part 5

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1 Hours | Lec: 14 | 316 MB

Genre: eLearning | Language: English

Learn the most valuable features of Microsoft Excel in under 75 minutes. Get 100% completion on this class.

 

About the class:

 

This is part 5 of a series of classes on how to use Microsoft Excel. The objective of the series is to break the study of Microsoft Excel into small manageable pieces that can easily be completed in under 75 minutes. You can complete this class in a single session. Take advantage of this opportunity to learn Microsoft Excel.

 

What is Microsoft Excel?

 

Excel offers a drawing board for daily challenges in a spreadsheet format. Excel allows its users the ability to enter data in a table format. After arranging the data in an excel sheet users are then able to perform calculations on this data for the purpose of data analysis. The type of calculations that needed to be made over hundreds of pages of paper can now be made in a single spreadsheet through Microsoft Excel.

 

Why learn Microsoft Excel?

 

There is a very valid and compelling business reason for learning Excel. However more compelling than the business reason is the value excel brings into our personal lives. Excel can serve as a decision making tool as well as a personal life management tool. Management of personal finances becomes significantly easier with the help of Microsoft Excel. Other very common uses of Excel in person life include job application management, weight management, vacation budget management, market analysis and decision analysis. On the business end, excel is essential for all business success. Microsoft Excel lies at the core of all business decision making. The charting feature of excel allows for the representation of data in a colorful format that plays an integral role in business communication. Microsoft Excel is driving Global business decisions in all types of business ranging from large corporations to small privately owned companies. Most all professionals come across Microsoft Excel at some point in their careers.

 

Who is this class for?

 

This is a beginner and intermediate level class.

 

Class outline:

 

1. Functions: Vertical and Horizontal Lookup ~ 23 minutes

 

Vlookup and Hlookup Part 1 ~ 4 minutes

 

Vlookup and Hlookup Part 2 ~ 5 minutes

 

Vlookup and Hlookup Part 3 ~ 5 minutes

 

Vlookup and Hlookup Part 4 ~ 6 minutes

 

Vlookup and Hlookup Part 5 ~ 4 minutes

 

2. Functions: Vertical and Horizontal Lookup with Index ~ 9 minutes

 

3. Functions: SumIf and AverageIf ~ 38 minutes

 

Functions: SumIf and AverageIf Part 1 ~ 7 minutes

 

Functions: SumIf and AverageIf Part 2 ~ 7 minutes

 

Functions: SumIf and AverageIf Part 3 ~ 4 minutes

 

Functions: SumIf and AverageIf Part 4 ~ 7 minutes

 

Functions: SumIf and AverageIf Part 5 ~ 7 minutes

 

Functions: SumIf and AverageIf Part 6 ~ 6 minutes

 

Download link:

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.

 

Links are Interchangeable - No Password - Single Extraction

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
    • 21 Views
    • 1 Posts
    • 11 Views
    • 1 Posts
    • 16 Views
    • 1 Posts
    • 10 Views
    • 1 Posts
    • 11 Views

×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

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