
Basics: Good for beginners. Skip this part if you are well-versed in this aspect :-)
Basics: Good for beginners. Skip this part if you are well-versed in this aspect :-)
Basics: Good for beginners. Skip this part if you are well-versed in this aspect :-)
Do refer to the Resources tab to try out these functions yourself (also relevant for use in future lectures) :)
In this lesson, we look at how to use the transpose function, and how to efficiency get a range of numbers for use as serial number quickly.
Knowing how to use pivot tables is important - these tables allow anyone to filter and extract important details about the data set they are working with in a number of ways and perspectives. From these pivot tables, charts can also be created to allow people to better visualise the data.
Learn about pivot table and pivot charts in this lesson.
Did you know that nearly 80% of all middle-skill job openings require their potential employees to use spreadsheet software such as Microsoft Excel?*
That’s because Excel is a powerful tool that can be used for data analysis and management, allowing users to gather useful insights into the data that they are working with. It can also be used for "fun" applications, such as to play tic-tac-toe, etc.
Gone are the days where you have to calculate 101 columns of monthly expenses yourself or sketch a graph by hand just to understand your expenses – you can do all these with Excel, at a lesser time!
This course allows you to get started with Excel – starting from the bare basics as getting the fundamentals right is key to mastering Excel. Don't feel overwhelmed, we will go through the basics slowly :)
*according to the report, first discovered by Lauren Weber at the Wall Street Journal.
Money-back guarantee:
Don't worry - there's a 30 day money back guarantee - there's nothing for you to lose when you sign up for this course! Get started today!
Tags: Online Excel, Microsoft Excel, Learn Ms Excel, Basics, Excel Tutorials, Formulas, Shortcuts, Examples, Easy, Productivity, Analyse, Online courses, Certificate courses, Training, Shortcuts, Pivot Table