Microsoft Excel: Beginners to Advanced (All-In-One)

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

Go From No Knowledge to Using Formulas to Make Your Office Work Quicker and Easier

1 - Introduction

1 - Introduction Course Content

2 - Excel-Beginners-to-Advanced-Specialized-Study-Plan.docx

2 - NEW Specialized Study Plan.html

2 - Navigating Excel

3 - Introduction to Navigating Excel

4 - Adding and Scrolling Worksheets

5 - Worksheet vs Workbook

6 - Naming and Coloring Tabs

7 - Moving and Copying Worksheets

8 - Zooming and Page View Options

9 - Cells and Gridlines

10 - Navigating the Ribbon

11 - Save vs Save As

3 - Beginners Knowledge

12 - Adjusting Column Sizes and Wrapping Text

13 - Calculations Using the SUM Function

14 - Calculations Adding and Multiplying

15 - Highlighting Cells Merging Cells and Changing Row Height

16 - Borders Frames Aligning Text and Adding Color

17 - Adding Columns and Rows and Sorting I Alphabetizing

18 - Formulas Finding Averages Adding Hyperlinks

19 - Adding Notes and Comments Duplicating and Moving Content

20 - Formulas Subtracting Dividing Adding Introducing Tables and Charts

21 - Page Layout Headers Footers and Page Numbers

22 - Formatting to Print on One Page Saving As a PDF

23 - DOWNLOAD Assignments List I Optional.html

23 - Udemy-eTeach-uExcel-Assignments-List-1-BICS.xlsx

24 - DOWNLOAD Assignment Workbook I Optional.html

24 - Udemy-Excel-Course-Assignment-Workbook-1-BICS.xlsx

4 - Next Level Intermediate Office Tips and Knowledge

25 - Introduction to Section

26 - Creating a Dropdown List

27 - Date Format Options and Calculating Age

28 - Working With Payment Balances

29 - Adding Checkmarks and Checkboxes Numbering Sequentially

30 - Finding and Removing Duplicates

31 - Preventing Duplicates

32 - Freezing Panes

33 - Sorting II Numerical Data

34 - Introduction to Pivot Tables

35 - Protecting and Unprotecting

36 - DOWNLOAD Assignments List II Optional.html

36 - Udemy-eTeach-uExcel-Assignments-List-2-CC.xlsx

37 - DOWNLOAD Assignments Workbook II Optional.html

37 - Udemy-eTeach-uExcel-Assignment-Workbook-2-CC.xlsx

5 - Advanced Functions and Formulas

38 - Functions vs Formulas

39 - Review of Basic Functions and Formulas

40 - IF

41 - COUNT

42 - COUNTIF

43 - COUNTIFS

44 - COUNTA

45 - SUMIF

46 - SUMIFS

47 - DATE & DATEIF

48 - SUMPRODUCT

49 - ROUND

50 - Surprise Content

51 - CONCATENATE

52 - Extra Content Separating Text From 1 to 2 Columns

53 - TRANSPOSE

54 - LOOKUP

55 - XLOOKUP Primary Features of XLOOKUP

56 - XLOOKUP Previous Functions and Syntax

57 - XLOOKUP Example of Use

58 - XLOOKUP Review of Guidelines on General Use of XLOOKUP

59 - XLOOKUP If Not Found Argument

60 - XLOOKUP Extra Pointer

6 - Additional Quick TipsShort Tutorials Videos Only

61 - Add Times to a Meeting or Event Schedule QUICKLY

62 - Add Days and Months QUICKLY Without Typing All Individually

63 - QUICK Count OptionsNumber Rows of Data

7 - DOWNLOAD EXTRA 50 Shortcuts Guide

64 - 50-Excel-Shortcuts-Guide-by-Cheriamor.pdf

64 - DOWNLOAD 50 Excel Shortcuts Guide.html

45,900 تومان

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

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

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

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