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

My Financial Mountain: Understanding Your Path to a Solid Financial Foundation (Skillshare)

Personal and Professional Development

This course is a general guide to solid personal finances.... The course will guide you on a very realistic path to financial stability freedom. If you have financial difficulties, if you want to know more about your personal finances, if you want a method to follow and reach financial stability... this course is for you.

Self Paced

Self-Paced

Personal Development Productivity Personal Finance

Skillshare

The Beginners Guide To Getting Organised (Skillshare)

Lifestyle

This course has been created to help anyone who wants to get themselves better organised but have no idea where to start. This course covers all the basics you need to know to begin the process of getting your stuff together so your productivity shoots through the roof and you start to feel less stressed and overwhelmed.

Self Paced

Self-Paced

Productivity Lifestyle Organisation

Skillshare

Microsoft Excel_PivotTables Part 1 (Skillshare)

Statistics & Data Analysis

Hello! This part of My Microsoft Excel series of courses focuses on the PivotTable part. PivotTables are very powerful tools inside MS Excel allows us to analyse huge datasets in a very efficient and short time. This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide.

Self Paced

Self-Paced

Excel Microsoft Excel Microsoft Office

Skillshare

Create a Perfect Morning Routine (Skillshare)

Lifestyle

My name is Jeff Finley, I'm a freelance illustrator and designer. Despite outward signs of success, I was struggling internally with anxiety, depression, and self-doubt. I decided to start waking up early to focus on doing things that made me happy and fulfilled. Little did I know that this would transform my life! I ended up writing a book about my year of waking up early. It's a book about habit change, personal growth, and morning routines.

Self Paced

Self-Paced

Productivity Lifestyle Healthy Lifestyle

Skillshare

Beginner friendly SQL course using MySQL for 2020 (Skillshare)

CS: Software Engineering

A beginner friendly SQL class. This course has a database for you to set up so you can follow along and get the best experience! Do not worry I will go over how to set this up as well! This course will be broken down into two halves.

Self Paced

Self-Paced

SQL Data Analysis Web Development

Skillshare

The Advanced Habits MasterClass (Skillshare)

Personal and Professional Development

Habits shape who we are as people. They shape our health, wealth, as well as our happiness. In this course, you will learn how habits work and how you can work on controlling them and implementing new healthy habits. We will be going through some principles and ideas that you can implement immediately to start changing your habits and turn them around the way you want it. Get ready to change yourself and change your life.

Self Paced

Self-Paced

Personal Development Productivity Lifestyle

Skillshare

Productivity Habits That Stick: Using Time Theming (Skillshare)

Personal and Professional Development

Learn time theming to build a productivity system that will last a lifetime. Join Productivityist founder Mike Vardy as he shares how creating a simple, flexible, durable productivity system will transform the way you work. Whether you’re a freelancer balancing multiple gigs or a 9-5er with a calendar full of meetings, this class will give you the tools you need to create helpful habits for work and home that will actually stick.

Self Paced

Self-Paced

Productivity Productivity Solutions Workflows

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

Memory Mastery: Improve Your Everyday Memory (Skillshare)

Lifestyle

Does reading slow you down? With the mountains of growing information you face daily, the ability to read 2, 3 and even 4 times faster with comprehension is a vital skill. The Speed Reading Mastery online course will help you save valuable time and stay ahead as you read faster with greater focus, comprehension, and retention. Imagine if you could learn that language you’ve always wanted to speak, master an instrument or simply read the unread books on your bookshelf.

Self Paced

Self-Paced

Personal Development Productivity Lifestyle

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

Skillshare

Entrepreneur Mindset: Productivity and Procrastination (Skillshare)

Business

Yes, we have all been there, trying to accomplish something... But procrastination and lack of organization prevents us from getting where we want to go. If you are here, it is likely that you had some problems so far to motivate yourself doing what you want. After having helped dozens of people with NLP and Hypnosis, I came to a point where I could define exactly what were the missing points.

Self Paced

Self-Paced

Business Entrepreneurship Productivity

Skillshare

FREE e-Learning Sources That Are Worth Your Time (Skillshare)

Lifestyle

These days we are so overwhelmed with information from all around us. It's impossible to watch, listen or learn every new published piece of information. You have to choose some of them and give them your most precious commodity in the world - TIME.

Self Paced

Self-Paced

E-learning Reading Productivity