Lynda - Excel: Setting Up a Database (Office 365/Microsoft 365)

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size215.4 MB
  • Uploaded Bytutsnode
  • Downloads412
  • Last checkedJan. 19th '21
  • Date uploadedJan. 16th '21
  • Seeders 46
  • Leechers3
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : 09202A6CA2536376E96C8FC522379B9B4DFA7986


Description

Did you know you can use Excel to create a simple database and get even more insights into your data? Join instructor Dennis Taylor and learn how to create a simple database. Dennis explains how to prepare lists that are suitable for data analysis. He goes into how to use the Form tool to view and manage records in a list, then covers how to use the Data Validation command to enter data quickly and accurately. Dennis steps through how to convert data to a table and use its many valuable features. He discusses the Table Design tab, demonstrating how to access the many formatting features to apply to tables. He demonstrates how to expand tables quickly and easily by adding adjacent rows and columns, as well as total rows. Dennis highlights some techniques for creating formulas using field names. He concludes by showing you how to use slicers to filter data with appealing, easy-to-read visuals.

Released 1/13/2021

Files:

Excel - Setting Up a Database (Office 365 or Microsoft 365) [TutsNode.com] - Excel - Setting Up a Database (Office 365 or Microsoft 365) 02 Database Design Concerns
  • 001 Set up large lists and restructure downloaded data.mp4 (32.0 MB)
  • 002 Recognize problems-en.srt (11.7 KB)
  • 001 Set up large lists and restructure downloaded data-en.srt (10.8 KB)
  • 002 Recognize problems.mp4 (30.1 MB)
01 Introduction
  • 001 Managing data with Excel-en.srt (1.7 KB)
  • 001 Managing data with Excel.mp4 (7.4 MB)
03 Controlling the Creation of New Data
  • 002 Use Data Validation to control data entry values-en.srt (11.5 KB)
  • 001 Use the Form tool to build and view data-en.srt (10.2 KB)
  • 001 Use the Form tool to build and view data.mp4 (18.6 MB)
  • 002 Use Data Validation to control data entry values.mp4 (16.4 MB)
04 Tables
  • 001 Convert data into tables for enhanced visual and content control-en.srt (10.7 KB)
  • 003 Expand tables automatically and add totals-en.srt (10.0 KB)
  • 005 Use slicers to facilitate table filtering-en.srt (9.8 KB)
  • 004 Work with formulas in tables-en.srt (9.1 KB)
  • 002 Use the Design tab to control table formatting-en.srt (8.8 KB)
  • 005 Use slicers to facilitate table filtering.mp4 (23.6 MB)
  • 001 Convert data into tables for enhanced visual and content control.mp4 (23.2 MB)
  • 002 Use the Design tab to control table formatting.mp4 (22.3 MB)
  • 003 Expand tables automatically and add totals.mp4 (20.2 MB)
  • 004 Work with formulas in tables.mp4 (16.3 MB)
05 Conclusion
  • 001 Where to learn more-en.srt (1.0 KB)
  • 001 Where to learn more.mp4 (2.6 MB)
  • Ex_Files_Excel_Setting_Up_a_Database.zip (1.1 MB)
    • TutsNode.com.txt (0.1 KB)
    • [TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)
      • .pad
      • 0 (132.5 KB)
      • 1 (156.9 KB)
      • 2 (184.5 KB)
      • 3 (91.2 KB)
      • 4 (243.8 KB)
      • 5 (10.3 KB)
      • 6 (129.7 KB)
      • 7 (96.6 KB)
      • 8 (231.7 KB)
      • 9 (102.9 KB)
      • 10 (180.8 KB)

Code:

  • udp://inferno.demonoid.pw:3391/announce
  • udp://tracker.openbittorrent.com:80/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://torrent.gresille.org:80/announce
  • udp://glotorrents.pw:6969/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://tracker.pirateparty.gr:6969/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://9.rarbg.to:2710/announce
  • udp://shadowshq.yi.org:6969/announce
  • udp://tracker.zer0day.to:1337/announce