Microsoft Excel 2023 – From Beginner to Expert in 6 Hours

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

Excel Made Easy - From Beginner to Expert - Microsoft Certified Master Instructor - MOS Expert - Master Microsoft Excel

01 - Course information

001 Welcome

002 Course files.zip

003 Getting your certificate

02 - Quick start with MS Excel

001 Introduction

002 Microsoft Excel

002 Microsoft-Excel-From-Beginner-to-Expert-in-6-Hours-Course-Outline.pdf

003 07-relative-references-point-and-click.xlsx

003 Relative references

004 08-absolute-references.xlsx

004 Absolute references

005 09-gradebook.xlsx

005 Calculating a grade

006 10-chart-creation.xlsx

006 Creating charts

007 11-functions.xlsx

007 Functions

008 12-fcdb.xlsx

008 FCDB

external-links.txt

03 - Hands-on exercises #1

001 14-hands-on-exercises.xlsx

001 Hands-on exercises

04 - MS Excel fundamentals

001 15-16-finding-your-way-around-excel.xlsx

001 Introduction

002 15-16-finding-your-way-around-excel.xlsx

002 A tour of Excel

003 17-mouse-pointer-awareness.xlsx

003 Mouse pointer awareness

004 18-right-click-paste-transpose.xlsx

004 The power of right clicking

005 19-books-sheets.xlsx

005 Autosave & autorecover

006 MS Excel files

05 - Hands-on exercises #2

001 22-hands-on.xlsx

001 Hands-on exercises

06 - MS Excel functions

001 23-func-average-max-min.xlsx

001 Max, min, & documentation

002 24-func-rand.xlsx

002 Rand & randbetween

003 25-func-concat-textjoin.xlsx

003 Concat & textjoin

004 26-func-concat-textjoin.xlsx

004 Documentation

07 - Hands-on exercises #3

001 28-hands-on-exercises.xlsx

001 Hands-on exercises

08 - Popular Excel functions

001 29-introduction.xlsx

001 Introduction

002 30-top-10.xlsx

002 Top 10 functions

003 31-xlookup.xlsx

003 Xlookup, vlookup, & hlookup

004 32-pmt-function.xlsx

004 PMT payment function

005 33-pmt-ipmt-functions.xlsx

005 PMT IPMT loan amortization

006 34-fv-function.xlsx

006 FV future value function

007 35-fv-retirement-amortization.xlsx

007 FV retirement amortization

008 36-if-iferror-functions.xlsx

008 IF IFERROR dynamic amortization

009 37-conditional-formatting.xlsx

009 Conditional formatting

09 - Hands-on exercises #4

001 39-ice-cream-choice.xlsx

001 Hands-on exercises

10 - Formatting for impact

001 40-fundamentals-of-formatting.xlsx

001 Fundamentals of formatting

002 41-formatting-tables-quickly.xlsx

002 Formatting tables of data quickly

003 42-font-is-feeling.xlsx

003 Font is feeling - font formatting

004 43-exploring-home-ribbon.xlsx

004 Exploring the home ribbon

005 44-zebra-stripe-rows.xlsx

005 Zebra stripe rows

11 - Hands-on exercises #5

001 46-hands-on-exercise.xlsx

001 Hands-on exercises

12 - Creating charts & graphs

001 47-visually-representing-data.xlsx

001 Content & form

002 48-chart-creation-II.xlsx

002 Creating charts

003 49-formatting-charts.xlsx

003 Formatting charts

004 50-trendlines.xlsx

004 Chart trendlines

005 51-combo-chart.xlsx

005 Combo charts

006 52-sparklines.xlsx

006 Sparklines

external-links.txt

13 - Hands-on exercises #6

001 54-exercises.xlsx

001 Hands-on exercises

14 - Working with data

001 55-gapminder-road-data.xlsx

001 Gapminder data

002 56-scraping-data.xlsx

002 Scraping web data

003 57-outdoor-gear-data.xlsx

003 Outdoor gear coop

004 58-name-generator-data.xlsx

004 Name generator

external-links.txt

15 - Massaging data

001 59-sorting-data.xlsx

001 Sorting data

002 60-freeze-panes.xlsx

002 Freeze panes

003 61-remove-duplicates.xlsx

003 Removing duplicates

004 62-filter-data.xlsx

004 Filtering data

16 - Hands-on exercises #7

001 64-remove-duplicates.xlsx

001 Hands-on exercises

17 - Pivot tables in Excel

001 65-pivot-tables.xlsx

001 Introduction

002 66-creating-pivot-tables.xlsx

002 Creating pivot tables

003 67-pivot-table-slicers.xlsx

003 Slicers - filtering pivot tables

004 68-pivot-charts.xlsx

004 Pivot charts

18 - Hands-on exercises #8

001 70-pivot-exercises.xlsx

001 Hands-on exercises

19 - Odds & ends

001 71-printing-worksheets.xlsx

001 Printing your worksheet

002 72-protect.xlsx

002 Protecting (locking) workbooks, sheets, and cells

003 73-ole.docx

003 73-ole.xlsx

003 Object linking & embedding (OLE)

20 - Creating macros

001 74-macros.xlsx

001 74-macros.zip

001 Introduction to macros

21 - Hands-on exercises #9

001 76-macros.xlsx

001 76-macros.zip

001 Hands-on exercises

22 - Congratulations

001 Great work!

002 Bonus lecture

139,000 تومان

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

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

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

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