Excel: Master Microsoft Excel do Basic to Advanced Excel

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

Master microsoft excel from Basic to Super Advanced with practical lessons and real projects in just 13 hours.

1 - Before You Start

1 - All files that will be used in training.html

1 - All files that will be used in training.txt

1 - Basic-presentation.pptx

1 - Countries-by-GDP.pdf

1 - Feb-2008.csv

1 - IT-Spend-Analysis-Sample-no-PV.xlsx

1 - Inventory.v2.xlsx

1 - Inventory.v3.xlsx

1 - Jan-2008.csv

1 - Mar-2008.csv

1 - Retail-Analysis-Sample-no-PV.xlsx

1 - Service-price-list1.pdf

1 - Simple-Gantt-chart1.v2.xlsx

1 - Simple-Gantt-chart1.xlsx

1 - UnPivot.xlsx

1 - data.csv

2 - Enter the arena Introduction to Excel

2 - Introduction to Excel

3 - Excel Interface Navigation

4 - Working with Workbooks

5 - Basic Data Entry

6 - Customizing Quick Access Toolbar

7 - Basic Formulas and Functions

8 - Cell Referencing

9 - Formatting Cells

3 - Goose egg Excel Basics

10 - Managing Worksheets

11 - Copying and Moving Data

12 - Using Find and Replace

13 - Printing and Page Layout

14 - How Functions Work

15 - Functions and Formulas

16 - Data Sorting and Filtering

17 - Working with Tables

18 - Cell Styles and Themes

4 - Unsong Hero Intermediate Excel

19 - Conditional Formatting

20 - Charts and Graphs

21 - Freeze Panes and Split View

22 - Removing Duplicates

23 - Creating Data Validation Lists

24 - Flash Fill

25 - Day to Day functions

26 - Nested Functions

27 - Text Functions

28 - Date and Time Functions

29 - Lookup and Reference Functions

30 - Protecting and Sharing Workbooks

31 - Evaluate formula

5 - Dashing Hero Advanced Excel Topics

32 - Subtotals and Outlines

33 - Using PivotTables

34 - PivotCharts

35 - PivotTable Excel Data Model

36 - Data Validation

37 - Data Cleaning Techniques

38 - Sorting with Multiple Criteria

39 - Using Filters and Slicers in PivotTables

40 - Advanced Charting

41 - LAMBDA Function

42 - The magic LET function

43 - Sparklines

44 - Data Analysis Tools

45 - Advanced Conditional Formatting

46 - Dynamic Arrays and New Functions

47 - Dynamic Arrays and New Functions

6 - Veteran Hero Expert Excel Topics

48 - Using Named Ranges

49 - Data types

50 - Using Form Controls

51 - Importing Data

52 - Using the Watch Window

53 - Linking and Embedding

54 - Automate Office Scripts

55 - Statistical Functions

56 - Creating and Using Data Models

57 - Using Power Query for Data Transformation

58 - Power Pivot Basics

59 - Creating PivotTable Calculated Fields

60 - Creating Heat Maps and Data Bars

61 - Array Formulas

62 - Consolidating Data

63 - Creating Dashboards

64 - Automating Tasks with Macros

7 - Tools of the trade Excel Tips and Tricks

65 - Excel Integration with Other Apps

66 - Keyboard Shortcuts

67 - Selection Pane

68 - Troubleshooting Common Issues

69 - Excel AddIns

70 - Check accessibility

8 - Course WrapUp

71 - Review and Practice

139,000 تومان

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

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

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

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