Mastering Excel Formula Tips and Tricks

Excel is all about formulas. Think through how to do a calculation once, make sure it is correct, then copy it to other cells and use it as many times as you need to. In this lesson, you will learn some of the most popular and few not so popular formulas, you will review their syntax, how to use them, and you will also learn some other non-formula tricks that will make your life much easier. Let the computer do the hard work!

A few of the topics covered in this lesson are: Absolute and Relative Cell References, Function Screentips, Function Wizard, Edit Directly in Cell, Text to Columns, Formula Auditing, Evaluate Formula, Watch Window, Scroll Lock/F2 Trick, Summing Across Worksheets, Custom Number Formats, Precision As Displayed, Protecting and Hiding Formulas

Formulas: LEFT, RIGHT, SEARCH, PROPER, TRIM, CONCATENATE, TODAY, NOW, YEAR, MONTH, DAY, NETWORKDAYS, DATEDIF, CELL, INDIRECT, MIN, MAX, SMALL, COUNT, COUNTA, SUBSTITUTE, VLOOKUP, IF, COUNTIF, AVERAGE, MEDIAN, MODE, AVERAGEIF, AVERAGEIFS, IFERROR, SUTBTOTAL, OFFSET, SUMIF, SUMIFS, ROUND

As with all the Mastering Excel lessons, there is a follow along workbook available for you to work through as you read the text.

Helpful?
Mastering Excel Formula Tips and Tricks
Stats Overview
5.0 (1 Rate)
5
100%
rates
4
0%
rates
3
0%
rates
2
0%
rates
1
0%
rates
Add Your Rate:
Reviews (1):
Mastering Excel Formula Tips and Tricks
5 years ago

https://www.amazon.co.uk/Mastering-Excel-Formula-Tips-Tricks-ebook/dp/B00G4USD5E?SubscriptionId=AKIAIS3I5A33GTV7S27Q&tag=wwwcamratecom-21&linkCode=xm2&camp=2025&creative=165953&creativeASIN=B00G4USD5E Excel is all about formulas. Think through how to do a calculation once, make sure it is correct, then copy it to other cells and use it as many times as you need to. In this lesson, you will learn some of the most popular and few not so popular formulas, you will review their syntax, how to use them, and you will also learn some other non-formula tricks that will make your life much easier. Let the computer do the hard work!

A few of the topics covered in this lesson are: Absolute and Relative Cell References, Function Screentips, Function Wizard, Edit Directly in Cell, Text to Columns, Formula Auditing, Evaluate Formula, Watch Window, Scroll Lock/F2 Trick, Summing Across Worksheets, Custom Number Formats, Precision As Displayed, Protecting and Hiding Formulas

Formulas: LEFT, RIGHT, SEARCH, PROPER, TRIM, CONCATENATE, TODAY, NOW, YEAR, MONTH, DAY, NETWORKDAYS, DATEDIF, CELL, INDIRECT, MIN, MAX, SMALL, COUNT, COUNTA, SUBSTITUTE, VLOOKUP, IF, COUNTIF, AVERAGE, MEDIAN, MODE, AVERAGEIF, AVERAGEIFS, IFERROR, SUTBTOTAL, OFFSET, SUMIF, SUMIFS, ROUND

As with all the Mastering Excel lessons, there is a follow along workbook available for you to work through as you read the text.

Reply‚óŹ
Helpful?
User Image