Tag: EXCEL

August 21, 2024

From Excel to SQL

By  Other Tutorials  0 Comments

Free Download From Excel to SQL
Duration: 1h 24m | MP4 | Video: AVC, 1280×720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Size: 863 MB
Skill Level: Beginner | Genre: eLearning | Language: English + Subtitles
Data is powerful, and the ability to access it quickly and accurately is important. In this course, instructor James Parkin helps you use your existing Excel skills to master the basics of working with data in SQL, one of the most common languages for database wrangling. James shows you how to set up your environment for SQL and shares some differences between spreadsheets and databases. He steps through SQL basics that you need to know to access and identify the data you need. In both Excel and SQL, you work with functions. James covers several, including SUM, AVERAGE, MIN, MAX, COUNT. He explains different methods of sorting, grouping, and organizing your data in SQL. James concludes by showing you how to use joins, VLOOKUP, HLOOKUP, and XLOOKUP to combine your data.This course was created by Madecraft. We are pleased to host this training in our library.
Homepage

(more…)

August 21, 2024

Excel for Project Management (2024)

By  Other Tutorials  0 Comments

Free Download Excel for Project Management (2024)
Released: 07/2024
Duration: 1h 41m | .MP4 1280×720, 30 fps(r) | AAC, 48000 Hz, 2ch | 299 MB
Level: Intermediate | Genre: eLearning | Language: English
Excel is a powerful tool for managing projects, but it’s easy to be scared off by its hundreds of different formulas and functions. Many project managers barely scratch the surface of what Excel can really do. In this course, author and entrepreneur Jordan Goldmeier shows you how to track your projects in Excel easily and effectively. Learn the best way to set up your spreadsheet to visualize project progress, success, and even failures. Find out how to measure what’s most important for projects and how to use that data to inform future decision making. By the end of the course, you’ll know the best Excel features, tools, and functions to manage your projects.

(more…)

August 21, 2024

Excel Modeling for Beginners

By  Other Tutorials  0 Comments

Free Download Excel Modeling for Beginners
Released 8/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner + Intermediate | Genre: eLearning | Language: English + srt | Duration: 38m | Size: 88 MB
Models help businesses make better decisions by creating a simplified version of a process. In Excel, you can model just about anything, as long as you know the inputs, assumptions, best practices, tools, and techniques. In this course, Jordan Goldmeier-author, entrepreneur, and Microsoft MVP-defines what a model is and shows you how best to use Excel to represent the model. Learn important functions that will allow you to make predictions and forecasts around your data. Plus, find out how to present results to stakeholders.

(more…)