Microsoft Excel

2.1 Opening Microsoft Excel 2.2 Microsoft Excel Startup Screen 2.4 Introduction to the Excel Interface 2.5 Customizing the Excel Quick Access Toolbar 2.6 More on the Excel Interface 2.7 Understanding the Structure of an Excel Workbook 2.8 Saving an Excel Document 2.9 Opening an Existing Excel Document 2.10 Common Excel Shortcut Keys 3.1 Entering Text to Create Spreadsheet Titles 3.2 Working with Numeric Data in Excel 3.3 Entering Date Values in Excel 3.4 Working with Cell References 3.5 Creating Basic Formulas in Excel 3.6 Relative Versus Absolute Cell References in Formulas 3.7 Understanding the Order of Operation 4.1 The structure of an Excel Function 4.2 Working with the SUM() Function – Excel 4.3 Working with the MIN() and MAX() Functions 4.4 Working with the AVERAGE() Function 4.5 Working with the COUNT() Function 4.6 Adjacent Cells Error in Excel Calculations 4.7 Using the AutoSum Command 4.8 Excel’s AutoSum Shortcut Key 4.9 Using the AutoFill Command to Copy Formulas 5.1 Moving and Copying Data in an Excel Worksheet 5.2. Inserting and Deleting Rows and Columns 5.3. Changing the Width and Height of Cells 5.4 Hiding and Unhiding Excel Rows and Columns 5.5 Renaming an Excel Worksheet 5.6. Deleting an Excel Worksheet 5.7 Moving and Copying an Excel Worksheet 6.1 Working with Font Formatting Commands 6.2. Changing the Background Color of a Cell 6.3. Adding Borders to Cells 6.4. Formatting Data as Currency Values 6.5. Formatting Percentages 6.6. Using Excel’s Format Painter 6.7. Creating Styles to Format Data 6.8. Merging and Centering Cells 6.9. Using Conditional Formatting 7.1 Inserting Images and Shapes into an Excel Worksheet 7.2 Inserting Shapes In Excel 7.3 Formatting Excel Shapes 7.4. Working with Excel SmartArt 8.1. Creating an Excel Column Chart 8.2. Working with the Excel Chart Ribbon 8.3. Adding and Modifying Data on an Excel Chart 8.4. Formatting an Excel Chart 8.5. Moving a Chart to another Worksheet 8.6. Working with Excel Pie Charts 9.1. Viewing your Document in Print Preview 9.2. Changing the Margins, Scaling and Orientation 9.3 Adding Header and Footer Content 9.4 Printing a Specific Range of Cells 10.1. Intro to Excel Templates 10.3. Opening an Existing Template 10.4. Creating a Custom Template 13.1 Understanding Excel List Structure 13.2 Sorting a List Using Single Level Sort 13.3 Sorting a List Using Multi-Level Sorts 13.4 Using Custom Sorts in an Excel List 13.5 Filter an Excel List Using the AutoFilter Tool 13.6 Creating Subtotals in a List 13.7 Format a List as a Table 13.8 Using Conditional Formatting to Find Duplicates 13.9 Removing Duplicates in Excel 14.1 Excel DSUM Function Single Criteria 14.2 Excel DSUM Function with OR Criteria 14.3 Excel DSUM Function with AND Criteria 14.4 Excel Function: DAVERAGE() 14.5 Excel Function: DCOUNT() 14.6 Excel Function: SUBTOTAL() 15.1 Creating an Excel Data Validation List 15.2 Excel Decimal Data Validation 15.3 Adding a Custom Excel Data Validation Error 15.4 Dynamic Formulas by Using Excel Data Validation Techniques 16.1 Importing Data from Text Files into Excel 16.2 Excel 2019

3.1 Entering Text to Create Spreadsheet Titles

Entering Text to Create Spreadsheet Titles

  • During the next few sections we are going to be building our very own Microsoft Excel spreadsheet.
  • We are going to start out which is the completely blank worksheet and we are going to build up a monthly budget spreadsheet.
  • We are going to start out just simple take it step by step.
  • We are going to do things like enter labels like our column in our real labels.
  • We are going to enter some numeric values in there representing our dollar amounts are currency values.
  • The harder money that we are spending each and every month on all of our bills we will talk about building calculations.
  • We get things like totals for each month or each bill while talking about some other types of calculations as well.
  • We are going do some formatting we are going to make it look super awesome but we are going to start from complete scratch.
  • So, our first step we have got to open up a new Excel document and we are going to start to put some labels or headers into our spreadsheet.
  • Now occasionally I just really want to give you a heads up if you are also a part of the Office 365 subscription, Microsoft likes to push out updates now as of this recording that is February of 2019.
  • When you open it up your interface might look a little bit different because Microsoft pushes out updates, So nothing big.

 

Once again if you are on the office 365 you may occasionally when you first launch up Excel you may get a yellow bar at the top of your screen saying hey Microsoft got some updates ready for you do you want to go ahead and update and they’ll give you a button right there to build update. I am not getting it right now and we may see it at some point within this book as I close and I reopen excel and Microsoft may be pushing out updates but just keep an eye on that instead of your own interface updates are great, Microsoft is fixing dance creating new features for you, it is huge.

So, typically we start out and set a Cell a one within our new worksheet and there is a one what better place to put a title.

So, I am going to go ahead put a title, I will call this Monthly budget. This is going to be our Monthly budget spreadsheet.

I am just inside a column a row one type that value, I mean hit my Enter key on my keyboard that will haunt me out of the Cell.

Entering Text to Create Spreadsheet Titles

For now we are just going to put some labels in there and start to build the basic structure of our spreadsheet.

I am going to create a column here that is going to act as the labels for all of the bills that I have for each of the months.

And now I am going to create a list. Nice little column here of various bills that I have for each month.

Now you can copy me exactly if you like to, hopefully you are following along with me right you copy the exact same stuff if you like. But I want to encourage you, one of the best ways to learn something new is not only participate in a book like this and to learn but to put it to practice.

The sooner that you can start to put this into your own real-world scenarios the better off you are going to be.

I am going to call good right there of book I have got more inside there may want to put car in there. You got electricity gas you got garbage water you got this that and the other thing.

Let us go and create a list there and eventually we are going to start to put in the values for each of the months that we are spending on these various bills start to start to make it feel kind of bad where all your money is going right.

Entering Text to Create Spreadsheet Titles

That is going to give us some totals for the various months that we will have for each of our bills.

So, these are you real headers your real labels.

Hit Enter key to go to next row

Het Tab key to go to next column

Let us go out and continue building the structure, jump up into cell B3.

You are just clicking up there and I mean to put some labels up here for each of the months.

Keep it really simple if you’d like you can continue going right the more practice you get the better

We have got that one right there because eventually we are going to have some a row total here for each column but then I am going to have one here because I want to do totals for each of the bills as well

This is this is kind of the basic structure of a spreadsheet you have got real labels in this case bills you have got column labels representing some type of date now there is our basic structure our labels and these are just text values.

We are going to start to talk about entering numeric values and putting some currency amounts inside of these months for these bills so get that done we will jump into the next section.