~Get Your Files Here !/03 - 2. Advanced Scripting and Integration in Office Scripts/04 - Automating multiple workbooks with Power Automate and Office Scripts.mp4 13.0 MB
~Get Your Files Here !/03 - 2. Advanced Scripting and Integration in Office Scripts/03 - Integrating Office Scripts with Power Automate.mp4 12.8 MB
~Get Your Files Here !/04 - Conclusion/01 - The future of Excel automation with Office Scripts.mp4 8.5 MB
~Get Your Files Here !/03 - 2. Advanced Scripting and Integration in Office Scripts/01 - Debugging Office Scripts with console.log().mp4 8.1 MB
~Get Your Files Here !/02 - 1. Understanding and Setting Up Office Scripts/05 - Solution Reporting on tasks.mp4 7.8 MB
~Get Your Files Here !/01 - Introduction/02 - What you should know before starting this course.mp4 7.4 MB
~Get Your Files Here !/03 - 2. Advanced Scripting and Integration in Office Scripts/02 - Collaborating with Office Scripts.mp4 6.9 MB
~Get Your Files Here !/03 - 2. Advanced Scripting and Integration in Office Scripts/06 - Solution AutoFit and freeze panes for all workbooks.mp4 6.6 MB
~Get Your Files Here !/02 - 1. Understanding and Setting Up Office Scripts/03 - Exploring the main() function in Office Scripts.mp4 6.4 MB
~Get Your Files Here !/02 - 1. Understanding and Setting Up Office Scripts/02 - Setting up and using Record Actions.mp4 5.9 MB
~Get Your Files Here !/02 - 1. Understanding and Setting Up Office Scripts/01 - Comparing Office Scripts and VBA for Excel automation.mp4 5.5 MB
~Get Your Files Here !/01 - Introduction/01 - Introduction to Office Scripts in Excel.mp4 4.0 MB
~Get Your Files Here !/02 - 1. Understanding and Setting Up Office Scripts/04 - Challenge Create a task summary report.mp4 3.1 MB
~Get Your Files Here !/03 - 2. Advanced Scripting and Integration in Office Scripts/05 - Challenge AutoFit and freeze panes for all workbooks.mp4 2.6 MB
~Get Your Files Here !/Ex_Files_Office_Scripts_in_Excel/Exercise Files/2-advanced-scripting-and-integration-office-scripts/collaborating-office-scripts.xlsx 20.3 kB
~Get Your Files Here !/Ex_Files_Office_Scripts_in_Excel/Exercise Files/2-advanced-scripting-and-integration-office-scripts/schedule-with-power-automate.xlsx 19.8 kB
~Get Your Files Here !/Ex_Files_Office_Scripts_in_Excel/Exercise Files/1-understanding-setting-up-office-scripts/01-solution.xlsx 10.5 kB
~Get Your Files Here !/Ex_Files_Office_Scripts_in_Excel/Exercise Files/1-understanding-setting-up-office-scripts/record-actions.xlsx 10.4 kB
~Get Your Files Here !/Ex_Files_Office_Scripts_in_Excel/Exercise Files/1-understanding-setting-up-office-scripts/01-challenge.xlsx 10.0 kB
~Get Your Files Here !/Ex_Files_Office_Scripts_in_Excel/Exercise Files/2-advanced-scripting-and-integration-office-scripts/multiple-workbooks/sales-report.xlsx 9.9 kB
~Get Your Files Here !/5. Grouping & Formatting Data in Your PivotTables/4. Using Conditional Formatting to Highlight Important Information.mp4 191.9 MB
~Get Your Files Here !/3. Creating PivotTables/1. Creating Your 1st PivotTable Focus on the Data Source & PivotTable Environment.mp4 191.6 MB
~Get Your Files Here !/5. Grouping & Formatting Data in Your PivotTables/5. Applying Formatting Styles to PivotTables.mp4 150.1 MB
~Get Your Files Here !/4. Filtering & Sorting PivotTables/1. Applying Filters to PivotTable Fields.mp4 143.2 MB
~Get Your Files Here !/6. Calculating Values in PivotTables/3. Displaying Values as Percentages, Difference, and Rank.mp4 123.1 MB
~Get Your Files Here !/4. Filtering & Sorting PivotTables/3. Slicers The User-Friendly Way to Filter Your PivotTable.mp4 107.1 MB
~Get Your Files Here !/4. Filtering & Sorting PivotTables/4. Timelines Dashboard Filters for Your Date Field.mp4 105.2 MB
~Get Your Files Here !/7. Creating PivotCharts/1. Introduction to PivotCharts.mp4 84.0 MB
~Get Your Files Here !/4. Filtering & Sorting PivotTables/2. Report Filters Filtering the Entire PivotTable.mp4 81.1 MB
~Get Your Files Here !/8. PivotTable Tips & Tricks/3. Clearing Deleted Items from a PivotTable.mp4 76.1 MB
~Get Your Files Here !/3. Creating PivotTables/3. Exercise Creating Two PivotTables.mp4 71.9 MB
~Get Your Files Here !/3. Creating PivotTables/2. Creating PivotTable 2 Focus on Source, PivotTable Fields, and Arranging Fields.mp4 67.6 MB
~Get Your Files Here !/5. Grouping & Formatting Data in Your PivotTables/1. Grouping Records - Quick & Easy.mp4 65.5 MB
~Get Your Files Here !/8. PivotTable Tips & Tricks/5. Automatic v. Manual Data Updating.mp4 58.9 MB
~Get Your Files Here !/4. Filtering & Sorting PivotTables/5. Creating a Custom Sort List.mp4 46.9 MB
~Get Your Files Here !/5. Grouping & Formatting Data in Your PivotTables/6. Changing Your PivotTable's Layout.mp4 44.8 MB
~Get Your Files Here !/6. Calculating Values in PivotTables/4. Finding the Top or Bottom Values in Your PivotTable.mp4 44.3 MB
~Get Your Files Here !/8. PivotTable Tips & Tricks/2. The Trick to Creating Multiple PivotTables from the Report Filters.mp4 40.1 MB
~Get Your Files Here !/5. Grouping & Formatting Data in Your PivotTables/2. Grouping by Date with Just a Few Clicks.mp4 37.9 MB
~Get Your Files Here !/6. Calculating Values in PivotTables/2. Creating Custom Calculated Fields.mp4 32.6 MB
14. Project 11 Building a SQL Database & Data Schema for Brazlian ECommerce Store/4.1 Reources.zip 618.7 MB
6. Project 3 Analysing Microsoft Quarterly Earning Press Release Documents/2. Analysising Text Data and Content Generation.mp4 137.7 MB
15. Project 12 - Creating Front End (HTML, CSS) for Landing Pages/1. Create and Modify a Landing Pages Front End (HTML & CSS).mp4 123.1 MB
10. Project 7 Sentiment Analysis of McDonalds Reviews/2. Exploratory Data Analysis on McDonald's Reviews.mp4 122.7 MB
7. Project 4 - NVDIA Stock Price and Historical Return Charts/2. Plotting historical returns for NVDIA stock.mp4 109.9 MB
8. Project 5 Correlation Analysis on a Portfolio of Stocks (Financial Analysis)/4. Correlation and Portfolio Return Analysis.mp4 103.3 MB
2. Basics of ChatGPT (Skip this section if you understand the basics)/6. Coding.mp4 94.5 MB
14. Project 11 Building a SQL Database & Data Schema for Brazlian ECommerce Store/3. Analysing Payments dataset by Type, Time and Location.mp4 85.9 MB
14. Project 11 Building a SQL Database & Data Schema for Brazlian ECommerce Store/4. Creating, Storing and Query the data using SQL (SQLITE) Database.mp4 85.7 MB
1. Introduction/3. Understanding how Code Interpreter works.mp4 85.5 MB
13. Project 10 - Building a Regression Model for Loan Approval with 90% accuracy/2. Exploratory Data Analysis - Understanding the data.mp4 80.3 MB
13. Project 10 - Building a Regression Model for Loan Approval with 90% accuracy/3. Building the Logistic Regression Model with 90% accuracy.mp4 76.7 MB
3. Tips for Designing Prompts (Skip this section if you understand the basics)/4. Zero Shot & Few Shot Prompting.mp4 73.0 MB
10. Project 7 Sentiment Analysis of McDonalds Reviews/3. Creating a Word Map for understanding Text Reviews Data.mp4 60.4 MB
8. Project 5 Correlation Analysis on a Portfolio of Stocks (Financial Analysis)/3. Exploratory Data Analysis (EDA) on the stocks price data.mp4 60.4 MB
12. Project 9 Build a Word and Character count app with ChatGPT Code Interpreter/1. Building a WordCount app.mp4 58.9 MB
8. Project 5 Correlation Analysis on a Portfolio of Stocks (Financial Analysis)/2. Uploading and Extracting the relevant data from the dataset.mp4 56.5 MB
Модуль 3/Тема 1 Применение категории встроенных функций «Ссылки и Массивы» и формул массивов/0 Видео/3x_1.8_RSR_Izvlechenie_dannyh_iz_massiva_02.2019.mp4 931.8 MB
Модуль 1/Тема 2 Приёмы работы в Microsoft Exce/0 Видео/EX_2.4_Tipy_dannyh_07.2018.mp4 447.3 MB
Модуль 1/Тема 5 Вычисления в Microsoft Excel/0 Видео/EX_5.8_Funkcii_07.2018.mp4 364.5 MB
Модуль 3/Тема 1 Применение категории встроенных функций «Ссылки и Массивы» и формул массивов/0 Видео/3x_1.5_Dvustoronnij_mnogokriterialnyj_poisk_02.2019.mp4 354.6 MB
Модуль 3/Тема 1 Применение категории встроенных функций «Ссылки и Массивы» и формул массивов/0 Видео/3x_1.4_Poisk_po_neskolkim_kriteriyam_02.2019.mp4 282.2 MB
Модуль 1/Тема 5 Вычисления в Microsoft Excel/0 Видео/EX_5.11_Oshibki_v_formulah_07.2018.mp4 282.0 MB
Модуль 2/Тема 1 Вычисления в программе с помощью функций/0 Видео/2x_1.8_Logicheskie_funkcii_10.2018.mp4 272.2 MB
Модуль 3/Тема 1 Применение категории встроенных функций «Ссылки и Массивы» и формул массивов/0 Видео/3x_1.2_Funkcii_v_formulah_massivov_02.2019.mp4 271.3 MB