Spreadsheets For Beginners: Master Your Data Game
Spreadsheets For Beginners: Master Your Data Game
Published 5/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English
| Size: 2.76 GB[/center]
| Duration: 4h 19m
Learn how to work with Spreadsheet software (Google Sheets and Excel) completely from scratch
What you'll learn
Learn how to manipulate spreadsheets using Google Sheets
Use Spreadsheet formulas
Analyze data with Spreadsheets
Do complex calculations using Spreadsheets (mathematical calculations) and aggregate formulas
Learn how VLOOKUPs, RANGE and INDEX Work
Do plots with Spreadsheets
Learn how to Analyze Real Data with Excel
Sorting and Filtering Data
Requirements
No prior experience in Spreadsheets Needed
A gmail account to use Google Sheets
Description
Do you feel lost when you pick up spreadsheet software like Microsoft Excel or Google Sheets? Have you ever seen an advanced Excel user work and wish you could know how those complex formulas work?Then this course is for you!Unlock the full potential of spreadsheet tools like Google Sheets and Microsoft Excel with this comprehensive course designed for beginners and intermediate learners alike. From building a strong foundation in spreadsheet basics to diving into advanced data analysis techniques, this course gives you with the skills needed to excel in various professional and personal contexts.What We'll Learn Together:Foundations: Dive into spreadsheet essentials, from navigating the interface to creating and formatting tables effortlessly.Formulas and Functions: Learn the power of formulas and functions to automate calculations and streamline data analysis tasks.Real-world Applications: Apply your skills to real-world scenarios, such as analyzing eBay sales data and conducting United States Census exercises in the practical exercises.Data Management: Learn techniques for sorting, filtering, and visualizing data to gain valuable insights and make informed decisions.Advanced Techniques: Master advanced functions like VLOOKUP, INDEX + MATCH, and pivot tables to take your spreadsheet skills to the next level.Why Choose Our Course:Expert Instruction: Benefit from expert-led lectures, practical exercises, and quizzes designed to reinforce your learning.Hands-on Experience: Gain hands-on experience with practical exercises and real-world case studies, ensuring you're prepared to tackle any spreadsheet challenge.Flexible Learning: Study at your own pace with our flexible online platform, accessible anytime, anywhere, and on any device.Career Enhancement: Enhance your resume and professional skill set with in-demand spreadsheet skills sought after by employers across industries.Who Should Enroll:Professionals seeking to enhance their data analysis skills.Students preparing for careers in business, finance, or analytics.Anyone looking to streamline workflow and improve productivity with spreadsheet tools.Join Us Today and Master the Art of Spreadsheets!Enroll now to embark on a journey towards spreadsheet mastery and unlock a world of opportunities in data analysis, decision-making, and beyond. And remember, you can benefit from Udemy 30-day risk free refund policy if the course does not match your expectations.intro music credits: bedtime after a coffee by Barradeen | barradeen Creative Commons Attribution-ShareAlike 3.0
Overview
Section 1: Introduction
Lecture 1 Welcome to the Course!
Lecture 2 Using the Udemy Platform Playback Speed
Lecture 3 Course Materials
Section 2: Spreadsheet Basics
Lecture 4 Starting a New Google Sheets File
Lecture 5 Introduction to the Spreadsheet - Rows and Columns
Lecture 6 Introduction to the Tabular Format - Our First Data Input
Lecture 7 Creating and Formatting Tables with Microsoft Excel
Lecture 8 Working with Multiple Worksheets and Opening Files
Lecture 9 Saving Google Sheets and Microsoft Excel Files
Section 3: Introduction to Worksheet Formulas
Lecture 10 Introduction to Formulas and Simple Calculations
Lecture 11 Taking Advantage of Relative References
Lecture 12 Absolute References
Lecture 13 Introduction to Spreadsheet Functions : SUM Example
Lecture 14 Minimum and Maximum Functions
Lecture 15 Obtaining data from other Worksheets and SUMIF Function
Lecture 16 COUNT and COUNTIF
Lecture 17 [Extra] - Selecting cells from other Worksheets in Microsoft Excel
Section 4: Ebay Analyst Exercise
Lecture 18 Ebay Analyst Exercise
Lecture 19 Ebay Analyst Exercise Tasks
Section 5: Formatting and Styling Worksheets
Lecture 20 Introduction to Number Formatting, Rounding and Percentage
Lecture 21 Formatting Dates
Lecture 22 Formatting Text (Font Size, Bold, Italic, etc.)
Lecture 23 Formatting and Styling Cells
Lecture 24 More on Cell and Text Formatting
Lecture 25 Merging Cells
Lecture 26 Conditional Formatting
Lecture 27 Formatting Menus in Excel
Section 6: United States Census Exercise
Lecture 28 United States Census Exercise
Lecture 29 United States Census Exercise Tasks
Section 7: Data Management
Lecture 30 Sorting Data
Lecture 31 Introduction to Filters
Lecture 32 Introduction to Plotting
Lecture 33 Data Validation
Lecture 34 IF and IFERROR
Lecture 35 Understanding Pivot Tables
Section 8: Airbnb Analyst - Exercise
Lecture 36 Airbnb Analyst Exercise
Lecture 37 Airbnb Analyst Exercise Tasks
Section 9: More on Functions!
Lecture 38 UNIQUE Function
Lecture 39 VLOOKUP
Lecture 40 INDEX + MATCH
Lecture 41 AND + OR
Section 10: Course Ending
Lecture 42 Thank you!
Lecture 43 BONUS LECTURE and Other Resources
Aspiring Data Analysts,Financial Analysts,Marketing Analysts,Self Employed People,Basically, everyone that needs to work with spreadsheets and want to learn it from scratch
https://fikper.com/q4jmgVCwow/.Spreadsheets.for.Beginners.-.Master.your.Data.Game.part1.rar.html
https://fikper.com/0ndf7luYdJ/.Spreadsheets.for.Beginners.-.Master.your.Data.Game.part2.rar.html
https://fikper.com/7ikK1Re3qh/.Spreadsheets.for.Beginners.-.Master.your.Data.Game.part3.rar.html
https://rapidgator.net/file/2a5ff7d6138a1bd7cd921a0c0904eec7/.Spreadsheets.for.Beginners.-.Master.your.Data.Game.part1.rar
https://rapidgator.net/file/fb284c25442c56b7b76bd76182eeaea7/.Spreadsheets.for.Beginners.-.Master.your.Data.Game.part2.rar
https://rapidgator.net/file/ea0e26cc5381ae98be9013f43ee508d2/.Spreadsheets.for.Beginners.-.Master.your.Data.Game.part3.rar