Viewers: in countries Watching now:
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
On the Home Tab in the Ribbon, one of the most prominently selected group of icons is the Font Group right here. These involve changes that we might want to make to our worksheet, to make data standout a little more prominently or give greater emphasis to a title or some of our row headings, for example. Certainly, one way to get to this might be, for example, the title we have on this worksheet called Fonts, in this workbook 04-Formatting. Let's change this cell D1. The text extends into the other cells, but we could easily change the font type itself.
Calibri is the most commonly used font in Excel in recent versions, but as we slide over these other choices, we can see how they might look. There are so many choices here that if you're a bit picky, you might spend a lot of time looking at some of these. You can also use the mouse wheel to scroll up and down, slide over this one, slide over that one, maybe make a choice, maybe not. Some would be, perhaps totally inappropriate for workplace usage--others look pretty interesting, maybe they do--just a ton of choices. How does that one look, and so on? At some point, maybe you'll say, "okay I'll try this one or that one".
Of course, what else might we do with this? A fast way to get here is by right- clicking because that activates the mini toolbar. Nearly, all the buttons we see up there in the Font group on the Home tab are also shown here in the mini toolbar. So maybe we'll change the Size of the font this way, or that way maybe. While we're at it, color background for the cell, and of course, not all these are going to be great choices. Bold, it's already bold, perhaps, italic, slanted, and so on. Lots of choices here, by the way of the font group, or by right-clicking in the mini toolbar.
Now, there could be a feature that maybe you just don't see there, but you suspect it's available. You perhaps have seen subscript or superscript. Sometimes, the way we need to get to features to adjust the font are by way of the little arrow on the corner here, the so-called Dialog Box Launcher. If, for example here, if we wanted to use--maybe in a different situation here--like how do we get to the two, how do we write the little two as a superscript here? In this example, let me zoom in on it, and I will use the zoom slider in the lower right-hand corner on the status bar to zoom in on the data here.
If we were typing this, we would type it, at least initially this way, "e=mc2". Highlight the 2 now, by clicking the Dialog Box Launcher. And there are two other ways to get here by the way, one is Ctrl+1-- it activates the Format Cells Dialog Box-- just like that arrow does there. This leads us into some other capabilities here. There aren't a whole lot more than what we actually see on the Home Tab, and certainly superscript is one of them here, and that's the one we might want to use in this case here; so now the 2 is a superscript.
Sure enough, same idea here with the subscript H20, you'll just type it as H20, then select the 2 and jump back in here. Once again, H2O, highlight the 2, this time a little bit different, we'll press Ctrl+1-- get there a little bit faster--and we'll try subscript this time to come up with H2O. There are some unusual underlining choices available with fonts too that you don't see in the font group here. Those too, you can get to with that Dialog Box Launcher or Ctrl+1.
One of the methods of getting into those choices--let's imagine we might want to make some font changes here-- we can right-click and go immediately into Format Cells. This doesn't always take us to the Font Tab, although often it will. Sometimes, you'll find yourself at the Alignment Tab, but you can easily make the switch there. Maybe we're considering here some underlining changes that we don't see on the Home Tab, so we've got some others up there as well; maybe double counting or something that appeals to us. Click OK and maybe it is or maybe it isn't, but we can get to those features as well.
There are lots of different ways and reasons for wanting to change the font, and again, some of them are quick and easy like Bold, Italic, Underline. We can get to them this way or earlier, we saw how by right-clicking you activate the mini toolbar to get to those features even faster.
There are currently no FAQs about Excel 2013 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.