Zero to Hero in Microsoft Excel: Complete Excel guide 2023

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

A Beginner's Guide to Microsoft Excel - Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Tricks

01 - Introduction

001 Introduction

02 - Excel Basics

001 Getting started with Excel

002 Course Resources.html

002 Data-1.zip

002 Exercise-1.zip

002 Presentations-1.zip

003 This is a milestone!

004 Worksheet Basics

005 Entering values and Formulas

006 Data Formats

007 Data Handling Basics - Cut, Copy and Paste

008 Saving and Printing in Excel

03 - Essential Excel functions

001 Basic Formula Operations

002 Mathematical Functions - Part 1

002 Mathematical-Functions.xlsx

003 Mathematical Functions - Part 2

003 Mathematical-Functions.xlsx

004 Difference between RANK, RANK.AVG and RANK.EQ.html

005 Exercise 1 Mathematical Functions.html

005 Session1-Exercise.xlsx

005 Session1-Solution.xlsx

006 Textual Functions - Part 1

006 Textual-Functions.xlsx

007 Textual Functions - Part 2

007 Textual-Functions.xlsx

008 Exercise 2 Textual Functions.html

008 Session2-Exercise.xlsx

008 Session2-Solution.xlsx

009 Logical Functions

009 Logical-Functions.xlsx

010 Exercise 3 Logical Functions.html

010 Session3-Exercise.xlsx

010 Session3-Solution.xlsx

011 Date-Time Functions

011 Date-Time-Functions.xlsx

012 Exercise 4 Date-Time Functions.html

012 Session4-Exercise.xlsx

012 Session4-Solution.xlsx

013 Lookup Functions ( V Lookup, Hlookup, Index-Match )

013 Lookup-Functions.xlsx

014 Exercise 5 Lookup Functions.html

014 Session5-Exercise.xlsx

014 Session5-Solution.xlsx

04 - New! XLookup - only for Excel 2021 and Office 365

001 Lecture-XLookup-Solved.xlsx

001 Lecture-XLookup-unsolved.xlsx

001 XLookup as a replacement of Vlookup

002 Handling #NA and Approximates match in Xlookup

003 Wildcard matching in XLookup

004 Search modes in XLookup

05 - Data Tools

001 Data-Tools.xlsx

001 Sorting, Filtering and Data Validation

002 Data-Tools.xlsx

002 Text-to-columns and remove duplicates

003 Advanced Filter option

003 Advanced-Filters.xlsx

003 Advanced-Filters-solved.xlsx

004 Exercise 6 Data Tools.html

004 Session6-Exercise.xlsx

004 Session6-Solution.xlsx

06 - Formatting data and tables

001 Formatting data and tables

001 Formatting-data-and-tables.xlsx

002 Exercise 7 Formatting.html

002 Session7-Exercise.xlsx

002 Session7-Solution.xlsx

07 - Pivot Tables

001 Pivot Tables

001 Pivot-Tables.xlsx

002 Exercise 8 Pivot tables.html

002 Session8-Exercise.xlsx

002 Session8-Solution.xlsx

08 - Excel Charts

001 Excel Charts - Categories of messages that can be conveyed

001 Excel-Charts-Categories-of-messages-that-can-be-conveyed.pdf

002 Elements of charts

002 Elements-of-charts.pdf

003 The Easy way of creating charts

004 Bar and column charts

004 Bar-and-column-charts.xlsx

005 Formatting charts

005 Formatting-charts.xlsx

006 Line Charts

006 Line-Charts.xlsx

007 Area Charts

007 Area-Charts.xlsx

008 Pie and Doughnut Charts

008 Pie-and-Doughnut-Charts.xlsx

009 Why we should avoid Pie charts

009 Why-we-should-avoid-Pie-charts.pdf

010 Scatter plot or XY chart

010 Scatter-plot-or-XY-chart.xlsx

011 Frequency Distribution and Histograms

011 Frequency-Distribution-and-Histograms.pdf

011 Frequency-Distribution-and-Histograms.xlsx

012 Waterfall Charts

012 Waterfall-Charts.xlsx

012 Waterfall-Chart-1.xlsx

013 Hierarchy Charts Sunburst and Treemap

014 Combination charts

015 Sparklines

015 Sparklines.xlsx

016 Exercise 9 Charts.html

016 Session9-Exercise.xlsx

016 Session9-Solution.xlsx

09 - Pivot Charts

001 Pivot Charts

001 Pivot-Charts.xlsx

10 - NEW! Maps Chart - only for Excel 2019 and above

001 Lecture-Maps-Solved.xlsx

001 Lecture-Maps-Unsolved.xlsx

001 Maps Chart

11 - Special purpose charts

001 Stock charts

002 Radar charts

003 Surface charts

004 Heatmaps

12 - Named Ranges

001 Named Ranges

001 Named-Ranges.xlsx

002 Indirect Function

002 Indirect-Function.xlsx

13 - Excel Shortcuts

001 Shortcuts

001 Shortcuts.xlsx

002 Exercise 10 Shortcuts.html

002 Session10-Exercise.xlsx

002 Session10-Solution.xlsx

14 - Using ChatGPT with Excel

001 Use ChatGPT for Excel problems

002 Integrating ChatGPT with Excel using API key

002 VBA-Code-for-Integration.txt

external-links.txt

15 - Macros

001 Macros

001 macros.zip

002 Exercise 11 Macros.html

002 Session12-Exercise.xlsx

002 session12-solution.zip

16 - NEW! Importing data from PDF and Websites

001 Apple-quarterly-balance-sheet.pdf

001 Apple-quarterly-balance-sheet-1.pdf

001 Employee-data.pdf

001 Importing tables from PDF - Excel 2021 and office 365

001 PDF-import-solved.xlsx

001 employee-ctc-pdf-load-solved.xlsx

002 Importing data from Website - Excel 2019 and above

17 - Advanced Excel

001 Advanced Excel Analytics in Excel

001 Advanced-Excel-Analytics-in-Excel.xlsx

002 Solving a transportation problem using Excel

003 Income Tax calculation - Slabs based tax.html

18 - Creative Infographics

001 Infographic Example 1

002 Infographic Example 2

19 - Congratulations & about your certificate

001 The final milestone!

002 Bonus Lecture.html

139,000 تومان

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

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

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

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