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

4.3 Working with the MIN() and MAX() Functions

The next two functions that we are going to take-a-look at here are pretty common as well. Perhaps not as common as some function but you are going to see these two pretty often inside of Excel documents. We are going to look at the built in Min and Max functions two very similar functions, and in fact they are going to look very similar in structure number in the three parts equals function name arguments very similar to the sum function.

I am back exercise file (Mothly Budget). Hopefully you have taken a moment to go through and practice at some function and complete it for the rest of the months and for your road totals as well for each of the bills.

Now if you have got any questions on the SUM function or functions in general. Jump into the Review section and ask your questions, I love getting questions ask them.

Min and Max to get this set up.

I am going to go into row 11 and I am going to put in some labels here these labels. That is all they are going to be just labels to label our calculations.

Working with the MIN() and MAX() Functions 1

The first one that we are going to experiment with here is the main function. And like I said this should feel pretty similar to working with some function that we saw earlier, I want to know the minimum value from a range of cells smallest value.

I am going to go to B11 going to go to formulas tab, we can look at our little books. Earlier we went into math and trig. We wanted to do some math type operation we wanted to some. We found it here inside of the math function or the math folder little book by scroll on through.

I find the, but I do not see the MIN or the MAX inside of there. So I am not inside of there.

We got all these other books that we can look through as well. We have got financial logical text date time lookup and reference, Where do you find the MIN MAX function.

Let us see there is one called more functions, If I go into there there is statistical engineering cue the information compatibility and so on.

I really guess statistical, If I scroll through here I will find MIN MAX in function.

Working with the MIN() and MAX() Functions 2

I know is there because I have been using this application forever. where do I find it, How do I know where to find this thing at.

We can use the books and as you become more and more familiar with working set of excel where functions reside .

Eventually you are going to be typing them out by hand anyways, You may not even go to the formula tab.

Here I am going to go click that little fx button, click on it I get the insert function window where I can search I can type in keywords I can search by category and down below, They’ll give you suggested functions for that search term or that category.

Working with the MIN() and MAX() Functions 3

Here I could say I want to find the MIN function, I will type that in or you type in minimum or whatever then I will hit Go

Took them all with their recommended and that is giving me some suggested or recommended functions.

The MIN function returns the smallest number in a set of values ignores logical values and text, looking for minimum values of numeric values.

With MIN selected, I will hit OK. And this opened up the argument window of MIN function, It is already filled in some information for me.

Working with the MIN() and MAX() Functions 4

Let us take a closer look at that B4 through B10. Well I do not really want that I won’t B4 through B10 , Excel tried to help me but B10,B9 is empty and B8 is my total. I do not want include the total. So I am just going to wipe that out (Delete).

Working with the MIN() and MAX() Functions 5

Then I will go grab before through B4 to B7.

Working with the MIN() and MAX() Functions 6

Then click OK

Returns the smallest number in a set of values. And for the month of January 125 is my smallest

This is going to be almost identical with MAX function

I am going to drop down one more cell and to B12 where I have got the Max, I am going to do the same thing.

I am going to go back to fx icon, I will type in Max -> Go

That was my recommended I am going to grab Max.

Click -> OK

Working with the MIN() and MAX() Functions 7

Delete default value in Number1 box, then select cell B4 to B7 by mouse

Final click OK, And I have got my maximum value.

Min and max two more predefined functions built into the Excel application, already built for us.

We just got to use it. Put in the range of cells that we want and it is done the job for us. So try it out, then also do it for the rest of the months. Get all these cells filled out with your Min, Max. And if you want to do it for the total or for the percentage, Feel free to do it there as well.