In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.
Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses.
We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come.
Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.

MG

A great course for beginners in MS Excel. Introduces one to the various functionalities that Excel has to offer. Course content and structure are excellent and helps one to learn at an optimal rate.

AG

May 05, 2019

Filled StarFilled StarFilled StarFilled StarFilled Star

I have no experience at all with Excel but after this wonderful course, i was able to pick it up pretty quickly! No more being intimated by being asked to have excel experience on job applications!

Na lição

Formatting

Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.

Ministrado por

Dr Yvonne Breyer

Program Director, Design and Experience, Global MBA

Transcrição

The next set of formatting tools we're going to look at, are called the alignment tools. They can be found in the home tab of the ribbon, just to the right of the font group. Alignment, basically means to change the positioning of your data within a cell. So, for example, if I select all of my data over here, at the moment, some of it's left-aligned, some of its right-aligned. If I click center align, you can see it's now all center-aligned. Right-aligned, it'll shifts over to the right, and that looks okay for most of it, but what I'm going to do now is just select my account managers and make them left-aligned. The alignment tools we've had a look at so far, refer to all horizontal alignment. But in Excel, you can also change your vertical-alignment. In other words, if things sit at the top, bottom or center of the cell. So, I'm going to click on my main heading here, and I'm going to click on center align vertically. You'll see I can also vertically align to the top. Let's go for the center because that looks really nice with our headings. Now, one of the problems you find in this worksheet and indeed a lot of worksheets, is sometimes the data doesn't fit properly into the cell. Now, there are lots of ways you can solve this problem. Sometimes making the column wide is the best option but in this case, I really don't want to. So, the other option available to me, is to use something called wrap text. So, I'm going to select all my headings, come up and click on wrap text, and what that has done, is to wrap the text around in the cell where it doesn't fit. So, it makes it more readable. Then, if I center align that vertically and horizontally, my headings are now looking a lot better. Just under the wrap text tool is something called merge and center. This is a really cool tool for making your headings sit nicely in the middle of your workbook. So, I've got this big heading here, but even if I were to try and put it in cell E and center align it, it's still not going to be perfectly in the middle. So, the alternative is to select all the cells that I would like it to be in the middle of, and then merge them into one big cell and center the text. So, I do that using merge and center, and there you go. It looks really cool. A slight word of caution with this though, make sure you only have text in one of the cells or otherwise you could lose data. Also reserve this tool for headings, don't try use this inside your data areas because later on when you try and sort and filter, you'll run into problems. Right. One last little thing to look at in the alignment section, and that's the orientation tool. Coming back to the idea of having very wide headings but not wanting to have very wide columns, you can change their orientation. So, I'm gonna select my headings here, I'm going to turn off wrap text for a moment, and then I'm going to come to my orientation and I'm going to choose angle counterclockwise. What it's done is actually angle the heading so it can fit the main beautifully, without making the columns wider. If you don't want them hanging off of the edge, another option is to rotate text up. There are few other options that you can have a look at. Some of them, quite good fun. Now, I'm going to put this back though to how it was before, because I think with this dataset that probably is our best option. When you play around, see what you like best.