YoVDO

Microsoft Excel Beginner & Intermediate Training w/ Projects

Offered By: Udemy

Tags

Microsoft Excel Courses Data Manipulation Courses Data Management Courses

Course Description

Overview

A Beginners and Intermediate Guide to Using Microsoft Excel in the Real World

What you'll learn:
  • Create, modify, and delete worksheets
  • Create, manage, and format complex Excel workbooks
  • Understand and employ special views and features within Microsoft Excel worksheets
  • Enter, edit, organize, and manipulate data
  • Use common formulas and functions
  • Create charts, tables, filters, and other useful tools in Excel
  • Sort, dissect, remove, re-aggregate sets and subsets of data
  • Create compelling visual presentations of your data
  • Create own unique problem sets to practice with
  • Use Microsoft Excel to solve real-world problems
  • Understand possible next steps to continue building own skills in Microsoft Excel

Course Highlights:

  • 80+ Individual, Bite-Sized Lessons

  • 9 Real-World Mini-Projects

  • Course PDF & Road Map

  • Verifiable Certificate of Completion

  • Downloadable Excel Files & Corresponding Project Files

  • Instant Access to Instructor and the ProductivityMe Community

  • Regular Course Updates and Bonus Materials Provided


A Bit More Information:

Hi there,

And welcome to our course page!

You must be interested in Microsoft Excel, or learning it. YAY! Ryan and I are super excited to have you here, we’re honored that you’ve taken a minute out of your day to read this far.

Microsoft Excel is an amazing application. You can do fun and important things with Excel. Whether you’re working in finance, consulting, non-profits, or even still in school, Microsoft Excel is the industry standard for organizing, analyzing, manipulating, and storing data in tabular form.

Why Learn Excel?

Microsoft Excel is the world’s most popular spreadsheet program. Learning it can be frustrating (or at least it was for me).

Maybe you have a small business, and you need to learn Excel for tracking your sales. Maybe you want to work at a startup, boutique marketing firm, or investment bank... Maybe you're a recent graduate apply for an analyst job at a Fortune 500,,,, Or maybe you're like me and you want to be able to do more in less time, perhaps get a raise or job promotion.

Knowing how to use Excel to solve real-world problems can be an awesome tool to help differentiate you from the competition!

In this Course:

Learning Excel takes time, particularly if you try to do it without any structure!

In this course, we'll talk you through the basics from how to create a spreadsheet, to how to sort and filter your data in tables, even create charts and use awesome tools like Sparklines and Flash Fill!

In this training course, we’ve broken down Microsoft Excel into ten main sections:

  1. Getting Started with Excel

  2. Entering Data

  3. Formulas and Functions

  4. Formatting & Presenting Data

  5. Database Features

  6. Using Tables

  7. Charts & Graphs

  8. Modifying & Adjusting Data

  9. Using Special View Features within Workbooks

  10. Managing Worksheets within a Workbook

About our approach:

We want you to succeed! Ryan and I have worked hard to create awesome and amazing content, but, perhaps more importantly, to create and cultivate a vibrant community around sharing and improving that content (i.e., content on how to best learn Microsoft Excel).

Maybe you like doing things on your own. Watch a video, and then go off and tinker with your own workbooks. Maybe you like following along. Open up your spreadsheet, and move through each lesson step-by-step with us. Maybe you just want to learn about the sorting feature within Tables, well then jump right to lecture 64! There’s no right way to learn Excel, well, except for well, actually starting…

In each section, we walk you through thecore componentsof the skills and techniques that you need to use Microsoft Excel in the real-world.

Each lesson will cover one single topic, delivered in a shortbite-sized video.

At the end of each section we’ll do a smallproject, in which you can apply the core skills that you’ve learned in the section.

We've made it easy to follow along with the course, by providing acourse PDF, and for those of you interested- feel free to download thecourse Exercise and Project files.

So...

If you have questions, comments, ideas, we’d love to hear from you.

Email or message us any time.

Cheers,


Tolan & Ryan
ProductivityMe Co-Founders Udemy Instructors & All-Around Good Guys


Taught by

The ProductivityMe Company

Related Courses

Advanced Clinical Data Science
University of Colorado System via Coursera
Advanced Features with Relational Database Tables Using SQLiteStudio
Coursera Project Network via Coursera
Amazon DynamoDB Service Primer (Indonesian)
Amazon Web Services via AWS Skill Builder
Amazon DynamoDB Service Primer (Japanese)
Amazon Web Services via AWS Skill Builder
Amazon DynamoDB Service Primer (Spanish)
Amazon Web Services via AWS Skill Builder