Excel - Tracking Data Easily and Efficiently (2023)

seeders: 1
leechers: 8
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 12
  • Language: English

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

Description

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



Download torrent
659.5 MB
seeders:1
leechers:8
Excel - Tracking Data Easily and Efficiently (2023)

Trackers

tracker name
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
µTorrent compatible trackers list

Download torrent
659.5 MB
seeders:1
leechers:8
Excel - Tracking Data Easily and Efficiently (2023)

Torrent hash: 07E99FB4DDCA8B15F5B590002C80E07C65A6A6DD