Learning Office Tutorials

Learning Office Tutorials → From Excel to SQL

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Free Download From Excel to SQL
Duration: 1h 24m | MP4 | Video: AVC, 1280x720 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

Learning Office Tutorials → Fire Fighting Design Manually, Elite Software, Excel

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Learning Office Tutorials → Excel Modeling for Beginners

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Free Download Excel Modeling for Beginners
Released 8/2024
MP4 | Video: h264, 1280x720 | 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.

Learning Office Tutorials → Excel for Project Management (2024)

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Free Download Excel for Project Management (2024)
Released: 07/2024
Duration: 1h 41m | .MP4 1280x720, 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.

Learning Office Tutorials → Excel 2021 – Intermediate

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Learning Office Tutorials → Copilot in Word 365

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Learning Office Tutorials → Copilot In Microsoft Onenote, Whiteboard, And Forms [Bundle]

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Free Download Copilot In Microsoft Onenote, Whiteboard, And Forms [Bundle]
Published 8/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 430.13 MB | Duration: 0h 43m
Enhance Form Creation, Visual Storytelling, and Note Management

Learning Office Tutorials → Copilot In Microsoft 365 Stream

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Free Download Copilot In Microsoft 365 Stream
Published 8/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 330.38 MB | Duration: 0h 35m
Learn how Copilot integrates into Microsoft 365 Stream

Learning Office Tutorials → Copilot In Microsoft 365 Outlook And Powerpoint [Bundle]

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Free Download Copilot In Microsoft 365 Outlook And Powerpoint [Bundle]
Published 8/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 566.70 MB | Duration: 0h 45m
Enhance Presentation Design, Email Management, and Workflow Efficiency

Learning Office Tutorials → Complete Microsoft Office Course Basic to Advance

Published by: E-Learning79 on 21-08-2024, 20:00 | 0

Free Download Complete Microsoft Office Course Basic to Advance
Published 6/2024
Created by Veer Tutorial,Mahavir Bhardwaj
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 189 Lectures ( 15h 46m ) | Size: 7 GB