Excel for the Real World: Gain the Basic Skills of Microsoft Excel

Provided by:
0/10 stars
based on  9 reviews
Provided by:
Cost $8/mo
Start Date On demand
Excel for the Real World: Gain the Basic Skills of Microsoft Excel

Course Details

Cost

$8/mo

Skillshare offers a wide variety of free and Premium courses on creative skills, marketing and more.

Get One Month Free

Upcoming Schedule

  • On demand

Course Provider

Skillshare online courses
In Skillshare’s unique philosophy, everyone is a teacher, and everyone is a learner. Rather than a traditional lecture format, courses are offered within a global online learning community in which learners collaborate and learn by doing. Instructors are industry leaders who share their skills with anyone who wants to learn. No credits are offered. Founded by online entrepreneurs Michael Karnjanaprakorn and Malcolm Ong, Skillshare’s online “campus” was launched in April 2011. Its catalog h...
In Skillshare’s unique philosophy, everyone is a teacher, and everyone is a learner. Rather than a traditional lecture format, courses are offered within a global online learning community in which learners collaborate and learn by doing. Instructors are industry leaders who share their skills with anyone who wants to learn. No credits are offered. Founded by online entrepreneurs Michael Karnjanaprakorn and Malcolm Ong, Skillshare’s online “campus” was launched in April 2011. Its catalog has grown from 15 to more than 250 online courses that cover creative arts, entrepreneurship, branding and marketing, lifestyle and technology. The School of MakeOurMark, with courses in photography, illustration and tattooing, was launched in October 2013, and the School of Design went live the following month. Among the instructors who have taught courses are Seth Godin, founder of online marketing firm Yoyodyne, who teaches a class on entrepreneurship; DJ Young Guru, who leads a course on mixing and recording; and actor, writer and director James Franco, whose course focuses on screenwriting for short films. You can begin a Skillshare collaboration by taking an introductory course in a particular area to learn, for example, the fundamentals of Photoshop and expand your knowledge with a five-part, in-depth Photoshop series.

Provider Subject Specialization
Arts & Design
Business & Management
34 reviews

Course Description

Spend less time formatting and manipulating data, and more time presenting insights.

Microsoft Excel is an essential tool for organizing and understanding data about the world you live in! This is the first part of a 3-part series on learning to use Excel from the producers of KeyCuts. In this first class, Excel I, we will walk through the interface to help you become familiar with Excel. You will learn to navigate your way through all necessary functions of the software, understand practical applications, and gain the confidence to use it for your information needs. Whether you are new to Excel or are looking for a refresher on how to use Excel to analyze data, this class is for you. 

Learn by doing.

You'll follow along with me in the Excel for the Real World file I have provided under the "Your Project" tab (in this tab see the "Attached Files" section). Then, it's your turn to submit a project!...

Spend less time formatting and manipulating data, and more time presenting insights.

Microsoft Excel is an essential tool for organizing and understanding data about the world you live in! This is the first part of a 3-part series on learning to use Excel from the producers of KeyCuts. In this first class, Excel I, we will walk through the interface to help you become familiar with Excel. You will learn to navigate your way through all necessary functions of the software, understand practical applications, and gain the confidence to use it for your information needs. Whether you are new to Excel or are looking for a refresher on how to use Excel to analyze data, this class is for you. 

Learn by doing.

You'll follow along with me in the Excel for the Real World file I have provided under the "Your Project" tab (in this tab see the "Attached Files" section). Then, it's your turn to submit a project! Find some data from a project you are working on (or someone sent you some data in Excel) and filter/sort the data, write some formulas, and apply the techniques that data analysts use every day!

What You'll Learn

  • Using the Ribbon. Use the Ribbon to your advantage by clicking on different buttons and customizing the ribbon to fit your needs.
  • Structuring Your Workbook. We'll cover cells in a worksheet and how worksheets fit into a workbook.
  • Formatting. Get a little artsy in Excel!
  • Selecting Data. Select the data and smartly "autofill" data.
  • Writing Formulas. Write basic formulas and do a deep dive on the popular VLOOKUP formula.
  • Listing and Sorting. Organize your data so that it's easier to analyze.
  • Using Paste Special. We will see how the Paste Special menu lets you do things above and beyond copy-and-paste.

Also see: Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts, & Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint

Data drives all decisions, regardless of the business or industry you work on. You need to know how to organize it! Data is power! This Excel series will not only develop your technical skills, but also help you work with data in an efficient, smart way.

Note: The version of Excel used in this class is Max Excel 2011, but the concepts apply to both PC and Mac.

Reviews 0/10 stars
9 Reviews for Excel for the Real World: Gain the Basic Skills of Microsoft Excel

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

Sort By
Jennifer P. profile image
Jennifer P. profile image

Jennifer P.

None/10 starsCompleted
5 years, 9 months ago
Really great class. Some stuff I knew already, some I didn't. Was a good refresher
Was this review helpful? Yes0
 Flag
Jenny Dwenger profile image
Jenny Dwenger profile image

Jenny Dwenger

None/10 starsCompleted
5 years, 9 months ago
This is a great intro to Excel. Starts off sufficiently slow for even the most inexperienced user, but ramps up beyond the purely rudimentary. I have experience using Excel, but this was a good gap filler for some fundamentals I missed as a self-taught user.
Was this review helpful? Yes0
 Flag
Andrea Collins profile image
Andrea Collins profile image

Andrea Collins

None/10 starsCompleted
5 years, 9 months ago
I use excel everyday, but wanted to review this class to see if a coworker might benefit from it. The class is taught using Mac, so there are a few small differences in the way things look, not a problem if you are comfortable with computers and excel, but I think it would throw off the person I was reviewing it for. So I won't be recommending it to them - but I did learn a couple things I didn't know previously and will continue with the other 2 classes to see what else I can glean. The instruction is very well done, clear, easy to understand and well paced.
Was this review helpful? Yes0
 Flag
Brandon Touhey profile image
Brandon Touhey profile image

Brandon Touhey

None/10 starsCompleted
5 years, 9 months ago
I learned how to use Excel in high school but couldn't exactly remember all of the basics. Al's course was great in my opinion because it was taught in a way that would be extremely helpful to beginners in learning this application, while not alienating those (like myself) who wanted the course to act as a refresher. Because of this, I didn't feel guilty for not remembering things and was excited and surprised to still be learning new skills. In all, I'd recommend this to those who have no prior knowledge to moderate knowledge (and wanting to brush up on a few things).
Was this review helpful? Yes0
 Flag
Aubrey Houck profile image
Aubrey Houck profile image

Aubrey Houck

None/10 starsCompleted
5 years, 9 months ago
This class is taught at a very manageable pace, even for those just starting with Excel. The workbook helps keep you engaged, so don't skip it. While I'm comfortable using Excel, I figured this would be a good refresher and it was. It's a well thought out, well taught class and I would highly recommend it for the Excel beginner or if you've been out of the Excel game for a long time.
Was this review helpful? Yes0
 Flag
Ronen Kirsh profile image
Ronen Kirsh profile image

Ronen Kirsh

None/10 starsCompleted
5 years, 9 months ago
Good Class ! Very helpful and easy to understand.
Was this review helpful? Yes0
 Flag
Shane Clitheroe profile image
Shane Clitheroe profile image

Shane Clitheroe

None/10 starsCompleted
5 years, 9 months ago
Very simple and easy to understand course. I would recommend to any beginners who want to get started quickly and easily.
Was this review helpful? Yes0
 Flag
Terri Cirvello profile image
Terri Cirvello profile image

Terri Cirvello

None/10 starsCompleted
5 years, 9 months ago
This class is very user friendly! The information is well presented and easy to follow.
Was this review helpful? Yes0
 Flag
Lucas Garcia profile image
Lucas Garcia profile image

Lucas Garcia

None/10 starsCompleted
5 years, 9 months ago
Well explained, clear and simple. This module of the course is for Excel first day apprentices. I hope next modules will deepen more on Excel tools.
Was this review helpful? Yes0
 Flag

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.