Excel VBA

Keeping Track with Time Functions in Excel

In This Chapter Understanding how Excel handles time Formatting time values Working with hours, minutes, and seconds Getting the current time Calculating elapsed time Excel has a superb handful of functions for working with time calculations. You can analyze data to the hour, minute, or second. And Excel helps you get this done in a […]

Working with Date Functions in Excel

In This Chapter Understanding how Excel handles dates Formatting dates Working with days, months, and years Getting the value of Today Determining the day of the week When working with Excel, you need to manage dates. Perhaps you have list of dates when you visited a client and you need to count how many times […]

Working with Data in Excel

In this part We show you a variety of functions that work with dates and time, looking up values, getting information about your information, and manipulating text. We show you how to calculate how long something will take. Excel even has a function that counts elapsed days but knows not to count the weekends. How […]

Using Prediction and Probability Functions in Excel

In This Chapter Understanding linear and exponential trends Predicting future data from existing data Working with normal and Poisson distributions When analyzing data, one of the most important steps is usually to determine what model fits the data. No, we aren’t talking about a model car or model plane! This is a mathematical model or, […]

Using Significance Tests in Excel

In This Chapter Understanding estimation statistics Using the Student t distribution test functions Analyzing probabilities and results with the Chi Square functions When you have data from a population, you can draw a sample and run your statistical analysis on the sample. You can also run the analysis on the population itself. Is the mean […]

Using Descriptive Statistical Functions in Excel

In This Chapter Identifying key terms used in statistics Testing for central tendencies in a data sample Analyzing deviation in a data sample Looking for similarities in two data samples Determining where significant points are found in a data sample Counting items in a data sample Just pick up the newspaper, or turn on the […]

Getting More Advanced with Math in Excel

In This Chapter Calculating the diameter, circumference, and area of a circle Working with combinations and permutations Performing sophisticated multiplication Using the MOD function to test other numerical values Using the SUBTOTAL function for a variety of arithmetic and statistical totals Using the SUMIF function for selective summation In this chapter, we show you some […]

Using Math Functions to Figure Basic Math Answers in Excel

In This Chapter Summing, rounding, and truncating values Using a value’s sign in a calculation Removing the sign from a number Excel is excellent for working with advanced math and complex calculations. You can do so many complex things with Excel that it’s easy to forget that Excel is great at basic math, too. Need […]

Performing Advanced Financial Calculations in Excel

In This Chapter Determining what an investment is worth Using different depreciation methods Evaluating business opportunities Money makes the world go ’round, so the saying goes. We have a new one: Excel functions make the money go ’round. Excel has functions that let you figure out what an investment will be worth at a future […]

Working with Numbers in Excel

In this part Excel is a math-loving, number-crunching lean, mean machine. Part III is going to show just how much this is true! Basic math — no sweat. How about combinations, permutations, subtotals, and summing up condition-based values. Hey, now we are talking some cool math here. Ever try to work your way through a […]

← Previous Entries

Next Entries →