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

Develop Super Focus and Boost Your Productivity! (Skillshare)

Business

Ask yourself: Does your mind often wander in the middle of conversations? Do you go to Facebook for just 5 minutes, but find yourself still on it 2 hours later? If your answer to these questions is yes, then this is the course for you! What if I told you that you could radically change all of this today?! You could have a razor sharp focus; You could be highly productive every single day; And most important of all: achieve all your goals.

Self Paced

Self-Paced

Business Productivity Motivation

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

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

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

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

Organise Anything and Get More Done With Airtable (Skillshare)

Business

Airtable is Trello (task management & Kanban), Google Calendar, Google sheets/Excel (spreadsheets) and Typeform (forms) all wrapped into one beautiful and easy to use tool. In this class, we'll learn how Airtable can help us organise anything and get more done. We'll start with the types of fields working with one table. Then, we'll explore different views - Kanban, Calendar & Form - that help us see our data differently.

Self Paced

Self-Paced

Spreadsheets Productivity Time Management

Skillshare

Tableau 10: Practical and Concise Part 1 (Skillshare)

Statistics & Data Analysis

So, you've heard a lot about Tableau 10, but you don't know how to get started? This Udemy course is exactly what you need! This course will teach you all the fundamentals you need. Trust me, you won't need any other course to reach the intermediate/advanced level after this course.

Self Paced

Self-Paced

Data Analysis Data Visualization Business Analytics

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

The 3-Day Weekend Apprentice - More Money & Free Time + Better Relationships Without Changing Jobs (Skillshare)

Personal and Professional Development

Move Towards a 3-Day Weekend / 4-Day Work Week Lifestyle without Changing Jobs. Make More Time for Your Favorite Relationships & Activities: Spend More Time with the People You Care About Most; Spend More Time Doing the Activities You Love Most; Stop Wasting Money on Unimportant Expenses; Enjoy Your Possessions More, But Spend Less

Self Paced

Self-Paced

Entrepreneurship Personal Development Productivity

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

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

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