Excel 101 for Virtual Assistants

سرفصل های دوره

The Virtual Assistant's Guide to Excel

1 - Introduction

1 - How to go about learning Microsoft Excel.html

2 - The Microsoft Excel user interface

3 - Navigating the Microsoft Excel interface

4 - Three types of clicks

5 - Data Types in Excel.html

6 - Basic Data Entry

7 - Introduction to Excel formulae

8 - Excel formulae and functions

8 - Excel-CS.pdf

9 - Absolute cell reference

10 - Delete and hide cells in a workbook

11 - What Virtual Assistants should be aware of.html

2 - Formatting in Microsoft Excel

12 - Basics of formatting

13 - Formatting with themes

14 - Tips and Tricks to speed up Data Entry.html

15 - Freeze Panes.html

16 - Conditional Formatting

17 - Tips and Tricks for better formatting.html

3 - Filter sort and custom sort

18 - Filter

19 - Custom Sort

20 - Summary on Filtering Sorting and Custom Sorting.html

4 - Charts with Microsoft Excel

21 - Introduction to variables and plotting relationships between variables

22 - Charts with Categorical Data.html

23 - Histograms boxplots and scatterplots

24 - Line bar and pie charts

5 - Pivot Tables with Microsoft Excel

25 - Pivot Tables

26 - Pivot tables with Slicer

6 - Intermediate Excel

27 - Logical statements in Excel IF

28 - Logical statements Nested IF

29 - Logical statements AND OR

30 - CHOOSE Statement

31 - VLOOKUP Exact Match

32 - VLOOKUP Range

33 - INDEX MATCH Statement

34 - Data Validation

35 - Data Validation Drop Down

36 - Data Tables

37 - Use Cases for Data Tables.html

38 - Goal seek

39 - Use Cases for Goal Seek.html

40 - Trace precedents and dependents

41 - Tips and Tricks to get the most out of Excel.html

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training