Excel data analysis bootcamp
https://DevCourseWeb.com
Last updated 11/2022
Duration: 56m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 593 MB
Genre: eLearning | Language: English
Microsoft Excel Course.Learn microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365
What you'll learn
Create dynamic reports by mastering one of the most popular tools, PivotTables
Maintain large sets of Excel data in a list or table
Learn the most common Excel functions used in the Office
Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Become expert in excel
Requirements
No prior knowledge is required
Description
This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.
While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.
Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
Create your own formula-based Excel formatting rules
Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions
Manipulate dates, times, text, and arrays
Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)
Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)