Online Courses Update

Eduonix - Quick Guide to Master Advance Excel [100% Off]

Eduonix - Quick Guide to Master Advance Excel

$59 Free 100% Off

Lectures 54
Length 4 hours
Skill Levels All Levels
Languages English

Eduonix Coupon Code : EASTER

Take This Course

*** Manual input Coupon ***

Description

Getting the data is actually the easy part. Now that you have the data, the hard part is to analyze it. Data is often found in a mess and the job of sorting it and maintaining it, along with analyzing it was once a difficult task. This is before Microsoft Excel came along – making it easier to store, organize, sort, filter and even analyze the data.
Our Excel 2016 course is a complete online tutorial designed to not only familiarize you with the Excel program, but to also teach you all the things that Excel is capable of performing. Our tutorial will also cover the differences between Excel 2013 and the latest version – the Excel 2016, teaching you all the new features that are available with the 2016 version.
Microsoft Excel is an interactive spreadsheet that allows users to organize, analyze and store data in a tabular form. Originally designed as an alternative for accounting worksheets, Excel has since then evolved into a more complex piece of software. It has enabled users to easily record and analyze information and offers numerous tools to help along with this process.
Excel comes in a grid of cells that are arranged in numbered rows and letter-named columns. It allows arithmetic operations and also caters to statistical, engineering and financial requirements.
Excel 2016 is a part of the Microsoft Office 2016 suite is the successor to Excel 2013. However, many functions in Excel 2013 are similar to the functions found in Excel 2016.
The course will cover topics such as If statements, Vlookup, Round functions, Time functions, Data lookups, Sparklines, Outlining and even Scenarios. From basic formulas and simple functions to complex statements and operators, this course includes it all. It breaks down all aspects of Excel 2016 to give you a complete understanding of this amazing and useful software.
To give you an optimum learning experience, each section also comes with working files, practice exercises and even quiz questions and answers to help you along on your learning journey.
In this course, you will learn:

Learn how to use the basic formulas – SUM, COUNT, MIN, and MAX functions
Understand how to use the SUMIF function for selective counting, AVERAGEIF for Mean of selected cells, Multiple Criteria Within SUMIF, COUNTIF, and AVERAGEIF
Learn how to use the VLOOKUP function and its various features
Understand what is Sparkline, how to create a sparkline, altering the design of Sparklines, comparing sparklines and removing sparklines.
How to perform calculations using time in a worksheet
How to create, edit and remove an outline
Understand how to create and compare different scenarios
What are Custom Views, how to create a Custom View and how to edit and delete a Custom View.

There is so much more that you can do with your excel sheet. From simply a tool for organizing, excel can now help with simple calculations to performing complex functions, including creating charts, tables and graphs. Enroll now and learn how Excel can simplify your life.

Udemy - Excel - Beginners to Advance and Data Analytics. [100% Off]

Udemy - Excel - Beginners to Advance and Data Analytics.

$80 Free 100% Off

Lectures 43
Length 8.5 hours
Skill Levels Beginner Level
Languages English
Published 3/2018

Udemy Coupon Code : FREEMAY2

Take This Course

Description

Do you want to be a Microsoft Excel Master? Whether you need to learn it for school, you want to manage your finances better, or you want to impress your boss, this is the course for you! Learn directly from the experts all of the basics and advanced concepts that you cannot find in other lessons.

Each tutorial is easy to follow with clear explanations of each of the topics covered. Mastering Microsoft Excel 2016 is designed for anyone that wants to know more about this powerful software platform so whether you’re a beginner, intermediate, or advanced Excel user, you can learn something from this course.

We start out with the basics, focusing on worksheets and the different basic tools that everyone should know to use Excel correctly and efficiently from the start. After that, we'll move onto more intermediate topics such as Functions, Pivot tables, different chart types, “what if” analysis, data interpretation and finally VBA!

We specifically designed this course with practicality in mind. We want to see our students using Excel in their everyday work and personal lives and excel at it. Once you complete the course and all of the quizzes and exercises, you’ll be able to confidently use Microsoft Excel 2016 to do a variety of things.

Learning Microsoft Excel doesn’t need to be difficult; learn everything you need to know with our easy, convenient course!

Udemy - Easy Excel Dashboards, Models, Visualizations & Power Query [100% Off]

Udemy - Easy Excel Dashboards, Models, Visualizations & Power Query

$200 Free 100% Off

Lectures 19
Length 2.5 hours
Skill Levels Beginner Level
Languages English
Published 4/2018

Udemy Coupon Code : FBFREE

Take This Course

Description

Rapidly build robust dashboards in Excel by following a simple step by step process that requires no formulas. Beginners can get started easily due the lack of formulas. Advanced users will learn to structure their dashboards like software developers so that they become more automated with no additional work.

Not many people are aware how much can be done with no or very few formulas in Excel. This not only makes the design simpler it also makes it more robust, reduces risk and improve performance.

Jonathan trained as a Microsoft Certified Trainer and has used advanced Excel for over a decade.

Udemy - Master Excel AutoSum and Count Functions For Quick Analysis [100% Off]

Udemy - Master Excel AutoSum and Count Functions For Quick Analysis

$20 Free 100% Off

Lectures 21
Length 34 mins
Skill Levels Beginner Level
Languages English
Published 9/2015

Udemy Coupon Code : promo24

Take This Course

Description

WHAT’S YOUR STORY?

Are you a business professional needing to up-skill?
Are you struggling to get a pay-rise and/or promotion?
Are you a recent graduate with an empty looking resume and no job experience?
Have you recently been laid off, fired or had a contract end?

If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why.

The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself.

A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics.

This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory.

ONLINE TRAINING AND THE MOST COMMON PROBLEMS

One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.

Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.

COURSE DELIVERY STYLE

I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.

WHAT YOU’LL LEARN IN THIS COURSE

Learning the AutoSum and Count Functions is a complete life saver. What these tools allow you to do is quickly summarize huge sets of information. Instead of adding and counting individual cells, Excel AutoSum and Count functions will do that for you. All you have to do is it tell it where!

So come on in and check out these amazing functions. Along with learning these variations, as a bonus feature to this course, I'll be briefly introducing you to "If Functions"!! This is an amazing logic based tool that every Excel user MUST KNOW!

ABOUT ME

Member of the Udemy Council
Co-Founded Paperclip Learning which teaches Microsoft Office
Over 60,000 students
Over 130,000 enrollments
Over 5,000 Positive Reviews
Over 20 courses on Udemy

Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics.

TESTIMONIALS

Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks!

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach

Udemy - Data Modelling in Excel Masterclass: Excel Formulas [Free]

Udemy - Data Modelling in Excel Masterclass: Excel Formulas

Free

Lectures 71
Length 9 hours
Skill Levels All Levels
Languages English
Published 1/2018

Take This Course

Description

The Art Science of Excel Modeling is an in-depth exploration of how to plan, design, and maintain superior Excel models. Ideal for consultants, financial analysts, auditors, accountants, managers, and technical professionals seeking to gain a deeper understanding of the “art-science” of data modeling and how it can lead to improved business decisions. Kicking off with a bigger-picture, more philosophical view of spreadsheet design principles, our aim is to inspire critical thinking skills and confidence in an increasingly competitive job market. In our “real world based” case studies, we will explore creative solutions to routine business problems in the business, finance, and accounting world. We will also offer practical guidance for newer challenges arising from the ever-increasing volumes of “big” data that seem to be “pushing the boundaries” that Excel is naturally equipped to handle.

Designed with the intermediate to advanced level Excel user in mind, as well as technical professionals seeking to build better alliances with “the Excel people.” To keep up during this course, we recommend you have a very solid understanding of the basics of the spreadsheet environment. Formula construction and concepts, in particular structured referencing (proper use of the ‘$’ signs) is also extremely helpful.

Udemy - Financial Accounting in Excel - New Business [Free]

Udemy - Financial Accounting in Excel - New Business

Free

Lectures 13
Length 1.5 hours
Skill Levels All Levels
Languages English
Published 12/2017

Take This Course

Description

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.

Credentials include:

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

Udemy - Microsoft Excel 2016 Training: Beginner to Intermediate [Free]

Udemy - Microsoft Excel 2016 Training: Beginner to Intermediate

Free

Lectures 107
Length 16.5 hours
Skill Levels All Levels
Languages English
Published 10/2017

Take This Course

Description

Learn Microsoft Excel 2016 Inside and Out

Includes 16 hours of high-quality training by your professional trainer
Practice along using exercise files
Watch and learn with demo project files
Progresses logically from beginning with an easy intro to advanced topics

This course includes:

16 hours of video tutorials
Over 100 individual video lectures
Exercise files to practice what you learned
Demo files used by the trainer
Close captions to follow along
Certificate of completion

Contents and Overview

This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user.

It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them.

You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets.

You'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars.

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course.

* Includes quizzes, exercise files, demo files, close captions and certificate of completion.

Udemy - Introduction to Data Analysis using EXCEL [100% Off]

Udemy - Introduction to Data Analysis using EXCEL

$195 Free 100% Off

Lectures 62
Length 5.5 hours
Skill Levels Beginner Level
Languages English
Published 10/2017

Udemy Coupon Code : FIVERRBOUHADDA3

Take This Course

Description

Course Released: Oct 26, 2017

Do any of the following apply to you?

You have data for your work or business but you're not sure what to make of it?
You might know your way around Excel but you're not confident about turning data into business insights
You frequently receive Excel spreadsheets from others but want to better understand how they arrived at their conclusions?
You want to learn the best practices when it comes to using Excel for data analysis.
You are intimidated by spreadsheets and terms like Pivot Tables and VLookups
You want to learn skill set that is useful for any role in any industry you get into later.

Every business generates data. But whether you're able to turn that into insides depends on your ability to process, manipulate, and ultimately translate that data into useful insights.

Whether you're working for a company or running your own, being able to make better decisions require you to be able to analyze and interpret data.

What data do you need? How do you prep that data? How do you analyze it to answer specific questions?

In this course, we're going to show you step by step, exactly how to do that, by starting with the very basics.

Why Microsoft Excel?

Excel is still the most widely used analytical tool used by analysts in all industries across all roles. It's used by financial analysts, marketing analysts, sales analysts, and of course, data analysts.

Yes, there are many more tools out there but if you learn and master the core concepts and techniques of data analysis in Excel, you'll be able to apply those learnings to other areas.

But do not underestimate Excel--a single worksheet can technically hold more than 17 BILLION data points (but it will make your computer REALLY slow). And for most of us running analysis most of the time, we'll need to process far fewer data points than this.

Why learn from us?

By signing up with us, you will be learning from two instructors with a combined 35 years of relevant experience across a wide range of analyst roles.

Travis has been a digital marketer, investor, and entrepreneur for 20 years, having also led growth in Asia for Groupon and previously even helping to build Excel as an engineer at Microsoft. He is a data analysis and data visualization expert and will be pull from his industry experience to teach some advanced data analysis topics to students in this course.

Symon has been interpreting and analyzing data for 15 years. He has served as financial analyst, marketing analyst, and even head of marketing analytics across half a dozen industries. If you look at his other courses on Udemy, you'll see that he is an Excel and analysis ninja, having taught over 50,000 students with over 2400 reviews.

Together, we pull directly from our experience and put it in this course--in fact, all of the case studies are inspired by real world projects we had personal experience with.

What if I don't have any data analysis or Excel background?

No worries! This is why we start with the very basics in our foundational sections, which is meant to get you familiar with Excel first. You can be a complete newbie and take this course. It will sometimes feel like you're drinking out of a firehose, but you will become proficient by following our course and doing the exercises.

We then progressively increase the difficulty as you move along in the course, culminating in advanced techniques taught through our case studies.

If you do have an Excel background, you can skip or skim through the foundational sections and move directly into the more advanced topics.

Tell me again why I should take your course?

You have absolutely ZERO risk.

Udemy gives you a solid as an oak tree 30-day money back guarantee.

So if you've read this far, we welcome you to join us inside!

Udemy - Excel With Excel Power Query and Get & Transform [100% Off]

Udemy - Excel With Excel Power Query and Get & Transform

$190 Free 100% Off

Lectures 18
Length 2.5 hours
Skill Levels Beginner Level
Languages English
Published 7/2017

Udemy Coupon Code : WELCOME

Take This Course

Description

The course will get yo up and running and using Power Query / Get & Transform with CONFIDENCE!

This must have introductory course covers all of Excel´s must-know features for cleaning up, transforming, consolidating and automating your Excel data and reports.

You will learn Excel features such as the Functions & Formulas, Text to Columns, Find & Remove Duplicates, Go to Special, Excel Tables, Flash Fill and obviously Power Query (Excel 2010 & 2013)and Get & Transform (Excel 2016) and many more Excel tips & keyboard shortcuts!

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single data cleansing & consolidation tool that is available in Microsoft Excel.

The course is designed for Excel 2010, 2013 or 2016. There are 4 different modules so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.

In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers!

The course is just over 2 hours long so you can become an awesome analyst and advanced Excel user within 1 day!

In this course there are FREE downloadable Excel workbooks for each tutorials so you can follow along & practice what you learn.

We have collectively been helping over 25,000 Udemy students further their professional careers by teaching them Excel the easiest and most comfortable way.

These tutorials will give you career-building skills that you can use to become better and more efficient at your job.

If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc....then this course is for YOU!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions - and we will answer them personally within the day!

We are so confident that you will get lots of value from this course that you can take it for the full 30 days, download all the workbooks, watch all the videos and apply it to your work to see the results. If you're not 100% satisfied, we will be more than happy to refund the full purchase amount!

So go ahead and learn from the following in depth Excel subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...