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