Excel - Tracking Data Easily and Efficiently (2023)

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size659.5 MB
  • Uploaded Byfreecoursewb
  • Downloads12
  • Last checkedAug. 17th '23
  • Date uploadedAug. 17th '23
  • Seeders 1
  • Leechers8

Infohash : 07E99FB4DDCA8B15F5B590002C80E07C65A6A6DD

Excel: Tracking Data Easily and Efficiently (2023)



https://CourseWikia.com

Released: 08/2023
Duration: 3h 51m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 659 MB
Level: Intermediate | Genre: eLearning | Language: English

Too often, Excel users struggle to effectively track data in Excel because they start with the final report in mind. While this seems intuitive, setting up a spreadsheet in this way limits what a person can get from their data. In this course, follow along with Excel MVP Oz du Soleil as he shows how to use Excel features and functions—including Power Query and dynamic arrays—to build and organize basic spreadsheets and transform them into robust tracking systems for any kind of data that is regularly updated. Learn how to create a tracker in Excel that you and your team can use to easily track any kind of data: sales, donations, inventory levels, project statuses, student progress, household spending, and more. Oz wraps up with challenges that invite you to pull together everything you've learned.

Homepage

https://www.linkedin.com/learning/excel-tracking-data-easily-and-efficiently-22680069

Files:

[ CourseWikia.com ] Excel - Tracking Data Easily and Efficiently (2023)
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 01 - Introduction
    • 01 - Efficient data tracking in Excel.mp4 (4.4 MB)
    • 01 - Efficient data tracking in Excel.srt (1.1 KB)
    02 - 1. Planning Your Data Tracker
    • 01 - Introducing tables.mp4 (12.1 MB)
    • 01 - Introducing tables.srt (6.7 KB)
    • 02 - Key features of an effective data tracker.mp4 (19.7 MB)
    • 02 - Key features of an effective data tracker.srt (7.4 KB)
    03 - 2. Helpful Data Tracking Features
    • 01 - Thinking about input, storage, and output.mp4 (17.2 MB)
    • 01 - Thinking about input, storage, and output.srt (7.8 KB)
    • 02 - Incorporating charts into your tracker.mp4 (21.6 MB)
    • 02 - Incorporating charts into your tracker.srt (8.8 KB)
    • 03 - Adding helper columns.mp4 (9.7 MB)
    • 03 - Adding helper columns.srt (3.6 KB)
    • 04 - Using Slicers to filter for details.mp4 (10.7 MB)
    • 04 - Using Slicers to filter for details.srt (4.3 KB)
    • 05 - Summary pages and dashboards.mp4 (15.9 MB)
    • 05 - Summary pages and dashboards.srt (5.3 KB)
    • 06 - Ad hoc vs. at-a-glance needs.mp4 (13.6 MB)
    • 06 - Ad hoc vs. at-a-glance needs.srt (5.2 KB)
    04 - 3. Protecting Your Work and Calculations
    • 01 - Protecting cells and sheets.mp4 (17.6 MB)
    • 01 - Protecting cells and sheets.srt (8.1 KB)
    • 02 - Hidden sheets.mp4 (8.2 MB)
    • 02 - Hidden sheets.srt (4.0 KB)
    • 03 - Hidden columns and rows.mp4 (12.9 MB)
    • 03 - Hidden columns and rows.srt (5.9 KB)
    05 - 4. Managing Inputs and Calculations
    • 01 - Using dropdown lists for accuracy and consistency.mp4 (23.5 MB)
    • 01 - Using dropdown lists for accuracy and consistency.srt (10.7 KB)
    • 02 - Applying formula triggers to prevent inaccurate results.mp4 (10.0 MB)
    • 02 - Applying formula triggers to prevent inaccurate results.srt (5.1 KB)
    • 03 - Using cross-footing as a check for data quality.mp4 (16.4 MB)
    • 03 - Using cross-footing as a check for data quality.srt (5.0 KB)
    • 04 - Data validation for reasonable values.mp4 (14.0 MB)
    • 04 - Data validation for reasonable values.srt (5.5 KB)
    • 05 - Times Checking data quality.mp4 (6.2 MB)
    • 05 - Times Checking data quality.srt (3.2 KB)
    06 - 5. Midterm Building a Tracker
    • 01 - Challenge Building a data tracker for event details.mp4 (5.3 MB)
    • 01 - Challenge Building a data tracker for event details.srt (2.3 KB)
    • 02 - Solution Building a data tracker for event details.mp4 (16.4 MB)
    • 02 - Solution Building a data tracker for event details.srt (7.2 KB)
    07 - 6. Dynamic Arrays and the New Excel Calculation Engine
    • 01 - Dynamic Arrays One formula, many results.mp4 (17.6 MB)
    • 01 - Dynamic Arrays One formula, many results.srt (6.8 KB)
    • 02 - Dynamic Arrays FILTER, UNIQUE, SORT.mp4 (25.6 MB)
    • 02 - Dynamic Arrays FILTER, UNIQUE, SORT.srt (10.6 KB)
    • 03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.mp4 (18.7 MB)
    • 03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.srt (7.2 KB)
    08 - 7. VLOOKUP and XLOOKUP
    • 01 - VLOOKUP.mp4 (13.0 MB)
    • 01 - VLOOKUP.srt (5.0 KB)
    • 02 - Categorizing bonuses with VLOOKUP.mp4 (9.6 MB)
    • 02 - Categorizing bonuses with VLOOKUP.srt (3.5 KB)
    • 03 - Merging data with XLOOKUP.mp4 (14.3 MB)
    • 03 - Merging data with XLOOKUP.srt (5.9 KB)
    • 04 - Categorizing bonuses with XLOOKUP.mp4 (9.2 MB)
    • 04 - Categorizing bonuses with XLOOKUP.srt (4.7 KB)
    09 - 8. PivotTable Basics
    • 01 - What is a PivotTable.mp4 (28.0 MB)
    • 01 - What is a PivotTable.srt (10.6 KB)
    • 02 - Preparing and connecting a PivotTable to your data.mp4 (22.5 MB)
    • 02 - Preparing and connecting a PivotTable to your data.srt (8.4 KB)
    • 03 - Building and using a PivotTable.mp4 (21.5 MB)
    • 03 - Building and using a PivotTable.srt (7.6 KB)
    10 - 9. Using Power Query to Clean, Format, and Automate
    • 01 - Power Query overview.mp4 (35.7 MB)
    • 01 - Power Query overview.srt (12.5 KB)
    • 02 - Splitting columns.mp4 (17.8 MB)
    • 02 - Splitting columns.srt (8.2 KB)
    • 03 - Append in Power Query.mp4 (25.7 MB)
    • 03 - Append in Power Query.srt (11.3 KB)
    • 04 - Unpivot and fill-down.mp4 (26.5 MB)
    • 04 - Unpivot and fill-down.srt (10.8 KB)
    11 - 10. Pretty It Up!
    • 01 - Data bars for easy visual comparison.mp4 (5.4 MB)
    • 01 - Data bars for easy visual comparison.srt (2.6 KB)
    • 02 - Connecting a value to a shape.mp4 (14.8 MB)
    • 02 - Connecting a value to a shape.srt (6.3 KB)
    • 03 - Hiding zeroes.mp4 (7.4 MB)
    • 03 - Hiding zeroes.srt (2.9 KB)
    • 04 - Conditional formatting to warn of deadlines.mp4 (20.2 MB)
    • 04 - Conditional formatting to warn of deadlines.srt (8.5 KB)
    12 - 11. Get Hands On
    • 01 - Challenge Building a tracker 1.mp4 (4.1 MB)
    • 01 - Challenge Building a tracker 1.srt (1.4 KB)
    • 02 - Solution Building a tracker 1.mp4 (14.4 MB)
    • 02 - Solution Building a tracker 1.srt (5.0 KB)
    • 03 - Challenge Building a tracker 2.mp4 (7.4 MB)
    • 03 - Challenge Building a tracker 2.srt (3.1 KB)
    • 04 - Solution Building a tracker 2.mp4 (34.6 MB)
    • 04 - Solution Building a tracker 2.srt (10.1 KB)
    13 - Conclusion
    • 01 - Continue your data tracking journey in Excel.mp4 (5.2 MB)
    • 01 - Continue your data tracking journey in Excel.srt (1.4 KB)
    • Bonus Resources.txt (0.4 KB)
      • Ex_Files_Excel_Tracking_Data_Easily Exercise Files Chap 01
      • Features of an effective data tracker.xlsx (28.0 KB)
      • Introducing tables.xlsx (10.0 KB)
      Chap 02
      • Ad h

Code:

  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • http://tracker.foreverpirates.co:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://9.rarbg.to:2780/announce
  • udp://tracker.internetwarriors.net:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://open.stealth.si:80/announce
  • udp://9.rarbg.to:2900/announce
  • udp://9.rarbg.me:2720/announce
  • udp://opentor.org:2710/announce