Excel Functions


Excel Basics

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

Excel Basics

3.1 Entering Text to Create Spreadsheet Titles

29/11/2020 5 lượt xem

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.