Do you want to make your work with Excel faster, more efficient and fun?
Do you want to learn more about hidden tricks that make Excel easier to use?
Are you looking for a structured way to get really good with Excel?
If your answer was YES to some of the questions, this course might be of interest to you.
When I created this course I put full emphasis on a structured and didactically sound way to gently show you how Excel 2016 and 2013 works. This course is especially suited towards a beginners and intermediate user group.
The course was shot with Excel 2016, which basically means that you can apply the knowledge from this course also to Excel 2013 (and 2010) since those versions are quite similar.
Excel is such a huge and powerful software so that learning it can be confusing. It is advisable to learn it in a structured way so that you can improvise and find proper solutions to new problems. Many users tend to only know the parts of Excel that are needed for their daily routine. Once a totally new problem arises, they are stuck. Having structured training combined with practice is key to finding solutions faster and without frustration.
In this course you will learn about the general interface, the capabilities and limitations, popular and efficient functions, useful tools, data visualization, database handling, getting help and much more. Take a look at the course content overview to see how extensive the whole product is.
At the end of this beginners and intermediate course you should be confident in using for your daily tasks. You will know
how to use Excel's functions and other tools
what the capabilities of Excel are
where to find the appropriate features
how to get help
and how to work more efficiently with Excel.
Excel is one of the key software products of today’s professional world. You will use it extensively in your work life, and of course your colleagues will be thankful if you can show them some tricks they did not know before!
A short introduction on Excel's file types and on the different attributes.
We are going to create our first Excel workbook.
The Quick Access Toolbar is a very useful feature of Microsoft Office products. In this lecture we are going to take a look at its default tools, and we are also going to learn how to customize it in order the make our daily work quicker.
This lecture contains core information on finding your way within Excel. We are going to take a look at the ribbons, as well as at columns and rows.
However Excel is like a huge calculator it makes a great job handling not only number values, but texts, dates, currencies and other types of data. In this lecture we are going to learn how Excel differentiates between those types of data, and how you, the user, can do it.
In this lecture we are going to dive deeper into different cell format types. Did you know that Excel can handle the very same data differently depending on the actual cell format type? This lecture could save you some headache, if you are struggling with Excel's auto-formatting feature.
A single Excel workbook can contain several worksheets which can help you keeping things tidy and organized. In this lecture we are going to learn
This lecture will teach you how to manage the rows and columns in Excel.
You will learn
In this lecture we are going to learn how to copy and paste data within an Excel worksheet and between worksheets as well. We are also going to learn on the specific rules of those actions.
In this tutorial you will get familiar with one of most useful and most frequently used tools of Excel. The Fill Handle tool is perfect for copying data or filling cells with series. This tool is one of the biggest times savers as well, and we are going to use it a lot through this course.
Topics of the lecture:
In the last lecture of the section we are going to take a closer look at Excel's file menu. We are going to discover the old features as well as the new ones which Excel 2016 provides.
Please note, that printing has its own section in this Excel curse.
Like other products in the Microsoft Office family, Excel also provides the user content formatting tools. They can be used very easily and intuitively. In this lecture we are going to walk through them together.
In this video we are going to take a closer look at the cell alignment features of Excel.
- vertical and horizontal alignment;
- custom alignment;
- merging cells.
Printing in Excel might not be so obvious as e.g. in Microsoft World. Therefore, this course dedicates a whole section for printing. In this lecture we are focusing on the Print Dialog Box.
We are going further with the topic of printing.
In this lecture you will learn
In the final lecture of the section we are going to learn more on headers and footers.
In this lecture I'm going to show you how to do mathematical operations in Excel.
The order of operations is a core element in mathematics, therefore it is crucial to learn it properly. In this lecture I'm going to explain those rules and also we are going do a simple exercise in order to understand those rules better.
SUM is probably the most used function of them all in Excel. In this lecture you will learn how to use it for consecutive cells, and also how to combine it with the Fill Handle tool. We are going to solve some exercises together for better understanding.
This lecture contains an exercise which will teach you how to use the SUM function with non-consecutive cells.
Using formulas like SUM and the Fill Handle tool together might cause cell reference shifting. We can take advantage of it, like we did in the previous two lectures, but sometimes this phenomenon is undesirable. In such cases absolute referencing comes handy. In this lecture we are going to learn on this feature of Microsoft Excel.
In this lecture we are going to learn about the counting functions of Excel through a couple of examples.
In this lecture you will learn about Excel's statistical functions.
The following two lectures are on Excel's most used logical function, called IF. In this tutorial we are focusing on the numeric value based logical test. Example exercises is provided for better understanding.
In this lecture we are going to try Excel's IF function with text based logical test.
Not properly built formulas result error messages. In this lecture we are going to take a closer look at common error messages. We are also going to learn what causes them and how to fix them.
In this lecture you will learn
However the SUM function is very useful on its own, Excel provides some extensions for it as well. This extensions are the SUMIF and SUMIFS functions.
In this lecture you will learn the syntax and usage of those extensions through the provided example.
Not only SUM, but the functions COUNT and AVERAGE also have extensions. In this lecture we are going to take a closer look at them, we are going to learn their syntax as well as their usage.
Making calculation with dates can be a confusing business. Fortunately Excel provides useful date functions like DATEDIF, DATEVALUE or TODAY which can make our work better. This tutorials shows you how to use them for various purposes.
Copying and pasting formulas can be different from copying and pasting other cell content. This lecture summarizes the available methods and highlights the points you should pay attention to. Furthermore you will learn how to display formulas on different ways, which skill might also come useful in some situations.
Name facilities can really make our work quicker and more precise whether we build multiple sheet formulas or just use them for absolute referencing.
In this lecture we are going to learn how to create named ranges and cells, and I'm also going to show you how to use them in formulas.
Till then we built formulas using cells from a single Excel worksheet, but it might happen that we need to connect multiple sheets together. In this video you will learn the exact method of creating such formulas, and we are also going to discuss some rules you should keep in mind.
Excel worksheets can not only be connected within formulas, but we are able to format them simultaneously. This method is a great time-saver.
This lecture will guide you through the different levels of protection Excel offers.
This lecture is an introduction to data visualization. We are talking about the advantages of visualizing data, and you will also going to learn how to use Excel's Recommended Charts features. This one is really useful especially if you are not familiar with the different charts types yet.
This tutorial will guide you through the process of creating a chart from scratch.
In this tutorial I'm going to show you
So far we learned how to work with multiple worksheets concerning functions and formatting. Creating diagrams which draws data from multiple sheets is further powerful feature of Excel. In this lecture I'm going to teach you how to build those kind of charts from scratch.
Creating graphs is not the only way of data visualization in Excel. In this video we are going to take a closer look at those options.
Please note, that this course has another lecture on conditional formatting where you can find more information on that topic (Section: Database).
The next two lectures are taken from another Excel course of mine. They are discussing the usage of various chart types which you might find helpful.
In this lecture I'm going to show you the main types of illustrations Excel provides.
Illustrations can be formatted similarly to graphs. In this lecture we are going to walk through the different options, and I'm also going to show you specialities.
In this lecture we are going to get familiar with the way Excel layers the illustration. We are going to learn how to alter that order, and also how to group those items for better control.
Caption boxes are a really fun feature of Excel. We can communicate data through them, and this data can be controlled by functions in the background. Really cool add-ons for questionnaires and informal forms.
R-Tutorials is your provider of choice when it comes to analytics training courses! Try it out – our 50,000+ students love it.
We focus on Data Science tutorials. Offering several R courses for every skill level, we are among Udemy's top R training provider. On top of that courses on Tableau, Excel and a Data Science career guide are available.
All of our courses contain exercises to give you the opportunity to try out the material on your own. You will also get downloadable script pdfs to recap the lessons.
The courses are taught by our main instructor Martin – trained biostatistician and enthusiastic data scientist / R user.
Should you have any questions, you are invited to check out our website, you can open a discussion in the course or you can simply drop us a pm.
We are here to help you boost your career with analytics training – Just learn and enjoy.