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.
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Text to Column
- Flash Fill
- Recording a Macro
- Grouping Sheet
- Deleting Blank Rows
- Remove Duplicate Data
- Auto Sum
- Filling a Range with Ctrl + Enter
- 3D Sums
- 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.
Boost Your Excel Skills: Crash Course w/ Downloadable Files
Microsoft Excel: Hone Core Skills in Microsoft Excel in 1+ Hours (Downloadable Excel Files Included in Course)
Created by The ProductivityMe Company - Excel Tips, Tricks, & Tutorials, One Lesson at a Time.
Students: 59750, Price: Free
- 10 Individual, Bite-Sized Lessons
- Downloadable Excel Files
- Verifiable Certificate of Completion
- Instant Access to Instructor and the ProductivityMe Community
- 1080p HD Quality Video
In this Course:
Learning Excel takes time, particularly if you try to do it without any structure!
In this course, we'll walk you through the top ten skills you need to know in order to excel in Microsoft Excel!
Give us an hour, and we’ll help you to get to the next level of mastery in Microsoft Excel.
In this short, easy-to-follow training course...
- The Quick Access Toolbar
- The Shortcut Menu & The Mini-Toolbar
- The Quick Analysis Tool
- The Fill Handle
- Flash Fill
- Charts & Graphs
- Recommended Charts
- Sorting & Filters
At the end of each video, you have the chance to prove your mastery by completing a small practice exercise thus testing the core skill that you’ve just learned.
You can easily follow along in each lesson by using the downloadable course exercise files provided in Lecture 2.
If you have questions, comments, ideas, we’d love to hear from you. Email or message us any time.
Alright, that’s it for now.
Look forward to having you in class!
Tolan & Ryan
Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel
Pivot Tables in Excel 2016. Learn to create basic Pivot Tables in Excel 2016 with real-life examples.
Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst
Students: 54092, 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
Welcome to my “Excel 2016 Pivot Table” course where you will learn how to create basic pivot tables.
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 around 15,000 Excel users come to my Excel blog and read my Excel and data analysis related articles and tutorials.
At the end of this course:
- You will be able to create and update basic pivot table reports using Excel 2016,
- You will be able to realize, why and when you can best use of Excel Pivot Table tool,
- You will be get used to with the features of an Excel Pivot Table Report
- And you will be able to handle the limitations and compatibility issues related Pivot tables.
Let me give you an idea what exact topics I am going to teach you in this course.
- I will show you the exact cases when you can use the Excel Pivot Table
- Then I will show you the anatomy of a pivot table report with a real life example.
- Then you will see the step by step by process of preparing a data source for Excel Pivot table
- Then you will learn how to create and update a basic pivot table report
- Then you will be introduced with the Slicer tool in Excel
- And at the end of the course, I will show you total three techniques that you can use to will save your time when you’re working with Excel Pivot tables.
I have designed this course for new comers in Excel pivot table feature. But if you are an intermediate level user and want to be get used to with Excel 2016 Pivot table feature, then this course is also for you. This course will give you a simple but powerful introduction to the most powerful tool in Excel.
Feel free to take a look at the free previews of this course. I hope this course will change your view about Excel Pivot Table. Enjoy the course and thanks for reading!
20 Free Life Hacks to Inspire You to Excel in Business &Life
20 Free Videos to Inspire You to Live Your Life on Your Terms
Created by Chris Haroun - Award Winning MBA Professor, Venture Capitalist and Author.
Students: 50375, Price: Free
Welcome to "20 Free Life Hacks to Inspire You to Excel in Business & Life." This course is a collection of 20 of my favorite daily video Vlogs. Topics that we will cover include:
Day 1: Finding Your Career Path and Happiness (What Hat Should You Wear)?
Day 2: How to Build Unstoppable Confidence
Day 3: Cut These People Off (Get Them Out of Your Life)
Day 4: Why You Need Yoda's (Mentors) to Take Your Career to the Next Level
Day 5: How to Focus Better!
Day 6: Interview Better, Sell More & Get A Promotion Faster by Being You
Day 7: How to Save $1,000,000+
Day 8: Failure Is Not Shameful Because You'll Never Make It Big Without Failing
Day 9: Goal Setting:A Simple Way to Increase the Chances of Achieving Your Goals
Day 10: How to Find Your Passion
Day 11: You Are 26 Years Younger Than You Think + 16 Other Positive Things!
Day 12: Visualize Your Goal, Vocalize It & Set A Deadline (Right Now).
Day 13: How to Meet Any CEO You Want! JACKPOT For Your Career!
Day 14: Quit Your Job & Start Your Own Company. (I Want To Help You Do This)!
Day 15: Get Into Your Natural High Zone to Boost Your Productivity
Day 16: Write A Book The Easy Way & Watch Your Career Take Off!
Day 17: Why Skeptics Can Be Great For Your Career & Business!
Day 18: How to Get Into Your Genius Zone So You'llBe More Productive & Love Work
Day 19: Why Frustration With Your Job is a Good Thing
Day 20: Liberating Your Fear of Failure
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.
Easy Excel Basics for Beginners – Get Started with Excel
Learn Microsoft Excel basics from the beginning. Spreadsheets, shortcuts and formulas. Good for Excel 2010, 2013 & 2016.
Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students
Students: 42632, Price: Free
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.
This course will show you the basics of how to use Excel, how to create a basic spreadsheet, how to navigate quickly through a spreadsheet, how to create simple mathematical formulas and some shortcuts and keystrokes to save you lots of time.
You can go through this course in about 30 minutes. At the end you'll know how to create a sample spreadsheet that can calculate estimated kitchen remodeling costs automatically.
If you're ready to get your feet wet quickly and painlessly, take this easy introduction to Excel course and you'll see that using Excel can be easier than you think.
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 and manage tables,
Manage table styles and options, and
Filter and sort a table.
Perform operations with Excel formulas and functions
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
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.
Financial Accounting in Excel – New Business
We will start a comprehensive worksheet in Excel and enter journal entries related to setting up a new business.
Created by Robert (Bob) Steele - CPA, CGMA, M.S. Tax, CPI
Students: 33184, Price: Free
If we are a business owner or accounting professional who would like to get a better understanding of what our accounting software is doing
An accounting student or student in general that would like to get a better understanding of what our accounting textbook is doing
This course is a course for us.
Business owners, accounting professionals, and accounting students often have the same problem with accounting. . .
that we are focused on one small component of the accounting process and not able to make all the necessary connections to other components of the accounting process to fully benefit from an understanding of how the business runs.
Business owners focus on cash flow and revenue, accounting professionals focus on their component of the accounting department and enter data into the accounting software, and accounting students focus on the topic they are currently working on.
Accounting professional often focus on one component of the accounting cycle like accounts receivable, accounts payable, or payroll often not having much time to consider the relationship with other areas of the accounting cycle.
Accounting software helps simplify the data entry process, but the simplification also restricts us from seeing how the data is being processed into the end product, into financial statements and reports.
Students are focused on one component of the accounting cycle at a time following an accounting textbook that is putting the pieces of the accounting puzzle together one step at a time.
As students zoom their focus into the current topic, they often lose sight of it fits into the larger objective and this loss of sight causes students to question the relevance of what they are losing. Student’s questioning the relevance of what they are learning causes students to lose interest. A loss of student interest causes students grades to fall.
Part of the reason accounting textbooks have a difficult time incorporating the current topic into the big picture is that a textbook is restricted by what can fit on a page and the problems a textbook provides are restricted by what a student can accomplish with paper and pencil.
The use of instructional video providing a step by step process along with Excel that allows students to sum up large columns of numbers in a short time provides the tools to create a comprehensive problem that will demonstrate current topics in the context of the entire accounting process.
Why Take This Course?
We will start to learn the accounting cycle in a comprehensive way and learn the fundamental of Excel.
Learning the accounting process without Excel or Excel without accounting is a waste of time and not an efficient way to learn either topic.
Like assets being equivalent to liabilities and equity, accounting is equivalent to Excel in many ways and therefore learning Excel will accelerate our learning of accounting and make what we learn more applicable.
Accounting is also the perfect tool to learn Excel. This course will not provide a broad overview of everything Excel can do because that is not a way to learn. Courses attempting to demonstrate all the functions Excel fail to create value for learners because learners will not retain what they learn without a foundation of core concepts and a reason for learning each new function.
This course will cover the fundamentals of Excel, those components used 99% of the time, and the components needed as a foundation for learning more about Excel.
The core components of Excel we will learn include adding, subtracting, and summing up columns of numbers.
We will learn the core concept of Excel through demonstration, repetition, and application to practical problems.
What Will Be Included in This Course?
In addition to instruction video we include an Excel worksheet with just about every presentation allowing us to both see the completed answer and work through the problems step by step along with the video.
Each Excel workbook includes at least two tabs. One tab will have the answer so that we can see how the completed worksheet is constructed and the second tab will provide us the opportunity to enter the data along with the instructional video.
Who Will We Be Learning From?
We will be learning from somebody who has practical accounting experience as a practicing CPA, teaching experience, curriculum design experience.
We are learning from someone who has both instruction and curriculum development experience needed to construct comprehensive courses of a technical nature in a way that meets students’ needs and expectations.
What Will We Learn?
We will learn how to complete the components of the accounting cycle and the fundamental of Excel including addition, subtraction, and the sum function.
Below is a short list of what is included in the accounting cycle and what we will cover in the course:
- Journalizing journal entries
- Posting to the general ledger
- Create a trial balance
- Financial statement generation
How Will We Be Taught?
We will learn through viewing and then doing.
We will demonstrate each component of the problem in small digestible parts using both a completed Excel worksheet and instructional video.
We will provide an Excel worksheet that can be filled in along with the instructional video or after watching the instructional video.
Please join us in learning Accounting, Excel, debits, and credits.
It will be Great
Course Content Includes:
- Start a New Business Section of Accounting & Excel Course
- 05 Set up New Company Worksheet
- 10 Set Up Inventory Items
- 15 Set Up Customer Balances
- 20 Set Up Vendors Beginning Balances
- 25 Enter Opening Account Balances
Learn Excel in 60 Minutes: Using Real Company Data
Filtering, SUMIFS, Pivot Tables, Conditional Formatting
Created by Tony Li - Hotel Manager
Students: 27041, Price: Free
Use Excel to organize a real company's accounting and customer data. Then apply key practices in data analytics to draw insights from the data.
This course is very straightforward and targets people that want to pick up Excel as quickly as possible. Keep in mind that this course may not be for everyone because we move fast. Video tutorials are also done on a Mac, and it may be a little different on a Windows PC.
You are not required to have any prior experience with Excel, but there will be some knowledge gaps if you are 100% unfamiliar with it. In any case, we have structured the course so that you can easily follow along, but we expect students to be resourceful (i.e. Google) to fill in any gaps.
Excel tools you will learn: Pivot Tables, SUMIFS, COUNTIFS, AVERAGEIFS, filtering, conditional formatting, copying formulas, using dollar signs, and more!
Excel Data Validation For beginners
Eliminate bad data by controlling the inputted data on your workbook!
Created by Abdelrahman Abdou - Founder|ExcelBonanza.com|20000+ Students|164 Countries
Students: 23212, Price: Free
This course teaches students how to use the Data Validation feature in Excel to create rules that can control the inputs to Excel Workbooks.
This helps users eliminate bad data inputted by other people.
Students will learn how to controls numbers such as Integers and Decimals inputted by other users.
Students will learn techniques for creating data validation lists to restrict inputs to a list of values.
Students will learn how to apply date and time controls to restrict date and time inputs on their workbooks.
Students will learn how to apply text controls to control text inputs on their workbooks.
Microsoft Excel – Basic Data Visualization in Excel
Learn how to make great data visualizations in Excel
Created by Sean J. Thompson - Analyst
Students: 21361, Price: Free
Welcome and thanks for your interest in my course!
Learn and master the art of creating a well-designed data visualizations and basic data analysis in Excel in this wide-ranging course. Forget the same old default Excel graphs that are boring and without personality - you can do better than that! This course will help your to go beyond the basics of graphing and teach you how to design graphs with your intended audience in mind. Not only will you learn how to create great graphs in Excel, but you will also learn how to organize your data before graphing to make the process easier and more productive.
A few of the topics we will cover in this course include:
- How to determine if your data is graph-worthy
- How to organize your data prior to visualization
- Using vlookups to enhance your datasets
- Designing your graphs for your audience
- Using your visualizations outside of Excel
- and a few other surprises....
This course is mostly video based, but does include all of the Excel spreadsheets used throughout the course. Use these spreadsheets and documents as a resource after you complete the course. They are yours to keep and use as a reference in the future.
This course will allow you to use the Excel skills you already have and take them to the next level. This course was designed with you - the student in mind. My goal is for you to be able to implement the skills your learn in this course immediately once you have completed it.
I hope you enjoy the course and that your use the skills learned to enhance your skillset and wow your boss and coworkers!
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,
Microsoft Excel: Starter Guide
New to Excel or don't use it often? Here's your free guide to get started.
Created by Eric Arseneau, Ph.D. - University Professor
Students: 18542, Price: Free
This free class 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 for a variety of decision making scenarios. Excel is one of the most powerful software tools ever built. It is just as effective at keeping a grocery list as it is at crunching numbers for a Fortune 500 business. You will immediately create value for your own organization or your employer by learning the Excel skills taught in this class. I hope you enjoy it.
Excel for Beginners
Learn the fundamentals of Excel!
Created by Umar Iqbal - Author and Speaker
Students: 17801, Price: Free
A couple of years ago at my first internship, I was turned down a rotation since my Excel was exceptionally weak. I didn't even know how to write a formula, and probably had never heard the term pivot tables before! That day, I realized that Excel is something I need to work on, and this realization initiated a passion and love for the software!
After spending countless of hours going through different websites and manuals, learning from my seniors, and delivering presentations to my colleagues, I believe that I have developed a certain level of proficiency with this tool.
I now want to help you out with your Excel skills without having to go through all that I went through! Quite literally, I just want 1 hour of your time! In fact one more thing, your passion, commitment, and practice! It really doesn't matter as to what you do, or what age you are. I believe that this course will help you develop an elementary proficiency in Excel that is required for some very advanced topics such as Pivot Tables, Vlookups, and VBA (don't worry if you too, have never heard of these terms before; I'll be covering these in detail in a separate course!)
So what are you waiting for? Let's go!
Microsoft Excel – Basic Excel Formulas and Functions
Master Mathematical, Logical, Lookup, Textual and Date-time Excel formulas with hands-on examples and practice sheets
Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries
Students: 14797, Price: Free
Start using Excel to its full potential to become proficient at your Excel tasks today!
Either you're new to Excel, or you've played around with it but want to get more comfortable with Excel's advanced features. Either way, this course will be great for you.
A Verifiable Certificate of Completion is presented to all students who undertake this Excel course.
Why should you choose this course?
This is a complete and concise tutorial on MS Excel formulas which can be completed within 1 hours. We know that your time is important and hence we have created this fast paced course without wasting time on irrelevant Excel operations.
What makes us qualified to teach you?
The course is taught by Abhishek and Pukhraj. Instructors of the course have been using Excel for over a decade.
We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:
I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - Sikiru
Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand
Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.
Download Practice files, take Quizzes, and complete Assignments
With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Solution to Assignment is also shared so that you can review your performance.
What is covered in this course?
This course covers everything you need to crack Excel in the professional work place.
Below are the Excel course contents of this complete and concise course on Microsoft Excel:
Introduction - In this video, the structure and contents of the course are discussed.
Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.
Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID
Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF
Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS
Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH
Excel Formulas for Absolute Beginners
Learn MS Excel formulas in a fun and interesting way by solving puzzles and playing games!
Created by Mumshad Mannambeth - Best Selling Instructor| Author of Top 3% of Udemy's courses
Students: 13153, Price: Free
In this course we’ll be learning about excel formulas and have a lot of fun while we are at it.
This course is for Beginners who are just starting with Excel formulas and hopefully, by the end of course gain enough knowledge to be able to use formulas in their day-to-day activities. We will start with Cell References, and then move on to different types of formulas, functions such as Logical functions, text Functions and Lookup functions. All the topics have associated Excel Workbook resources containing sample problems to solve, puzzles, games and real-world practice questions to practice on.
To conclude, work on a mini-project to build a dashboard for an imaginary software development firm.
Excel 2013 Essential Training
Learn Excel from zero to advanced.
Created by Luis Federico Peña - LFTrainings - Your online academy
Students: 12219, Price: Free
In this Microsoft Excel 2013 training course, I take you through the basics of the world's most popular spreadsheet software. Excel can be a complex and confusing program to use, but this course breaks it down into bite-sized pieces and teaches it in plain way. No prior experience in Excel 2013 or spreadsheets is required to get the most out of this Excel beginners to advanced video training.
I have outlined this course as a step-by-step guide where you will learn from zero to advanced.
You will start with the absolute basics, creating and saving a new workbook. The course proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet, and even more.
By the time you have completed this video training course for Microsoft Excel 2013, you will be comfortable with day to day operations that you would perform in this software program. You will be able to perform calculations, and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material that the author uses throughout the lessons in this computer based training video.
Note: This is an introduction for the full course Microsoft Excel 2013 Essential Training from LFTrainings.
Project Based Excel Course + Practice Tests
Sharpen and test your Excel skills
Created by Brandon Brown - Programmer
Students: 2234, Price: Free
This Excel course shows you just enough training and practice problems to get a feel for Excel, then supplies you with exercises, projects, and practice tests.
I do not spend much time going over things like the menus, basic arithmetic, or charts. My course is aimed at giving you the core skills needed to do analysis in Excel and projects to get you business ready.
Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)
Become the master of Excel Pivot Tables | MS Excel | 2021 course
Created by Mozn Akhourshiedah - Engineer, trainer, Entrepreneur
Students: 1965, Price: Free
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.
What makes me qualified to teach you?
My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020:
***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana
***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine
***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne
What is this Excel course about?
In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field.
This course will cover Beginners, Intermediate and Advanced levels of Excel, including:
The basics of MS Excel
The powerful tool of PivotTables
Creating and Managing PivotTables
Learn from someone who is currently working in the industry, who knows the most current teaching techniques.
By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment.
Go ahead and click the enroll button, and I'll see you in lesson 1!
I wish you an enjoyable journey with us.