Skillshare

Functional Excel Skills (Skillshare)

Offered by Skillshare,

This class is for people who use Excel everyday. It is aimed towards users who want to learn a few more functional skills. We will cover: Keyboard shortcuts; Absolute and Relative referencing, including when using Tables; Some useful formulas including VLookup and the new XLookup; Delimiters; Data Validation; Conditional Formatting; Dealing with raw data; Inserting Tables; Inserting Slicers; Nested IF Statements; OR Statements; AND Statements

Bonus Videos:

Using Logic to fill in missing values
Inserting rows beneath alternating rows

Viewer request:

Pivot Tables
Multi Column Comparison

New videos are uploaded occasionally, so please keep an eye out for updated content.
Please let me know if you have any requests about a particular feature of Excel you would like to know more about.
The class project is to follow along with the video. If you feel especially proud of your dashboard upon completion, please post a screenshot of it in the project section.
You can use the download to practice these skills and refer to them in the future.

Go to Class

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Skillshare

Intro to Digital Analytics - history, strategy, tactics, myths and much more! (Skillshare)

Marketing & Communication

Are you one of those people who added Google Analytics to your site months ago, but haven't been back to check your results since then? Or maybe you're one of those compulsive checkers who peeks at your Google Analytics data every hour or so, without ever doing anything based on the results? The same can be said of your follower count on Social Media or how many likes your latest post is getting. If you are not sure why people don’t seem to be coming to your site or why your advertising can’t bring in profitable traffic then this is the course for you.

Self Paced

Self-Paced

Marketing Entrepreneurship Business Intelligence

Skillshare

Free Class: Managing Creative Projects (Skillshare)

Personal and Professional Development

The first in a series of classes concerning 'creative productivity', or how creative individuals responsible for their own projects and deadlines can get things done without feeling overwhelmed. In this short class we will concentrate on a simple tool called a Kanban or Kanban chart, an idea that comes from the world of manufacturing, but that I think has real applicability for creatives.

Self Paced

Self-Paced

Productivity Project Management Creative Writing

Skillshare

How To Stay Employed In The Robotic Future (Skillshare)

Personal and Professional Development Business

Why do some people get a promotion while others get made redundant? What do they know that you don't? I believe that using technology and putting effort into the right things can help change a person's life forever, leading them to live a richer, healthier and happier life. For many though, the future has a lot of uncertainty in it with the unavoidable reality that many will lose their job to automation.

Self Paced

Self-Paced

Entrepreneurship Personal Development Productivity

Skillshare

Introduction -- Data Science and Machine Learning using Python - A Bootcamp (Skillshare)

CS: Programming Data Science

Greetings, I am so excited to learn that you have started your path to becoming a Data Scientist with my course. Data Scientist is in-demand and most satisfying career, where you will solve the most interesting problems and challenges in the world. Not only, you will earn average salary of over $100,000 p.a., you will also see the impact of your work around your, is not is amazing?

Self Paced

Self-Paced

Python Machine Learning Data Analysis

Skillshare

Easy Excel Basics for Beginners - Get Started with Excel (Skillshare)

CS: Programming

Learn Microsoft Excel basics from the beginning. Spreadsheets, shortcuts and formulas. Good for Excel 2010, 2013 & 2016. Learn the basics of Excel quickly and easily. This course is for you if you know that you need to get started learning Excel, but have just been too busy or felt too overwhelmed by the idea of studying.

Self Paced

Self-Paced

Excel Microsoft Microsoft Excel

Skillshare

5 Best To Do List Tips. (Try this) (Skillshare)

Management & Leadership Lifestyle

We've all been there...you have a lot to get done, and yet never seem to be able to accomplish it all. You struggle to check everything off your To Do list, and end up feeling bad when you can't get it all done. The never-ending To Do List is a drag. And you wish someone (maybe even this dog??) could just take care of it all for you.

Self Paced

Self-Paced

Productivity Leadership Time Management

Skillshare

Practical Excel Training - Basic Excel for Basic Bookkeeping (Skillshare)

Business

Basic Excel for Basic Bookkeeping - an introductory Class for those that are new to Excel and new to Bookkeeping or need a refresher class. In This Class You Will Learn The Basics Of Excel, The Very Basics of Bookkeeping, And How You Can Do Simple and Basic Bookkeeping in Excel.If you need to record basic transactions for your business. If you are new to Excel? Do you need an Excel Refresher course THEN REGISTER NOW

Self Paced

Self-Paced

Business Excel Productivity

Skillshare

Frameworks for High Performance - Class 1: Making Decisions Like A Boss (Skillshare)

Business

Are you looking to make a decision in the next 6-12 months concerning your career, relationships, or life? This course is for you if you are looking to decide whether to... Quit your job and start a business; Hire a new employee at your company; Move to a new city; Enter a more committed relationship; Invest money in a venture

Self Paced

Self-Paced

Business Entrepreneurship Productivity

Skillshare

Productivity with Evernote: Use One Tool for Everything (Skillshare)

Business

Unlock your productivity with Evernote in this short, straightforward class! Learn to use the ultimate productivity tool with Evernote Expert Lindsey Holmes. Whether you're a solo freelancer looking for one place to handle everything you do or a member of a large corporation looking to solve complex problems with simple solutions, this class will give you tools and techniques to manage every aspect of your work and personal productivity.

Self Paced

Self-Paced

Business Productivity Business Productivity

Skillshare

Ultimate Excel Course #1 - Excel Formulas Made Easy: Get Up to Speed with Excel Formulas Fast (Skillshare)

CS: Programming

When you first start to learn Excel, the formulas are always the most daunting aspect. This class will break through those barriers as it explains everything you need to know to get started with Excel formulas in plain English. In just 1 hour you will understand the different parts that make up a formula and will be able to write some typical formulas and functions.

Self Paced

Self-Paced

Excel Microsoft Excel Excel Formulas

Skillshare

Getting Started With Todoist (Skillshare)

Personal and Professional Development Business

Become better organised and more productive with one of the best productivity applications. Todoist is a simple to use, powerful to-do list manager available for all your digital devices. This course will show you how to set it up, use it and get the most out of it. Join millions of people today using Todoist. The top-ranked productivity app that helps millions of people organise life.

Self Paced

Self-Paced

Personal Development Productivity Time Management

Skillshare

Master Data Analysis with Python - Intro to Pandas (Skillshare)

CS: Programming

Master Data Analysis with Python - Intro to Pandas targets those who want to completely master doing data analysis with pandas. This course provides an introduction to the components of the two primary pandas objects, the DataFrame and Series, and how to select subsets of data from them. This course is taught by expert instructor Ted Petrou, author of the highly-rated book Pandas Cookbook.

Self Paced

Self-Paced

Technology Data Analysis Data Science