Database Clinic: MS Excel [2017, ENG]
movies, software, shows...
Files
| 001 Welcome.mp4 | 4.27 MB | ||
| 002 The database clinic series.mp4 | 9.26 MB | ||
| 003 What you should know.mp4 | 6.62 MB | ||
| 004 Use the exercise files.mp4 | 5.16 MB | ||
| 005 A brief overview of Excel.mp4 | 7.36 MB | ||
| 006 Strengths and weaknesses of Excel.mp4 | 5.16 MB | ||
| 007 Database creation.mp4 | 15.63 MB | ||
| 008 An overview of database creation in Excel.mp4 | 4.88 MB | ||
| 009 Create a database in Excel.mp4 | 9.06 MB | ||
| 010 Insights on database creation in Excel.mp4 | 3.17 MB | ||
| 011 Join datasets.mp4 | 10.59 MB | ||
| 012 An overview of joining datasets in Excel.mp4 | 13.76 MB | ||
| 013 Join two datasets in Excel.mp4 | 27.15 MB | ||
| 014 Insights on joining datasets in Excel.mp4 | 4.14 MB | ||
| 015 Search a database.mp4 | 10.5 MB | ||
| 016 An overview of searching in Excel.mp4 | 1.8 MB | ||
| 017 Search a database in Excel.mp4 | 11.94 MB | ||
| 018 Insights on searching in Excel.mp4 | 3.36 MB | ||
| 019 CRUD operations.mp4 | 12.24 MB | ||
| 020 An overview of CRUD operations in Excel.mp4 | 4.54 MB | ||
| 021 Import text into Excel.mp4 | 15.53 MB | ||
| 022 Clean text in Excel.mp4 | 22.24 MB | ||
| 023 Format text in Excel.mp4 | 33.52 MB | ||
| 024 Insights on CRUD operations in Excel.mp4 | 5.22 MB | ||
| 025 Calculations.mp4 | 8.66 MB | ||
| 026 An overview of calculations in Excel.mp4 | 3 MB | ||
| 027 Create a pivot table from two data sources.mp4 | 14.81 MB | ||
| 028 Calculate cohort percentages in Excel.mp4 | 24.25 MB | ||
| 029 Extrapolate population data in Excel.mp4 | 34.78 MB | ||
| 030 Insights calculations in Excel.mp4 | 2.51 MB | ||
| 031 Next steps.mp4 | 3.73 MB | ||
| Exercise Files | |||
| Chapter 03 | |||
| AccidentAnalysis.xlsx | 7.66 KB | ||
| AccidentAnalysis_Final.xlsx | 3.41 MB | ||
| Chapter 05 | |||
| A_Midsummer_Nights_Dream.xml | 141.64 KB | ||
| Dream_Final.xlsx | 96.81 KB | ||
| Dream_Step2.xlsx | 96.01 KB | ||
| Dream_Step3.xlsx | 112.04 KB | ||
| characters.txt | 168 B | ||
| Chapter 06 | |||
| Cohort Analysis Final.xlsx | 6.91 MB | ||
| Cohort Analysis Step 2.xlsx | 6.86 MB | ||
| Cohort Analysis Step 3.xlsx | 6.9 MB | ||
| Cohort Analysis.xlsx | 7.66 KB | ||
| DatabaseClinic-MSExcel.pdf | 431.37 KB | ||
| ▲ 43 total files | |||
Description
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Офисные программы Microsoft
Database Clinic: MS Excel
Год выпуска: 06/2017
Производитель: Lynda
Сайт производителя: lynda.com/Excel-tutorials/Database-Clinic-MS-Excel/592494-2.html
Автор: Curt Frye
Продолжительность: 1:52
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: The Database Clinic series shows how to plan, build, and optimize databases using different software. This course focuses on Microsoft Excel. While Excel doesn't offer traditional relational database management features, its table-based sheets, functions links, and powerful search and reporting features make it a great tool for learning the basics of database design. Join Curt Frye as he shows how to create a simple database, join data sets, search for records, and perform CRUD (create, read, update, and delete) operations. Plus, learn how to use Excel's calculations, PivotTables, functions, and formulas to gain deeper insights into your data.
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1280x720, 16:9, 30fps, 508kbps
Аудио: AAC, 48kHz, 128/160kbps, stereo
[spoiler="Скриншоты"]
[/spoiler]
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 373.37 MB | Alex Mill | 8 years | 6 | 1 | |
| 395.81 MB | Stas.nsk | 8 years | 6 | 0 |
All Comments