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.3 Entering Date Values in Excel

We have talked about two different types of data that you can input into an Excel document. There is actually a few more and I want to talk a little bit about one of the other types of data that you are going to be inputting into an Excel spreadsheet. We have talked about alpha characters.

Another type of data that you are going to be working with inside of excel are Dates.

So, let us talk a little bit about dates. We have got some months I mean that is a portion of a date, that is a date valued but it is not a complete date. Right dates they typically contain three different aspects or three different elements that make up the date that you have got the day the month you got the month and you got the year. So, we really got those three pieces.

Depending on what region you live in your dates may be formatted a little bit differently. Do you do day first do you do month first? What does your years look like? Right there is lots of different ways to build a format dates but dates typically contain those three pieces of information.

Let us say for our months here maybe I am going to be using this one spreadsheet for multiple years.

I want to designate I want to denote which year this month belongs to. I am going to go up into my January which is be three and I mean it is going to Double Click into that cell Double Click enters into that cell I can now edit it.

I am going to say January-2020, I am going to hit my Tab key cop out of that cell in a minute two things just happen there.

Entering Date Values in Excel 1

Let us get back and fix this one, Double click that cell. We are now working with a date value.

Entering Date Values in Excel 2

A couple of things happened, they are now right aligned they are on the right-hand side of the cell. Remember that discussion that is supposed to happen with numeric values. Well, you know what, instead of Excel and most applications, dates are treated as numeric values, best way goes they are numeric.

You saw when I double clicked inside of there you, actually, get a date format.

We have now got some date values and underlining once again and I can see this up above here inside of my formula bar that we have actually got a date it is right aligned it is numeric it is a date value treats it as such but underlining that is a date.

Entering Date Values in Excel 3

What I am going to do here and this is something we are going to get much more depth than too as we continue through, when we start to get into the formatting section of this book is, I want to format these cells.

I am going to highlight B3 to D3, then I am going to go to Home tab top my screen and I am going to go into the numbers section right underneath.

Entering Date Values in Excel 4

We can currently see that it says custom typically that I will say a general, if I go to any other cell, we will see general inside of that box there it is general well here with that selected.  I am going to go up here to a little dropdown and we have got some default formatting options.

Scroll down we have got a whole bunch of other stuff inside of there but down at the bottom we have an option for more number of formats.

Entering Date Values in Excel 5

I am going to go into more number formats here underneath category.

Entering Date Values in Excel 6

I can format cells by selected Custom and enter type format from my keyboard.

Entering Date Values in Excel 7

And the result, we have them nice months.

Entering Date Values in Excel 8

That was a few steps that we went through. Always feel free in any of the lecture, just leave it the way that you want or come up with another format.

Go to Review of this book to make your questions and get answers right now, I love answering questions, I love seeing the work that my students do. Share with us take a screenshot add it to the post let us know what you are doing.

Get this portion done, get your dates in there, Looking good. We will jump into the next lecture. I am excited, we are going to be getting into some formulas.