All Tutorials Excel Tutorials

Excel formulas and data operations

Excel formulas and data operations
Excel formulas and data operations

Excel formulas and data operations

The most important parts of Excel are:

What you’ll learn

Excel formulas and data operations

  • I made the course so that each person could do all the tasks on their own, even if they didn’t watch the video, and then check their work.
  • But if you’re new to Excel, there are full-length videos that show how formulas work and how to do certain things step by step.
  • The course is also a great way to learn more about how to make reports in Excel, like with Power Query, Power Pivot, dashboards, and more.
  • I made a video of the course in the form of challenges. Because of it, everyone will be able to find something they like.

Requirements

  • When I made the course in 2020, I used Office 365, but the formulas have been the same for years. A lot of different versions of Excel can be used to take the course: Excel 2007, 2010, 2013, 2016, 2019 and 365.
  • A few of the formulas that were talked about may not be in older versions of the book.

Description

Hi, I have been working with Excel for a long time, and every day I meet people who need to repeat the most important parts of Excel.
Because even though they often use a spreadsheet and have had some training, they think they only know part of what they need to know. So, the idea came up to do a good review of formulas and data operations.

I made the course so that each person could do all the tasks on their own, even if they didn’t watch the video, and then check their work. But if you’re new to Excel, there are full-length videos that show you how to do everything from formulas to tasks.

This course has 5 good reasons why you should take it.

  1. Repetition: I made a video of the course in the form of challenges. Using the tasks that have been set up will help you keep everything together and make it more likely that you’ll find what you’re looking for when you’re looking for it.
  2. There are a lot of different types of exercises. If you’re an expert, see if you can do them all by yourself.
  3. If you watch the videos, you will see each shortcut emphasized so that you can remember it and start using it right away to do things faster.
  4. Excel 365 now has new formulas. Many new formulas were used when I made the course in 2020. This means that I was able to work even faster than before. In addition, the course will be kept up to date with what’s new in Excel.
  5. You should go over the old parts of Excel first if you want to learn about new things in Excel. Before you get into the world of Power Query, where many transformations look a lot like Excel formulas.

Who this course is for:

  • The course is for both people who are new to Excel and people who are more skilled with it.
  • The course starts with the basics, and then I go over all of the formulas in great depth.
  • A lesson on Excel 365 can only be found if you want to learn about what’s new.

Excel formulas and data operations CourseForFree.net

HTML5 Canvas Ultimate Guide

Download Now

Advertisement

Categories