Best Free Excel Expert Courses

Find the best online Free Excel Expert Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings.

Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user

Created by Dinesh Natarajan Mohan - Sharing simple but effective solutions

"]

Students: 378433, Price: Free

      Welcome to the Useful Excel for Beginners course. 

     In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply. 

     As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing. 

     The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours. 

Since this is a free course, Udemy does not offer certificates anymore.

Microsoft Excel Pivot Tables – The Beginner Course

Start analyzing data with Excel's most powerful data analysis tool, Pivot Tables. They're easier than you think!

Created by Matt Jackman - Digital Analytics and SEO Professional

"]

Students: 151181, Price: Free

What's this course about

Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they'll change the way you use Excel.

If you're not familiar with Pivot Tables, they're a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.

This is an introductory Pivot Table course and gives the information you'll need to start using Pivot Tables.

Who will benefit from this course

If you're somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.

You don't have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.

This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.

What you'll learn in this course

  • How to create a Pivot Table
  • How to summarize information in different ways using Pivot Tables

By the end of this course, you'll be able to take your own information and leverage Pivot Tables to answer questions with ease!

Excel Dashboards in an Hour

Learn how to create interactive Excel Dashboards in one hour. No special add-ins or tools required, just Excel.

Created by Mynda Treacy - Microsoft Excel MVP, Teaching 25,000+ Students

"]

Students: 131584, Price: Free

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. They can be created to summarize important information and are excellent for sharing a “snapshot" view among teams.

In this mini-course I’m going to teach you a handful of the most powerful techniques so you can get some fast results. I’ve taught this course in various forms and the feedback has been incredible. Here are just a few:

"10 minutes in and I feel like I can save hours" - Alex

"I consider myself quite good at Excel, but your mastery of it leaves me in the ashes. The dashboard presentation was dazzling." - Ben

"Wow! I am so excited to try this myself! Thank you so much for sharing your skills." - Lyn

Very dense information that in just one hour you represented what I have spent days reading books about this subject. - Khalid

"I've been using Excel for over 10 years and I'd like to take the time to say thank you. That was definitely one of the best courses I've ever taken.

It was
incredibly informative, insightful and taught me a few tips and tricks
that will surely aid me in producing automated dashboards. Thank you for
sharing the course materials.

Nothing short of excellent! " - Amanta

You too can master the creation of Interactive Excel Dashboards and learn to build Dashboard Reports from the ground up.

  • Design and Display Principles
  • Interactive Controls
  • Automating your Dashboard so it updates in seconds

Impressive Content that Will Provide Insight, Analysis and Alerts Dashboards are fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

Excel Dashboard students should have access to the PC version of Excel 2010 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel. Pivot Table and Chart knowledge is helpful, but expertise is not necessary to take this course.

Contents and Overview This course includes 9 lectures and just over 1 hour of content in order to give students a working knowledge of utilizing Excel to create interactive Excel Dashboards to communicate their data.

Included are the Excel Dashboard workbook and PowerPoint presentation from the course which contain notes on where you can find more resources. You can use the workbook to practice what you learn and as a quick reference guide later on.

The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep the report informative and relevant. Analyzing and automating information for a fully functional and complete dashboard. 

Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets, among a host of other tips that can be used in day to day Excel work.

Excel Quick Start Tutorial: 36 Minutes to Learn the Basics

Spark your skills in Excel! Go from a blank worksheet to pivot tables in 36 minutes. Great for interview prep!

Created by Jeff Knowlton - Senior Executive. Data Scientist. Teacher.

"]

Students: 119237, Price: Free

Here's what some students are saying about the course in the Reviews!

"Really concise quick summary and foundation in Excel" - Clare B.

"Instruction was very easy to follow. It was like having a friend show you what to do." - Patrick M.

"Very clear and easy to understand" - Fiona M

 "Great introduction to pivot tables and good examples too."  - John P. 

"Needed this to get ready for a new job, feeling more confident already!" - Daniel H.

"I have been using Excel for years but only in very specific ways. This course gave a good overview of major functions I have never used and didn't know existed. Will be making some accounting pivot charts right away." - Kyrie

The course is just 36 minutes - you can finish it over a lunch break! That’s how long it takes to complete the videos in this course, and come away with a strong understanding of the use of Excel in business. You’ll learn many of the important Excel functions: IF, VLOOKUP, pivot tables and charts, including line charts, column charts and 3D column charts. You’ll learn how to enter and edit data and formulas. How to format text and numbers. How to filter and sort large tables of data and calculate totals.

Only 36 minutes! How is this possible? I work through two business case studies on sales reporting and analysis, showing you how to use Excel to analyze data and answer questions, highlighting each step, and clearly explaining what I’m doing and why. You’ll learn how the functions work, and you’ll learn when, and why, to use them in business analytics. Full disclosure: plan for another 45 minutes or so to work through the case studies yourself. I provide all of the files. 

And it’s free! Even though free, it includes all of the features of the standard course: downloadable files, closed captions and quizzes, to help you learn and make it stick. 

This course is designed for people who are preparing for an interview. Starting a new office job. Looking to jump-start their career. And even for those people who are thinking about a longer Excel course, but who aren't sure that Excel is right for them. 

But let’s make something clear: you won’t be an expert. This course is a starting point, the first step on your journey to learn business analytics. It may be as far as you need to go. Let’s find out! Click the button “TAKE THIS COURSE” and get started. 

Excel for Accountants: Mapping Tables

Automate reporting tasks with a mapping table

Created by Jeff Lenning - Microsoft Certified Trainer

"]

Students: 86463, Price: Free

In this course, author and award-winning instructor Jeff Lenning CPA demonstrates the technique featured in his Journal of Accountancy article The Power of Mapping Tables. If you use Microsoft Excel to generate reports, this course is for you. We discuss the benefits of storing source data in tables, how to use the SUMIFS function to conditionally sum transactions, and how to translate labels with a mapping table.

Microsoft introduced tables in Excel 2007, and this feature is a game-changer. If you do not store your data in tables, you are missing out on a simple way to improve the reliability of your workbooks. Converting an ordinary range into a table provides many special benefits, and we'll discuss these special properties in the course.

Also with the roll-out of Excel 2007, Microsoft introduced a new worksheet function: SUMIFS. This too is a game-changer. Performing multiple-condition summing in earlier versions of Excel was challenging, and required clever functions such as SUMPRODUCT or array formulas. For many workbooks, these can be replaced with the SUMIFS function. We'll discuss the function's arguments and demonstrate several practical applications.

Excel reports often aggregate data. Frequently, the data labels are different than the report labels. For example, the accounting system may export account names, such as Cash or Savings, but the corresponding report labels are financial statement items, such as Cash and Cash Equivalents. When the labels are different, we are prevented from using lookup functions such as VLOOKUP to retrieve values. In this course, we'll demonstrate the mapping table technique which enables our reports to retrieve values from data tables, even when the labels are different.

The course includes practice Excel files, corresponding answers files, and a solutions video. The course is structured by topic, and within each topic, there is a PowerPoint discussion, a lecture video that works through the item in Microsoft Excel 2013 for Windows, and sample exercises for you to work hands-on. If you use Excel to create reports, this course will help you prepare them more quickly.

Excel Formulas and Functions with Excel Formulas Cheat Sheet

Learn Excel formulas and functions from scratch. Download Excel formulas and functions cheat sheet for your daily use.

Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst

"]

Students: 84646, Price: Free

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Formulas and worksheet functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating and obtaining useful information and insight from your data.

Without formulas and functions, Excel spreadsheet is simply a fancy word-processing document. Welcome to my Excel Formulas and Functions for Beginners course!

I designed this course for beginner level Excel users. But are you an intermediate level Excel user? Want to have a broader, deeper and in-depth knowledge in building Excel formulas and functions? This course is also for you!

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly more than 15,000 Excel users visit my Excel blog ExcelDemy and read my Excel and data related articles and tutorials.

Let’s discuss now what you will learn from this course.

  1. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them very details.
  2. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the formulas using Insert Function and Function Arguments dialog box.
  3. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your Finance related jobs. So this function is covered in details at the start of the course.
  4. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.
  5. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.  
  6. Circular Referencing: Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with formulas, and so on.
  7. DATEDIF() and Date related Excel Functions: And I will finish this course with DATEDIF () and other Date related Excel functions!

I am assuring you that what you will learn in this crash course is priceless. I designed this course keeping in mind, to give you a solid base in Excel formulas and function. Thanks for watching. Enjoy the course!

Best Online Excel Training | Best Shortcuts in 30 mins.

Quick useful guide to learn Excel Shortcuts (Save time & Money) [Excel 2007 - Excel -2019]

Created by Yoda Learning - Data Analyst |MS Office Expert & PMP | Instructor/Programmer

"]

Students: 69683, Price: Free

The list of 1000s of Excel shortcut keys are NOT to be memorized. It will torture your grey cells! So we have used industry practices and our Ninja Instructor's experience to handpick those shortcut keys which will meet your work requirements, make you look like an accomplished Excel Ninja.

This course is best suited for MS Excel 2007-2019 (Windows PC).

Not suited for Mac.

The best part is you can learn them in 30 minutes and start showing off at your office. Join now for a Complete No-Nonsense Course on Excel Shortcuts.

Ten Excel Features Every Analyst Should Know

A collections of tools that should be in every analysts toolbox

Created by John MacDougall - Microsoft Excel MVP

"]

Students: 69241, Price: Free

In this course we will learn about some awesome Excel features and how to use them with some examples commonly encountered by every analyst. 

  1. Text to Column
  2. Flash Fill
  3. Recording a Macro
  4. Grouping Sheet
  5. Deleting Blank Rows
  6. Remove Duplicate Data
  7. Auto Sum
  8. Filling a Range with Ctrl + Enter
  9. 3D Sums
  10. Advanced Filters

Bonus: Conditional Formatting

These tools should be in every analysts toolbox and will save you a lot of time and effort if you know how to use them should the need arise.

MS Excel – From 0 to Working Professional in 1 hour

Learn Excel as fast as possible

Created by Jason Zhang - Financial Analyst

"]

Students: 65003, Price: Free

This course covers Excel basics in the way that's very short and concise. You may use Excel before but this course shows you a better way of using these functions in real work environment. If you are going back to workforce, or looking for jobs, this is the fastest way to refresh your skill or Jump Start your skills. Within 1 hour, you can use Excel the way a working professional would use.  

This course IS NOT for everyone because of 2 things

1. Excel is powerful. Microsoft tries to make Excel as relevant to anyone as possible. However, each occupation use Excel differently. I've no idea how scientists or engineers use Excel. But I know how working professionals, especially analysts use Excel. I've worked as Business Analyst, Market Analyst, and till this day a full time Financial Analyst. Excel changed my life, I get hired, get promoted because that. I hope more people can do the same and better.

2. The pace of the course is super fast. If you like things go slowly, this is NOT for you. This course covers basic Excel. Most of the things in this course should be learnt by doing. Therefore I have enclosed a downloadable workbook. You can see me demonstrating on the left side of the sheet, while you would be practicing on the right.  

Microsoft Excel – Improve your skills quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more - in just a couple of hours

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 49142, Price: Free

Welcome to this course about Microsoft Excel.

A lot of people use some of the features in Excel and just muddle through - not many use all of the functions.

In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.

  • Learn more about formatting, filters and conditional formatting.
  • Create tables, PivotTables, Chart, PivotCharts and Sparklines.
  • Find out how powerful Visual Basic for Applications (VBA) is.
  • And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT - translated into 15 different languages.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features - and you'll find out how much more you can learn.

Excel: From beginner to intermediate

Learn the skills that Microsoft want you to know in Excel.

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 42093, Price: Free

What do others like you think of this course?

"Prior to doing this course Excel has always scared the heck out of me! I never expected to learn so much and am amazed by all the things that can be done using excel. It's so much more than just formulas! The course is really well presented and makes the whole learning experience comfortable and enjoyable. Thank you so much for putting together such a great course. I've already signed up to the intermediate to advanced excel course and I look forward to learning more about Microsoft Word in the future too... I imagine there are all orts of neat little tricks that I had no idea about!" -- Adam Shipley

"Phillip is a brilliant teacher of Excel . His explanations are clear , in-depth and very comprehensive" - xlongFx

"Awesome organization of course and well presented. I really loved the course. Of course as I am using excel for many years in work I was quite aware and using many features, but there are many details which helped me to polish my excel skills." - Manjunath Hirennavar

--------------------

In this 11 hour course, learn how to:

Create and manage worksheets and workbooks

  • Create and navigate in Excel worksheets and workbooks,

  • Format worksheets and workbooks,

  • Customize options and views, and

  • Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

  • Insert data into and format cells and ranges, and

  • Summarise and organize data in Excel .

Create tables

  • Create and manage tables,

  • Manage table styles and options, and

  • Filter and sort a table.

Perform operations with Excel formulas and functions

  • Summarize data,

  • Perform conditional operations, and

  • Format and modify text.

  • Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

  • Create charts,

  • Format graphic elements, and

  • Insert and format objects in Excel .

The course will take about 10 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

Free Basic Excel Course + Lookup Function

Excel made easy for everyone

Created by MKCL India - Creating a Knowledge Lit World

"]

Students: 41781, Price: Free

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives using pivot tables.

In this course you will be learning the basics which is required when you start working with Microsoft Excel. In today's time Microsoft Excel is one of the most important tool used in any organization. This course will definately help you to learn the basics with the practical use of it.

How to Transcribe and Excel In General Transcription

An Online General Transcription Course for Both Beginners and Experts.

Created by Team TCI - Transcribe Better, Earn Better.

"]

Students: 34888, Price: Free

This course, brought to you by Transcription Certification Institute, is about learning general transcription skills and increasing your work-from-home employment opportunities for 1000s of transcription companies worldwide; and earning $10 to $35 per hour depending on your skills. Flexible hours of this profession allows you to work as much as you want and whenever you want.

1000s of transcription companies are outsourcing transcription projects to contractors all over the globe every day. These companies are competing for good transcribers because of the shortage of trained transcribers. All you require is proper training, a good ear for listening, good command of English language, desktop with high speed internet, and awareness of what is happening in the world to succeed in this profession. Higher level of familiarity with legal, academic or medical terms could result in higher paid work.

The course material here is quite similar to the much acclaimed TCI general transcription certification course, though it's is just a  part of it. This 45 minutes course is divided into 8 lectures that include the details about transcription, punctuation, parts of speech, transcribing accented audios and much more. Invest about an hour to find out if you can start earning $10 to $35 per hour working from the comfort of your home

Introduction to Microsoft Excel 2010

Learn the basics of using Microsoft Excel 2010

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 34335, Price: Free

During this introductory course on using Microsoft Excel 2010, we'll teach the basics of using Microsoft Excel 2010.

Your professional instructor will talk you through Excel 2010's features, starting with the basics, from creating files to editing existing documents. You'll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents.


The course is designed for individuals and office professionals who need to learn the basics of Microsoft Excel 2010.

Excel Data Visualization for Business Analysts

Become an expert in data visualization using Excel as your canvas. Go past basic Excel charts to up your data vis game.

Created by Excel TV - Excel MVPs, Authors and Bloggers

"]

Students: 19847, Price: Free

Master Data Visualization Using Microsoft Excel

Whether you've just started working in Excel or you've been using it forever, chances are you've heard about data visualization and understand how important is. More than that, you've probably made a few charts you were proud of.

I was there, too. I could make any basic Excel chart my boss asked for. But I knew my charts - and many of those that I saw presented - did a poor job communicating data. Looking back, I think I was being asked to make charts just so we would have more to present.

Sound familiar? I've been where you are.

So I wanted to create a data visualization course for the business analysts who work with a lot of data and use Microsoft Excel regularly within their workflows. Chances are - you can already create a bar chart, a pie chart, and more. If that's you, read on.

Because I think a course for people like us has been missing. So I decided to distill everything I knew into a course that shows:

  • The important research behind which charts show the best information.

    That way you're always communicating the best results. And when your boss challenges you, you can point to the research. (Just point him or her to the module on why Pie Charts are the worst!)

  • How to create advanced charts not included in Excel.

    Most business problems can't be captured in Excel's native chart library. Do you know how to create Bullet Charts? Charts with multiple banding? This course will show you how.

  • How to create charts for analysis and how to create charts to tell a story.

    In this course, we'll talk about the difference between data graphics and info graphics. The former is for investigation, the latter for narration. You won't find this content elsewhere - I know, because I came up with it organically while working as a management consultant.

  • How to layout your charts and info graphics when you deliver them to executives.

    I'll introduce you to the camera tool, one of Excel's most powerful features. You'll see how it will allow you to drag-and-drop a chart, much like in Power BI.

  • Labs and Quizzes

    It's not enough to learn this information. You need to apply. I have created labs and quizzes based on the content. Take the quizzes to reinforce your knowledge. Complete the labs and then use them immediately in your own work.

  • No VBA or Macros

    I love VBA and Macros too but they're way over deployed. In many cases, the advanced chart you're thinking of making doesn't need lines and lines of code. I'll show you how quickly.

Here's what you can look forward to in this course: 

  • Data visualization principles including closure, proximity, common group and preattentive attributes

  • Theory and practice for why data visualization is so important

  • Why 3d charts cause issues when communicating data

  • Problems pie charts present to the audience

  • How to create charts with graded banding in Excel

  • How to create Bullet Charts in Excel

  • How to create Progress Meter Charts in Excel

  • How to create Waffle Charts in Excel

  • Microsoft Excel's camera tool

  • Resources to help you continue your learning

Like you, I work in the trenches, hustling to solve every new data challenge that comes my way. I wanted to create a course for people like me to learn from. If you want to stand out in the crowd and take your Excel and data skills to a whole new level, then you're the person I created this course for.

See you there,

Jordan

Lookup Functions, Advanced Charts and Pivot tables

Excel charts and pivotes made it easy

Created by MKCL India - Creating a Knowledge Lit World

"]

Students: 11553, Price: Free

Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. After you enroll and complete this course, you will be proficient in all kinds of charts in Excel: Bar Charts, Column Charts, Line Charts, Pie Charts, Area Charts, X Y Scatter Charts, Bubble Charts. You will be able not only to create these charts in Excel, but also to format them quickly and easily.

This course also provides an in-depth coverage of pivot tables and pivot charts. These are two of the powerful data analysis tools in Excel's arsenal, and they should definitely be mastered by anyone who aspires to becoming an Excel “power user. Pivot Tables and Pivot Charts allow you to dynamically reorganize and display your data in many different ways and they help you get meaningful information from large amounts of data.   

Excel Beginners Training From Scratch

Learn to master Microsoft Excel with easy to follow step-by-step lessons using practical case studies and projects.

Created by Abhijat Saraswat - Instructor

"]

Students: 8862, Price: Free

The Excel beginners training from scratch course will introduce you to the industry standard and popular spreadsheet software. This Excel training course is perfect for those wanting to learn Excel from the very beginning and you will become comfortable using some of the core features that Excel has to offer.

The course will introduce you to a number of features, tool and techniques of Excel and is perfect for students, entrepreneurs, housewives, business owners, professionals or anyone else looking to learn Excel. By the end of the course you will have mastered the basics of Excel and will be able to manage workbooks, use formatting, perform calculations, use formulas and create charts.

This is a hands-on beginners Excel course and you will learn by watching the instructor as he describes each action as he performs it. The course takes a project based approach, which means that you will be able to practice as you are learn and by the end of the course you will even complete a project from beginning to end – creating a fully functional budgeting spreadsheet with charts, formulas and a host of other features.

Note: The instructor uses Excel 2010 to teach the course, but the course should be suitable for those with Excel 2007 onwards. There are some differences in the menu structure if you are using Excel 2013.

Instructor: Abhijat Saraswat (Ab)

The course is taught by Ab, who is an Excel whizz and has been using Excel for over 10 years, since Excel 95. He uses Excel almost on a daily basis and has taught Excel to a large number of students including executives of large organisations, small business owners and entrepreneurs.

Learn Microsoft Excel Charts (Basic to Advanced)

Create awesome charts in Microsoft Excel

Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

"]

Students: 6372, Price: Free

Learn to create awesome charts in Microsoft Excel. In Microsoft Excel, a chart is often called a graph. It is a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface, or Radar charts. With Excel, it is easy to create a chart.

Microsoft Excel – Mastering Data in Excel For Beginners

Master Data in Excel from a self confessed Microsoft Excel fanatic (Windows Excel 2007 to Excel 2019)

Created by Keith Griggs - Excel Trainer and Fanatic

"]

Students: 2725, Price: Free

Welcome to my Mastering Data in Excel course.

You will learn the fundamentals of working with data, which really is the whole point of Excel.

I used the Windows version of Excel current in 2020 to make this course, but other versions should not be that different.

I will be creating a spreadsheet during the course that you can download. The idea is that you work along with me, then you can compare our spreadsheets. This is the very best way to learn.

I love Excel, and I hope to share my passion and enthusiasm for this amazing software onto you, as well as passing on all my skill and knowledge. Pretty soon you will be using Excel like a master, and you will save yourself so much time, as well as look like a genius!

In this course I cover:

  • Creating a table of data

  • How to filter

  • How to automatically format a table with filters

  • How to find duplicates

  • How to split cells into columns

  • How to merge columns together

  • How to search and replace text in Excel

  • How to calculate a percentage increase.

I hope that you love this course and get a lot out of it.

Happy Excelling!

Keith

Microsoft Excel – Excel from Beginner to Advanced Level.

Learn Excel from A - Z with excel 2019.

Created by Niraj Kumar Singh - Digital Mentor & Internet Marketer

"]

Students: 1838, Price: Free

This course is meant for those who need Excel training from the very beginning. I will help you build confidence in using Excel to its full potential and provide you with the skills to navigate Excel efficiently. By the end of the course, you will be able to use Excel without facing any problems. Excel is one of the most powerful software tools ever built. Excel is used by the whole world whether it's a grocery shop, college, school, university or big business office. You will immediately create value for your own organization or your employer by learning the Excel skills taught in this course. I hope you will learn and enjoy it.

What you will get in this course?

  1. Launching Excel

  2. Introduction to the Excel interface

  3. Saving Excel File

  4. Important File Types

  5. Opening an existing excel document

  6. Adding, Modifying and deleting data in cells

  7. Creating and naming of a new worksheet

  8. Common Excel Short Cut Keys

  9. Add / Subtract/ Multiply / Divide

  10. Use of Cut & Paste using Cells

  11. Moving and Copying Data in an Excel Worksheet

  12. Inserting  Rows and Columns

  13. Deleting an Excel Worksheet

  14. The easy way of creating a chart

  15. Important charts and Best Practices

  16. All types of Chart

  17. Printing an Excel Worksheet

  18. Printing a Specific Range of Cells

  19. Pivot Table

  20. And many more coming soon.

I request you to practice to master it. You can only become a master if you use this software.