[Udemy] Microsoft Excel - Excel from Beginner to Advanced 2022 (Warrick Klimaytys)

​

Чему вы научитесь
- Go from complete beginner to proficient Excel user within 8 hours of content.
- Learn to create workbooks and spreadsheets everyone will be jealous of.
- Acquire critical Excel knowledge within the first 2 hours of tutorials.
- Learn all about: tables, charts, formatting, formulas and functions, macros, pivot tables/charts, and much more!

Требования
- No experience needed. You'll learn everything you need to know right from the beginning.
- This course is compatible with any version of Excel. Including Excel in Microsoft Office 365.
- No need to start from scratch. Almost all tutorials have a premade spreadsheet/workbook for you to download and use.
- Take your time! Fast forward, rewind, and pause whenever you like.

Для кого этот курс:
- Anyone interested in becoming a proficient Excel user.
- Anyone who would like to integrate the power of Excel into their personal or professional life.
- Anyone who wants to add a truly valuable (and timeless) skill to their current skill set.
- Anyone interested in becoming the coolest Excel ninja ever!

Описание
Did you know…
Over 750 million people have Excel on their computers, but most don't know how to use it!
This might be because Excel can come across as being a little awkward with first-time users.
Well, within this course, 'Microsoft Excel - Excel from Beginner to Advanced 2022', I'd like to dispel any awkwardness you may encounter, while using Excel, and quickly get you to the point where using Excel is as natural as rolling out of bed in the morning.

How do I do this?
- I explain concepts within Excel simply and clearly.
- I break down Excel's various tools, features, and functionality into the finest of detail, so you can gain a much deeper understanding of the program.
- I re-visit areas already taught every now and again, to reinforce what you would have already learned.
- I created this course to suit any level of the learner.

I understand that learning Excel can feel like a huge undertaking, as it was for me when I first started using the program over 10 years ago. And so, you might ask yourself, “Do I have to learn everything in Excel before I can use it effectively?”.
Well, the answer is, NO!
You don’t have to learn every aspect of Excel before you can consider yourself qualified. The truth is, there is a certain level of proficiency that once reached, will make you considerably more qualified than the average Excel user.
To help you achieve this level of proficiency, I've created a very useful Excel workbook called, "main-workbook-section2" to accompany you throughout the first part of the course (After the basic introduction videos/material). In this workbook, I cover most (if not all) of the most important features and functionality you must know to get up to speed with the program as fast as possible. Then as you progress further into the course there are various other pre-prepared spreadsheets and workbooks you can download and use to follow along with my instructions.

What can you expect after enrolment?
We’ll start with a few introductory tutorials to get you set up for the course along with a basic introduction to Excel itself. Then, it’s onto section two, which I hope you’ll complete, and of course, ENJOY! Then, once this part of the course is completed, we'll start diving into other areas of Excel to really start sharpening the skills you would have already learned, along with learning some new things as well.

What do you get when you enroll:
- A 30-day money-back guarantee, so you can enroll risk-free.
- A lifetime access guarantee so you can re-visit the course whenever you want.
- Access to the Q and A section so you can get help at any point during the course.
- A certificate of completion to add to your resume/CV.

So, whatever your reason for wanting to learn Excel, enrol in 'Microsoft Excel - Excel from Beginner to Advanced 2022' today! And see where my course will take you

I’ll see you in the first lesson.

Warrick Klimaytys.

Спойлер: Содержание складчины (файлы и папки)

01 Microsoft Excel 101 Course Introduction
001 Ask Questions.mp4 [39m 858k 319]
001 Ask Questions_en.srt [2k 731]
002 Course Exercise Files.mp4 [12m 722k 722]
002 Course Exercise Files_en.srt [2k 331]
002 MonthlyBudget-01.xlsx [14k 623]
002 MonthlyBudget-AutoFill-01.xlsx [14k 152]
002 MonthlyBudget-AutoSUM-01.xlsx [14k 454]
002 MonthlyBudget-AverageFunction-01.xlsx [14k 439]
002 MonthlyBudget-BasicFormulas-01.xlsx [14k 8]
002 MonthlyBudget-Count-01.xlsx [14k 649]
002 MonthlyBudget-Headers-01.xlsx [14k 5]
002 MonthlyBudget-MIN-MAXFunctions-01.xlsx [14k 367]
002 MonthlyBudget-ReferenceTypes-01.xlsx [14k 3]
002 MonthlyBudget-SUMFunction-01.xlsx [14k 98]
002 MonthlyBudget-Template-01.xlsx [14k 880]
003 Certificate of Completion.mp4 [11m 307k 543]
003 Certificate of Completion_en.srt [1k 912]

02 Microsoft Excel Fundamentals
001 Launching Excel.mp4 [14m 234k 213]
001 Launching Excel_en.srt [2k 870]
002 Microsoft Excel Startup Screen.mp4 [57m 339k 704]
002 Microsoft Excel Startup Screen_en.srt [5k 118]
003 Introduction to the Excel Interface.mp4 [50m 225k 188]
003 Introduction to the Excel Interface_en.srt [11k 838]
004 Customizing the Excel Quick Access Toolbar.mp4 [23m 617k 587]
004 Customizing the Excel Quick Access Toolbar_en.srt [4k 673]
005 More on the Excel Interface.mp4 [54m 52k 605]
005 More on the Excel Interface_en.srt [5k 920]
006 Understanding the Structure of an Excel Workbook.mp4 [21m 683k 81]
006 Understanding the Structure of an Excel Workbook_en.srt [6k 476]
007 Saving an Excel Document.mp4 [71m 169k 411]
007 Saving an Excel Document_en.srt [6k 466]
008 Opening an Existing Excel Document.mp4 [40m 761k 444]
008 Opening an Existing Excel Document_en.srt [2k 554]
009 Common Excel Shortcut Keys.mp4 [19m 268k 479]
009 Common Excel Shortcut Keys_en.srt [4k 71]
009 CommonExcelWindowsShortcuts-01.pdf [144k 896]

03 Entering and Editing Text and Formulas
001 Entering Text to Create Spreadsheet Titles.mp4 [62m 562k 400]
001 Entering Text to Create Spreadsheet Titles_en.srt [13k 907]
002 Working with Numeric Data in Excel.mp4 [65m 263k 464]
002 Working with Numeric Data in Excel_en.srt [13k 225]
003 Entering Date Values in Excel.mp4 [66m 107k 853]
003 Entering Date Values in Excel_en.srt [14k 445]
004 Working with Cell References.mp4 [100m 136k 756]
004 Working with Cell References_en.srt [9k 193]
005 Creating Basic Formulas in Excel.mp4 [45m 685k 660]
005 Creating Basic Formulas in Excel_en.srt [13k 799]
006 Relative Versus Absolute Cell References in Formulas.mp4 [93m 313k 175]
006 Relative Versus Absolute Cell References in Formulas_en.srt [17k 996]
007 OrderOfOperation-01.xlsx [9k 472]
007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4 [54m 482k 761]
007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)_en.srt [16k 89]

04 Working with Basic Excel Functions
001 EXCEL-FUNCTIONS.pptx [89k 208]
001 The structure of an Excel Function.mp4 [37m 287k 576]
001 The structure of an Excel Function_en.srt [16k 285]
002 Working with the SUM() Function.mp4 [51m 459k 825]
002 Working with the SUM() Function_en.srt [11k 636]
003 Working with the MIN() and MAX() Functions.mp4 [34m 95k 603]
003 Working with the MIN() and MAX() Functions_en.srt [10k 346]
004 Working with the AVERAGE() Function.mp4 [15m 629k 230]
004 Working with the AVERAGE() Function_en.srt [4k 419]
005 Working with the COUNT() Function.mp4 [15m 750k 305]
005 Working with the COUNT() Function_en.srt [4k 527]
006 Adjacent Cells Error in Excel Calculations.mp4 [27m 378k 462]
006 Adjacent Cells Error in Excel Calculations_en.srt [6k 560]
007 Using the AutoSum Command.mp4 [50m 821k 179]
007 Using the AutoSum Command_en.srt [11k 237]
008 Excel's AutoSum Shortcut Key.mp4 [16m 747k 636]
008 Excel's AutoSum Shortcut Key_en.srt [3k 733]
009 Using the AutoFill Command to Copy Formulas.mp4 [33m 81k 721]
009 Using the AutoFill Command to Copy Formulas_en.srt [7k 172]

05 Modifying an Excel Worksheet
001 Moving and Copying Data in an Excel Worksheet.mp4 [62m 662k 1]
001 Moving and Copying Data in an Excel Worksheet_en.srt [10k 14]
002 Inserting and Deleting Rows and Columns.mp4 [40m 107k 754]
002 Inserting and Deleting Rows and Columns_en.srt [11k 581]
003 Changing the Width and Height of Cells.mp4 [29m 21k 862]
003 Changing the Width and Height of Cells_en.srt [8k 374]
004 Hiding and Unhiding Excel Rows and Columns.mp4 [39m 65k 151]
004 Hiding and Unhiding Excel Rows and Columns_en.srt [8k 620]
005 Renaming an Excel Worksheet.mp4 [21m 464k 614]
005 Renaming an Excel Worksheet_en.srt [4k 670]
006 Deleting an Excel Worksheet.mp4 [43m 877k 750]
006 Deleting an Excel Worksheet_en.srt [7k 415]
007 Moving and Copying an Excel Worksheet.mp4 [40m 49k 338]
007 Moving and Copying an Excel Worksheet_en.srt [8k 441]

06 Formatting Data in an Excel Worksheet
001 Working with Font Formatting Commands.mp4 [61m 879k 109]
001 Working with Font Formatting Commands_en.srt [11k 993]
002 Changing the Background Color of a Cell.mp4 [26m 249k 558]
002 Changing the Background Color of a Cell_en.srt [5k 159]
003 Adding Borders to Cells.mp4 [20m 235k 321]
003 Adding Borders to Cells_en.srt [3k 882]
004 Excel Cell Borders Continued.mp4 [27m 137k 244]
004 Excel Cell Borders Continued_en.srt [5k 67]
005 Formatting Data as Currency Values.mp4 [37m 896k 89]
005 Formatting Data as Currency Values_en.srt [6k 859]
006 Formatting Percentages.mp4 [23m 965k 381]
006 Formatting Percentages_en.srt [4k 489]
007 Using Excel's Format Painter.mp4 [36m 578k 971]
007 Using Excel's Format Painter_en.srt [6k 700]
008 Creating Styles to Format Data.mp4 [165m 975k 897]
008 Creating Styles to Format Data_en.srt [12k 502]
009 Merging and Centering Cells.mp4 [29m 486k 740]
009 Merging and Centering Cells_en.srt [5k 203]
010 Using Conditional Formatting.mp4 [39m 636k 829]
010 Using Conditional Formatting_en.srt [7k 150]
011 Editing Excel Conditional Formatting.mp4 [22m 179k 538]
011 Editing Excel Conditional Formatting_en.srt [4k 188]

07 Inserting Images and Shapes into an Excel Worksheet
001 Inserting Images.mp4 [91m 341k 776]
001 Inserting Images_en.srt [6k 665]
002 Inserting Excel Shapes.mp4 [22m 533k 274]
002 Inserting Excel Shapes_en.srt [4k 633]
003 Formatting Excel Shapes.mp4 [32m 755k 127]
003 Formatting Excel Shapes_en.srt [6k 750]
004 Working with Excel SmartArt.mp4 [99m 920k 770]
004 Working with Excel SmartArt_en.srt [15k 399]

08 Creating Basic Charts in Excel
001 Creating an Excel Column Chart.mp4 [31m 612k 418]
001 Creating an Excel Column Chart_en.srt [5k 803]
002 Working with the Excel Chart Ribbon.mp4 [25m 271k 116]
002 Working with the Excel Chart Ribbon_en.srt [4k 437]
003 Adding and Modifying Data on an Excel Chart.mp4 [49m 758k 977]
003 Adding and Modifying Data on an Excel Chart_en.srt [8k 883]
004 Formatting an Excel Chart.mp4 [60m 813k 395]
004 Formatting an Excel Chart_en.srt [11k 413]
005 Moving a Chart to another Worksheet.mp4 [33m 548k 993]
005 Moving a Chart to another Worksheet_en.srt [5k 577]
006 Working with Excel Pie Charts.mp4 [66m 125k 869]
006 Working with Excel Pie Charts_en.srt [11k 375]

09 Printing an Excel Worksheet
001 Viewing your Document in Print Preview.mp4 [24m 248k 472]
001 Viewing your Document in Print Preview_en.srt [6k 530]
002 Changing the Margins, Scaling and Orientation.mp4 [370m 534k 502]
002 Changing the Margins, Scaling and Orientation_en.srt [13k 225]
003 Excel Worksheet Margins.mp4 [27m 733k 739]
003 Excel Worksheet Margins_en.srt [4k 697]
004 Working with Page Layout View.mp4 [41m 228k 81]
004 Working with Page Layout View_en.srt [4k 953]
005 Adding Header and Footer Content.mp4 [133m 575k 232]
005 Adding Header and Footer Content_en.srt [9k 444]
006 Printing a Specific Range of Cells.mp4 [134m 657k 706]
006 Printing a Specific Range of Cells_en.srt [4k 984]

10 Working with Excel Templates
001 Intro to Excel Templates.mp4 [30m 275k 210]
001 Intro to Excel Templates_en.srt [4k 905]
002 Opening an Existing Template.mp4 [200m 13k 529]
002 Opening an Existing Template_en.srt [15k 320]
003 Creating a Custom Template.mp4 [77m 4k 85]
003 Creating a Custom Template_en.srt [10k 18]

11 Excel 101 - Practice What You've Learned (DOWNLOAD)
001 Excel 101 - Practice What You've Learned (DOWNLOAD).html [259]
001 Excel101ExtraPractice-01.xlsx [47k 423]

12 Congratulations! You've Built a Solid Microsoft Excel Foundation
001 Congratulations!.mp4 [47m 17k 65]
001 Congratulations!_en.srt [2k 804]

13 Microsoft Excel 102 Course Introduction
001 Excel 102 Course Exercise Files -- DOWNLOAD.mp4 [7m 297k 805]
001 Excel 102 Course Exercise Files -- DOWNLOAD_en.srt [1k 826]
001 Excel102Exercises.xlsx [126k 501]
001 NorthwindDB-IMPORT.zip [479k 25]
001 SalesData-TEXT-IMPORT.txt [26k 516]

14 Working with an Excel List
001 Understanding Excel List Structure.mp4 [52m 846k 640]
001 Understanding Excel List Structure_en.srt [8k 363]
002 Sorting a List Using Single Level Sort.mp4 [75m 286k 978]
002 Sorting a List Using Single Level Sort_en.srt [5k 440]
003 Sorting a List Using Multi-Level Sorts.mp4 [54m 326k 266]
003 Sorting a List Using Multi-Level Sorts_en.srt [5k 141]
004 Using Custom Sorts in an Excel List.mp4 [24m 998k 879]
004 Using Custom Sorts in an Excel List_en.srt [6k 512]
005 Filter an Excel List Using the AutoFilter Tool.mp4 [42m 371k 65]
005 Filter an Excel List Using the AutoFilter Tool_en.srt [7k 205]
006 Creating Subtotals in a List.mp4 [93m 928k 236]
006 Creating Subtotals in a List_en.srt [10k 168]
007 Format a List as a Table.mp4 [108m 432k 677]
007 Format a List as a Table_en.srt [11k 413]
008 Using Conditional Formatting to Find Duplicates.mp4 [57m 263k 193]
008 Using Conditional Formatting to Find Duplicates_en.srt [5k 400]
009 Removing Duplicates.mp4 [60m 377k 870]
009 Removing Duplicates_en.srt [5k 900]

15 Excel List Functions
001 Introduction to Excels Function DSUM().mp4 [51m 993k 790]
001 Introduction to Excels Function DSUM()_en.srt [8k 520]
002 Excel DSUM Function Single Criteria Continued.mp4 [44m 985k 499]
002 Excel DSUM Function Single Criteria Continued_en.srt [7k 185]
003 Excel DSUM Function with OR Criteria.mp4 [24m 87k 756]
003 Excel DSUM Function with OR Criteria_en.srt [3k 584]
004 Excel DSUM Function with AND Criteria.mp4 [51m 809k 920]
004 Excel DSUM Function with AND Criteria_en.srt [7k 804]
005 Excel Function DAVERAGE().mp4 [45m 916k 893]
005 Excel Function DAVERAGE()_en.srt [7k 303]
006 Excel Function DCOUNT().mp4 [60m 671k 365]
006 Excel Function DCOUNT()_en.srt [9k 644]
007 Excel Function SUBTOTAL().mp4 [71m 463k 157]
007 Excel Function SUBTOTAL()_en.srt [11k 804]

16 Excel Data Validation
001 Understanding the Need for Excel Data Validation.mp4 [46m 703k 127]
001 Understanding the Need for Excel Data Validation_en.srt [7k 673]
002 Creating an Excel Data Validation List.mp4 [50m 460k 321]
002 Creating an Excel Data Validation List_en.srt [8k 477]
003 Excel Decimal Data Validation.mp4 [39m 824k 564]
003 Excel Decimal Data Validation_en.srt [6k 616]
004 Adding a Custom Excel Data Validation Error.mp4 [45m 208k 398]
004 Adding a Custom Excel Data Validation Error_en.srt [8k 50]
005 Dynamic Formulas by Using Excel Data Validation Techniques.mp4 [43m 750k 283]
005 Dynamic Formulas by Using Excel Data Validation Techniques_en.srt [6k 841]

17 Importing and Exporting Data
001 Importing Data Into Microsoft Excel.mp4 [10m 422k 757]
001 Importing Data Into Microsoft Excel_en.srt [2k 652]
002 Importing Data from Text Files.mp4 [35m 273k 106]
002 Importing Data from Text Files_en.srt [8k 101]
003 Importing Data from Microsoft Access.mp4 [46m 175k 312]
003 Importing Data from Microsoft Access_en.srt [6k 59]
004 NEW VERSION -- Import Data From Text Files into Excel.mp4 [248m 140k 491]
004 NEW VERSION -- Import Data From Text Files into Excel_en.srt [12k 240]
005 NEW VERSION -- Import Data From a Database into Excel.mp4 [128m 541k 980]
005 NEW VERSION -- Import Data From a Database into Excel_en.srt [9k 373]
006 Microsoft Excel Legacy Import Options for New Excel Versions.mp4 [40m 468k 594]
006 Microsoft Excel Legacy Import Options for New Excel Versions_en.srt [2k 894]
007 Exporting Data to a Text File.mp4 [125m 393k 105]
007 Exporting Data to a Text File_en.srt [9k 868]

18 Excel PivotTables
001 Understanding Excel PivotTables.mp4 [47m 372k 678]
001 Understanding Excel PivotTables_en.srt [6k 17]
002 Creating an Excel PivotTable.mp4 [150m 815k 765]
002 Creating an Excel PivotTable_en.srt [10k 816]
003 Modifying Excel PivotTable Calculations.mp4 [134m 754k 345]
003 Modifying Excel PivotTable Calculations_en.srt [9k 24]
004 Grouping PivotTable Data.mp4 [56m 492k 193]
004 Grouping PivotTable Data_en.srt [11k 921]
005 Formatting PivotTable Data.mp4 [32m 741k 146]
005 Formatting PivotTable Data_en.srt [6k 488]
006 Modifying PivotTable Calculations.mp4 [58m 451k 367]
006 Modifying PivotTable Calculations_en.srt [13k 917]
007 Drilling Down into PivotTable Data.mp4 [139m 358k 267]
007 Drilling Down into PivotTable Data_en.srt [6k 571]
008 Creating PivotCharts.mp4 [85m 248k 249]
008 Creating PivotCharts_en.srt [6k 67]
009 Filtering PivotTable Data.mp4 [21m 311k 130]
009 Filtering PivotTable Data_en.srt [4k 597]
010 Filtering with the Slicer Tool.mp4 [25m 709k 104]
010 Filtering with the Slicer Tool_en.srt [4k 615]

19 Working with Excel's PowerPivot Tools
001 Introduction to Excel Power Pivot.mp4 [26m 967k 39]
001 Introduction to Excel Power Pivot_en.srt [6k 854]
002 Why PowerPivot.mp4 [340m 262k 788]
002 Why PowerPivot_en.srt [11k 844]
003 Activating the Excel PowerPivot AddIn.mp4 [40m 941k 477]
003 Activating the Excel PowerPivot AddIn_en.srt [5k 170]
004 Creating Data Models with PowerPivot.mp4 [166m 240k 398]
004 Creating Data Models with PowerPivot_en.srt [6k 832]
005 Excel Power Pivot Data Model Relationships.mp4 [112m 219k 943]
005 Excel Power Pivot Data Model Relationships_en.srt [7k 223]
006 Creating PivotTables based on Data Models.mp4 [47m 809k 756]
006 Creating PivotTables based on Data Models_en.srt [9k 419]
007 Excel Power Pivot KPIs.mp4 [206m 121k 111]
007 Excel Power Pivot KPIs_en.srt [16k 370]

20 Working with Large Sets of Excel Data
001 Using the Freeze Panes Tool.mp4 [53m 35k 356]
001 Using the Freeze Panes Tool_en.srt [5k 507]
002 Grouping Data (Columns andor Rows).mp4 [65m 215k 490]
002 Grouping Data (Columns andor Rows)_en.srt [5k 916]
003 Print Options for Large Sets of Data.mp4 [62m 50k 703]
003 Print Options for Large Sets of Data_en.srt [11k 167]
004 Linking Worksheets (3D Formulas).mp4 [23m 927k 156]
004 Linking Worksheets (3D Formulas)_en.srt [5k 414]
005 Consolidating Data from Multiple Worksheets.mp4 [34m 404k 713]
005 Consolidating Data from Multiple Worksheets_en.srt [7k 644]

21 Excel 102 Additional Practice Exercises
001 COMPLETED-Excel102ExtraPractice-01.xlsx [253k 762]
001 Excel 102 - Practice What You've Learned (DOWNLOAD).html [259]
001 Excel102ExtraPractice-01.xlsx [240k 112]

22 Congratulations! You're an Intermediate Excel User
001 Congratulations!.mp4 [37m 787k 829]
001 Congratulations!_en.srt [2k 317]

23 Microsoft Excel 103 Course Introduction
001 Excel 103 Course Exercise Files -- DOWNLOAD.mp4 [11m 603k 726]
001 Excel 103 Course Exercise Files -- DOWNLOAD_en.srt [2k 81]
001 Excel103-AdvancedExercises.xlsx [65k 112]

24 Working with Excel's Conditional Functions
001 Working with Excel Name Ranges.mp4 [25m 259k 939]
001 Working with Excel Name Ranges_en.srt [7k 249]
002 Advantages and Disadvantages of Excel Name Ranges.mp4 [43m 569k 774]
002 Advantages and Disadvantages of Excel Name Ranges_en.srt [8k 295]
003 Editing an Excel Name Range.mp4 [14m 839k 895]
003 Editing an Excel Name Range_en.srt [4k 195]
004 Using Excel's IF() Function.mp4 [30m 568k 3]
004 Using Excel's IF() Function_en.srt [8k 157]
005 Excel's IF() Function with a Name Range.mp4 [31m 520k 41]
005 Excel's IF() Function with a Name Range_en.srt [8k 361]
006 Nesting Functions with Excel.mp4 [53m 817k 42]
006 Nesting Functions with Excel_en.srt [12k 136]
007 Nesting Excels AND() Function within the IF() Function.mp4 [27m 432k 831]
007 Nesting Excels AND() Function within the IF() Function_en.srt [6k 151]
008 Using Excel's COUNTIF() Function.mp4 [14m 579k 728]
008 Using Excel's COUNTIF() Function_en.srt [3k 717]
009 Using Excel's SUMIF() Function.mp4 [128m 743k 865]
009 Using Excel's SUMIF() Function_en.srt [9k 237]
010 Using Excel's IFERROR() Function.mp4 [96m 432k 178]
010 Using Excel's IFERROR() Function_en.srt [7k 820]

25 Working with Excel's Lookup Functions
001 Microsoft Excel VLOOKUP() Function.mp4 [171m 950k 93]
001 Microsoft Excel VLOOKUP() Function_en.srt [15k 870]
002 Microsoft Excel HLOOKUP() Function.mp4 [51m 851k 838]
002 Microsoft Excel HLOOKUP() Function_en.srt [8k 603]
003 Microsoft Excel INDEX() Function.mp4 [170m 815k 141]
003 Microsoft Excel INDEX() Function_en.srt [15k 243]
004 Microsoft Excel MATCH() Function.mp4 [153m 37k 562]
004 Microsoft Excel MATCH() Function_en.srt [7k 163]
005 Microsoft Excel INDEX() and MATCH() Function Combined.mp4 [122m 55k 810]
005 Microsoft Excel INDEX() and MATCH() Function Combined_en.srt [10k 726]
006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4 [154m 57k 555]
006 Microsoft Excel INDEX() and MATCH() Function Combined Continued_en.srt [14k 193]
007 Creating a Dynamic HLOOKUP() with the MATCH() Function.mp4 [69m 568k 632]
007 Creating a Dynamic HLOOKUP() with the MATCH() Function_en.srt [10k 691]

26 Working with Excel's Text Based Functions
001 Using Excel's LEFT(), RIGHT() and MID() Functions.mp4 [81m 829k 343]
001 Using Excel's LEFT(), RIGHT() and MID() Functions_en.srt [8k 885]
002 Using Excel's LEN() Function.mp4 [54m 695k 656]
002 Using Excel's LEN() Function_en.srt [8k 689]
003 Using Excel's SEARCH() Function.mp4 [74m 577k 214]
003 Using Excel's SEARCH() Function_en.srt [17k 576]
004 Using Excel's CONCATENATE() Function.mp4 [19m 562k 125]
004 Using Excel's CONCATENATE() Function_en.srt [4k 183]

27 Auditing an Excel Worksheet
001 Tracing Precedents in Excel Formulas.mp4 [28m 77k 194]
001 Tracing Precedents in Excel Formulas_en.srt [5k 714]
002 Tracing Dependents in Excel Formulas.mp4 [20m 118k 696]
002 Tracing Dependents in Excel Formulas_en.srt [3k 860]
003 Working with the Watch Window.mp4 [51m 777k 595]
003 Working with the Watch Window_en.srt [5k 788]
004 Showing Formulas.mp4 [18m 112k 210]
004 Showing Formulas_en.srt [4k 255]

28 Protecting Excel Worksheets and Workbooks
001 Protecting Specific Cells in a Worksheet.mp4 [56m 403k 839]
001 Protecting Specific Cells in a Worksheet_en.srt [11k 347]
002 Protecting the Structure of a Workbook.mp4 [22m 116k 719]
002 Protecting the Structure of a Workbook_en.srt [5k 621]
003 Adding a Workbook Password.mp4 [36m 537k 414]
003 Adding a Workbook Password_en.srt [4k 368]

29 Mastering Excel's What If Tools
001 Working with Excel's Goal Seek Tool.mp4 [44m 48k 256]
001 Working with Excel's Goal Seek Tool_en.srt [11k 246]
002 Working with Excel's Solver Tool.mp4 [187m 111k 193]
002 Working with Excel's Solver Tool_en.srt [17k 619]
003 Building Effective Data Tables in Excel.mp4 [37m 237k 86]
003 Building Effective Data Tables in Excel_en.srt [7k 924]
004 Creating Scenarios in Excel.mp4 [97m 317k 226]
004 Creating Scenarios in Excel_en.srt [11k 39]

30 Automating Repetitive Tasks in Excel with Macros
001 Understanding Excel Macros.mp4 [36m 723k 758]
001 Understanding Excel Macros_en.srt [5k 254]
002 Activating the Developer Tab in Excel.mp4 [24m 997k 513]
002 Activating the Developer Tab in Excel_en.srt [2k 138]
003 Creating a Macro with the Macro Recorder.mp4 [144m 433k 705]
003 Creating a Macro with the Macro Recorder_en.srt [11k 382]
004 Editing a Macro with VBA.mp4 [65m 635k 958]
004 Editing a Macro with VBA_en.srt [7k 697]
005 Creating Buttons to Run Macros.mp4 [71m 720k 206]
005 Creating Buttons to Run Macros_en.srt [4k 559]

31 Excel 103 Additional Practice Exercises
001 COMPLETED-Excel103ExtraPractice-01.xlsx [97k 540]
001 Excel 103 - Practice What You've Learned (DOWNLOAD).html [259]
001 Excel103ExtraPractice-01.xlsx [94k 922]

32 Congratulations!
001 Congratulations on Completing the Microsoft Excel 103.mp4 [40m 485k 247]
001 Congratulations on Completing the Microsoft Excel 103_en.srt [2k 339]

33 Microsoft Excel Macros and VBA Course Introduction
001 Welcome to the Course.mp4 [25m 632k 766]
001 Welcome to the Course_en.srt [8k 813]
002 Understanding the Why and How Behind Excel Macros.mp4 [22m 677k 613]
002 Understanding the Why and How Behind Excel Macros_en.srt [7k 936]
003 AutomateFormulas.xlsx [19k 344]
003 AutomateSumFunction.xlsx [20k 309]
003 CleaningUpData.xlsx [21k 258]
003 Course Exercise Files - Download these First!.html [387]
003 InsertingAndFormattingText.xlsx [17k 800]
003 QuarterlyReport.xlsm [27k 129]
003 QuarterlyReportForm-01.xlsm [30k 423]
003 SortingRecords.xlsm [22k 294]
003 SortingRecords.xlsx [16k 857]

34 Project #1 Using Excel's Macro Recorder Tool
001 Introduction to Project #1 Inserting and Formatting Text.mp4 [16m 363k 195]
001 Introduction to Project #1 Inserting and Formatting Text_en.srt [3k 0]
002 InsertingAndFormattingText.xlsx [17k 800]
002 Project #1 Start Recording!.mp4 [78m 815k 310]
002 Project #1 Start Recording!_en.srt [11k 707]
003 Running A Macro.mp4 [22m 139k 264]
003 Running A Macro_en.srt [3k 990]
004 Project #1 Running a Macro with a Button.mp4 [20m 592k 243]
004 Project #1 Running a Macro with a Button_en.srt [5k 618]
005 Project #1 Oops! I Need to Edit My Macro.mp4 [79m 955k 320]
005 Project #1 Oops! I Need to Edit My Macro_en.srt [6k 656]
006 Practical Uses of Excel Macros.mp4 [25m 891k 267]
006 Practical Uses of Excel Macros_en.srt [3k 239]

35 Excel VBA Concepts
001 Excel VBA Concepts.mp4 [19m 661k 207]
001 Excel VBA Concepts_en.srt [4k 857]
002 The Visual Basic Editor (VBE).mp4 [24m 753k 276]
002 The Visual Basic Editor (VBE)_en.srt [5k 334]
003 Excel VBA Modules.mp4 [9m 631k 164]
003 Excel VBA Modules_en.srt [2k 701]
004 Creating an Excel VBA Procedure.mp4 [40m 504k 208]
004 Creating an Excel VBA Procedure_en.srt [11k 378]
005 Adding Code to a VBA Procedure.mp4 [31m 711k 628]
005 Adding Code to a VBA Procedure_en.srt [5k 399]
006 Understanding Excel VBA Variables.mp4 [52m 30k 715]
006 Understanding Excel VBA Variables_en.srt [9k 215]
007 Building Logic with an IF Statement.mp4 [35m 637k 963]
007 Building Logic with an IF Statement_en.srt [8k 623]
008 Working with Excel VBA Loops to Repeat Blocks of Code.mp4 [53m 805k 277]
008 Working with Excel VBA Loops to Repeat Blocks of Code_en.srt [14k 598]

36 Project #2 Moving Beyond the Basics and into VBA
001 Introduction to Project #2 Interacting with the User.mp4 [23m 918k 670]
001 Introduction to Project #2 Interacting with the User_en.srt [4k 271]
002 Project #2 Breaking Down the VBA Code.mp4 [62m 651k 785]
002 Project #2 Breaking Down the VBA Code_en.srt [5k 49]
002 SortingRecords.xlsm [17k 112]
003 Project #2 Prompting the User for Information.mp4 [225m 117k 426]
003 Project #2 Prompting the User for Information_en.srt [9k 909]
004 Continue Excel VBA InputBox.mp4 [71m 830k 773]
004 Continue Excel VBA InputBox_en.srt [9k 424]
005 Project #2 Building Logic into Your Macros.mp4 [146m 246k 946]
005 Project #2 Building Logic into Your Macros_en.srt [5k 999]
006 Project #2 Alerting the User of Errors.mp4 [187m 767k 355]
006 Project #2 Alerting the User of Errors_en.srt [14k 296]
007 Other Practical Uses of Message and Input Boxes.mp4 [27m 694k 894]
007 Other Practical Uses of Message and Input Boxes_en.srt [4k 761]

37 Project #3 Preparing and Cleaning Up Data with a Little VBA
001 Introduction to Project #3 Cleaning Up and Formatting Data.mp4 [0]
001 Introduction to Project #3 Cleaning Up and Formatting Data_en.srt [0]
002 Project #3 Preparing to the Use the Macro Recorder.mp4 [24m 200k 919]
002 Project #3 Preparing to the Use the Macro Recorder_en.srt [4k 220]
003 Project #3 Inserting the Headers.mp4 [20m 109k 930]
003 Project #3 Inserting the Headers_en.srt [5k 830]
004 Project #3 Formatting the Headers.mp4 [19m 261k 732]
004 Project #3 Formatting the Headers_en.srt [3k 817]
005 Project #3 Putting it all Together with a Little VBA.mp4 [194m 993k 522]
005 Project #3 Putting it all Together with a Little VBA_en.srt [15k 299]
006 Running the Loop.mp4 [52m 677k 516]
006 Running the Loop_en.srt [4k 568]

38 Project #4 Using VBA to Automate Excel Formulas
001 Introduction to Project #4 Automate Excel Formulas.mp4 [72m 188k 204]
001 Introduction to Project #4 Automate Excel Formulas_en.srt [3k 223]
002 AutomateSumFunction.xlsx [20k 309]
002 Project #4 Automate the SUM() Function through Code.mp4 [145m 844k 592]
002 Project #4 Automate the SUM() Function through Code_en.srt [11k 992]
003 Continue Automate SUM Function.mp4 [32m 983k 273]
003 Continue Automate SUM Function_en.srt [8k 429]
004 Test the SUM Function.mp4 [68m 871k 104]
004 Test the SUM Function_en.srt [5k 957]
005 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 [206m 110k 271]
005 Project #4 Loop the SUM() Function Over Multiple Worksheets_en.srt [9k 141]

39 Project #5 Bringing it All Together and a Weekly Report
001 Introduction to Project #5 Creating the Final Report.mp4 [102m 3k 784]
001 Introduction to Project #5 Creating the Final Report_en.srt [5k 376]
002 Project #5 Creating the Final Report Loop.mp4 [77m 979k 344]
002 Project #5 Creating the Final Report Loop_en.srt [12k 271]
003 Project #5 - Copying and Pasting Data with VBA.mp4 [93m 936k 973]
003 Project #5 - Copying and Pasting Data with VBA_en.srt [13k 543]
004 Project #5 - Running the Final Report Procedure.mp4 [60m 109k 707]
004 Project #5 - Running the Final Report Procedure_en.srt [4k 861]

40 Project #6 Working with Excel VBA User Forms
001 Introduction to Project #6 Working with Excel VBA User Forms.mp4 [28m 333k 510]
001 Introduction to Project #6 Working with Excel VBA User Forms_en.srt [4k 596]
001 QuarterlyReportForm-01.xlsm [25k 61]
002 Project #6 Creating an Excel User Form.mp4 [50m 255k 774]
002 Project #6 Creating an Excel User Form_en.srt [8k 286]
003 Project #6 Adding Controls to the Form.mp4 [22m 1k 928]
003 Project #6 Adding Controls to the Form_en.srt [5k 373]
004 Project #6 Adding VBA Code to the Initialize Event.mp4 [82m 892k 986]
004 Project #6 Adding VBA Code to the Initialize Event_en.srt [12k 364]
005 Project #6 Adding VBA Code to the ComboBox Change Event.mp4 [44m 639k 536]
005 Project #6 Adding VBA Code to the ComboBox Change Event_en.srt [6k 375]
006 Project #6 Adding VBA Code to the Add Worksheet Button.mp4 [34m 699k 215]
006 Project #6 Adding VBA Code to the Add Worksheet Button_en.srt [5k 315]
007 Change Worksheet Name.mp4 [39m 538k 190]
007 Change Worksheet Name_en.srt [5k 828]
008 Project #6 Adding VBA Code to the Create Report Button.mp4 [159m 777k 197]
008 Project #6 Adding VBA Code to the Create Report Button.vtt [11k 220]
008 Project #6 Adding VBA Code to the Create Report Button_en.srt [13k 177]
009 Project #6 Showing the Form.mp4 [71m 79k 739]
009 Project #6 Showing the Form_en.srt [5k 734]

41 Project #7 Importing Data from Text Files
001 April2015Sales.txt [1k 816]
001 Dec2015Sales.txt [1k 158]
001 Feb2015Sales.txt [1k 186]
001 Jan2015Sales.txt [1k 278]
001 Mar2015Sales.txt [1k 224]
001 May2015Sales.txt [1k 274]
001 Nov2015Sales.txt [1k 290]
001 Project #7 Opening a Text File for Import.mp4 [18m 401k 679]
001 Project #7 Opening a Text File for Import_en.srt [4k 297]
002 Project #7 Opening a Text File for Import.mp4 [60m 701k 138]
002 Project #7 Opening a Text File for Import_en.srt [9k 907]
003 Project #7 Get Data from Text File.mp4 [41m 221k 83]
003 Project #7 Get Data from Text File_en.srt [9k 159]
004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 [82m 955k 706]
004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method_en.srt [0]
005 Project #7 Creating a Loop to Read Each File.mp4 [42m 34k 77]
005 Project #7 Creating a Loop to Read Each File_en.srt [12k 237]
006 Project #7 Adding a New Sheet for Imported Data.mp4 [30m 246k 764]
006 Project #7 Adding a New Sheet for Imported Data_en.srt [4k 29]
007 Project #7 Clear the Clipboard.mp4 [41m 154k 674]
007 Project #7 Clear the Clipboard_en.srt [5k 761]
008 Project #7 Working with the ScreenUpdating Property.mp4 [22m 882k 470]
008 Project #7 Working with the ScreenUpdating Property_en.srt [5k 461]
009 Project #7 Creating Reusable Code with a VBA Function.mp4 [99m 137k 892]
009 Project #7 Creating Reusable Code with a VBA Function_en.srt [11k 988]

42 Course Wrap Up
001 Congratulations! You're an Excel MacroVBA Master.mp4 [5m 442k 135]
001 Congratulations! You're an Excel MacroVBA Master_en.srt [1k 268]

Объем: 12,4Гб.

Курс на английском языке

Скрытый текст. Доступен только зарегистрированным пользователям.Нажмите, чтобы раскрыть...