Descriptions
Microsoft Excel Foundations, In this course you’ll build the skills you need to manage, explore, analyze, and visualize data in Microsoft Excel using real-world projects and datasets. We’ll start by introducing the Excel landscape and interface, then dive into spreadsheet fundamentals like table structures, data types, formatting, sorting, and filtering. From there we’ll dig into formulas and functions, introduce key topics like syntax, reference types, and common errors, and practice applying some of the most common and powerful techniques for data management and analysis. We’ll use functions to count and aggregate values, create logical tests, join data across tables, manipulate text and date values, and more. Next we’ll introduce pivot tables, an essential spreadsheet tool for data exploration. We’ll prepare raw data for analysis, create views to slice and dice the data, apply different calculation options, and use tools like sorting, filtering, and calculated fields. Last but not least, we’ll dive into the world of data visualization and storytelling, review best practices for effective design, and bring our data to life using essential visuals like bar, line, and pie charts, scatterplots, histograms, and maps. This is a hands-on and project-based course, designed to help you build practical data literacy and analytical thinking skills. You’ll work with unique, real-world datasets from Flight Delays to Sales Pipelines, and apply the skills you learn every step of the way.
What you’ll learn
- Identify the basics for getting up & running with Excel, including creating & managing spreadsheets and navigating the menus & settings
- Identify and interpret fundamental spreadsheet and data literacy concepts, including data terminology, data types, data validation rules, conditional formatting, and sorting & filtering
- Identify and interpret formulas syntax, reference types, and errors, as well as math, logical, text, date, and lookup functions
- Identify and interpret examples of analyzing data with pivot tables, including their source data structure, calculation options, calculated fields, and sorting & filtering
- Identify and interpret examples of visualizing data with charts & graphs, including line & area charts, bar & column charts, combo charts, pie & donut charts, histograms, scatterplots, and maps
Who this course is for
- Everyday people looking to build confidence and use data more effectively
- Anyone seeking a comprehensive introduction to Microsoft Excel
- Data professionals who want to build job-ready data management, analysis, and visualization skills
Specificatoin of Microsoft Excel Foundations
- Publisher : Maven Analytics
- Teacher : Enrique Ruiz
- Language : English
- Level : All Levels
- Duration : 9 hours and 0 minutes
Content of Microsoft Excel Foundations
Requirements
- Microsoft Excel 365 (some functionality may be unavailable on other versions)
- No advance preparation is required
Pictures
Sample Clip
Installation Guide
Extract the files and watch with your favorite player
Subtitle : English
Quality: 1080p
Download Links
Downloadly
Rapidgator
Password file(s): www.downloadly.ir
File size
1.47 GB
