Foundations of Data Management and Analysis with Excel

Focused View

Dollar Design School

1:39:57

23 View

1. Welcome and Getting Started

1. Welcome and Course Overview.mp4

01:02

2. Prerequisites and target audience.mp4

00:56

3. Importance of data management and analysis in Excel.mp4

01:21

2. Sorting and Filtering

1. Sorting data by various criteria.mp4

06:02

2. Filtering data with basic and advanced techniques.mp4

09:57

3.1 0203.zip

3. Exercise Sort and filter a sample dataset.mp4

01:22

3. Grouping and Subtotaling

1. Grouping data by categories.mp4

05:48

2. Using subtotals to summarize grouped data.mp4

04:52

3.1 0303.zip

3. Exercise Group and subtotal sales data.mp4

01:19

4. Removing Duplicates and Data Consolidation

1. Methods to identify and remove duplicates.mp4

03:41

2. Consolidating data from multiple sources.mp4

04:35

3. Using Pivot Tables for summarizing data.mp4

08:00

4.1 0404 Contact List.xlsx.zip

4. Exercise Clean and consolidate a contact list.mp4

01:50

5. Logical Functions

1. IF, AND, OR functions.mp4

08:07

2. SUMIF and COUNTIF.mp4

04:39

3.1 0503.zip

3. Exercise Create conditional summaries.mp4

00:56

6. Lookup Functions

1. VLOOKUP and HLOOKUP.mp4

07:11

2.1 0603.zip

2. INDEX and MATCH as alternatives.mp4

04:53

7. Text and Date Functions

1. CONCATENATE, LEFT, RIGHT, MID.mp4

05:56

2.1 0703.zip

2. TODAY, NOW, DATEVALUE.mp4

04:10

8. Connecting to External Data Sets

1. Connecting to databases.mp4

05:13

2.1 0803.zip

2.2 Final Project.zip

2. Working with JSON Data.mp4

08:07

Description

Learn to Use Excel to Manage and Analyze Your Data

What You'll Learn?

Master Data Organization: Learn to efficiently sort, filter, group, and subtotal data, turning chaos into order in your Excel spreadsheets.
Enhance Analysis with Functions: Acquire essential Excel functions such as logical, lookup, text, and date functions, empowering you to perform complex analysis
Connect and Transform Data: Explore advanced techniques like live SQL queries, data validation, and Power Query, enabling you to connect, transform, and visuali
Hands-on Skill Application: Through guided exercises, apply the techniques learned to real-world scenarios, reinforcing your ability to manage and analyze data

Who is this for?

Anyone who wants to advance their Excel skills to learn the foundations of working with data

People who want to start learning data science and want an approachable, understandable foundation to the skillset

Students and teachers who need to advance their Excel knowledge

People who want to be more competitive in the contemporary job market

What You Need to Know?

Some experience with Excel basis is helpful for those wishing to complete this course.

More details

Description
Are you a marketer, small business owner, or data enthusiast lost in the sea of spreadsheet data? Ready to harness the power of Excel and turn those overwhelming numbers into insightful information?
Welcome to "Foundations of Data Management and Analysis with Excel," the course tailored for desktop workers like you with a foundational understanding of Excel.
In this comprehensive journey, we offer engaging content across numerous modules, featuring practical exercises and downloadable resources. You'll master the essential techniques that make managing and analyzing data not just manageable, but exciting. From sorting and filtering to live SQL database connections, we've curated a hands-on learning experience that goes beyond mere formulas.
What You'll Learn
â€¢ Organizing Data Like a Pro: Sort, filter, and group data, transforming your spreadsheets into well-ordered treasures of information. â€¢
Unlocking the Magic of Functions: Unravel the mysteries behind Excel's most valuable functions, from logical conditions to lookup magic. â€¢
Connecting and Transforming Data: Dive into advanced territory with Power Query and live SQL connections, elevating your data analysis skills. â€¢
Practical, Real-world Exercises: Apply your learning through guided exercises that mimic real-world scenarios, ensuring your newfound skills are actionable.
By the end of this course, you'll not only excel in your daily tasks but also be equipped to make data-driven decisions, analyze trends, and draw actionable conclusions. This course isn't about turning you into a spreadsheet robotâ€“ it's about equipping you with the tools and confidence to excel in your career.
Who this course is for:
Anyone who wants to advance their Excel skills to learn the foundations of working with data
People who want to start learning data science and want an approachable, understandable foundation to the skillset
Students and teachers who need to advance their Excel knowledge
People who want to be more competitive in the contemporary job market

User Reviews

Rating

average 0

Total votes0

Focused display

Dollar Design School is a streaming video network that teaches digital skills such as web development, graphic design, and digital productivity. We believe that education should be accessible to all. You can find Tech Learning Network content on Udemy, our website, and throughout the online video world.The Dollar Design School specializes in teaching accessible technical skills to people just getting started in technical careers, including web development, digital design, and other career paths enabled by technology.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.