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

45,900 تومان

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

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

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

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