Home » Courses » Microsoft Excel Advanced Certification » Module 9 : Create an Advanced Calculator
Module 9 : Create an Advanced Calculator
9.1 Create an Advanced Calculator As well as Using Excel for basic calculations, such as addition, multiplication and sums of columns or rows, you can also use Excel to perform some very advanced calculations. However, sometimes you just need to use a calculator to know what data to input in Excel, and there is an option for that. You can show and use a calculator in your Excel work area. This calculator can be used to calculate the difference between data, such as dates, conversion of a...
Lessons
- Module 1: Add a Password
- Module 2 : AND Function
- Module 3 : Auto Updating Drop-down Lists
- Module 4 : CEILING Formula
- Module 5 : Charts that Update Automatically
- Module 6 : CHOOSE Formula
- Module 7 : Compare 2 Lists with VLOOKUP Function
- Module 8 : CORREL Function
- Module 9 : Create an Advanced Calculator
- Module 10 : Create a Combo Chart
- Module 11 : Create a Custom Tab
- Module 12 : Create a Pivot Chart
- Module 13 : Create Visual In-cell Indicators
- Module 14 : Create Visual In-cell Indicators with Icon Sets
- Module 15: Customise the Status Bar
- Module 16: DATEDIF Function
- Module 17: DATEVALUE Function
- Module 18: DAVERAGE Function
- Module 19 : DCOUNT Function
- Module 20 : DCOUNTA Function
- Module 21 : Depreciation Formula
- Module 22 : DGET Function
- Module 23 : DMAX Function
- Module 24 : DPRODUCT
- Module 25: DSUM Function
- Module 26: EDATE Function
- Module 27: EOMONTH Function
- Module 28: Find and Replace
- Module 29: FIND Function
- Module 30: INDEX Function
- Module 31: INDEX MATCH Function
- Module 32: INDIRECT Function
- Module 33: Insert Serial Number Automatically
- Module 34: IPMT Function
- Module 35: ISBLANK Function
- Module 36: ISERR Function
- Module 37: ISLOGICAL Function
- Module 38: ISNONTEXT Function
- Module 39: ISNUMBER Function
- Module 40: ISODD Function
- Module 41: Isolate First Name
- Module 42: ISTEXT Formula
- Module 43: LEFT Function
- Module 44: LEN Function
- Module 45: MATCH Function
- Module 46: VLOOKUP Multiple Results at Once
- Module 47: OR Function
- Module 48: PMT Function
- Module 49: REPLACE Function
- Module 50: Select all Cells with Comments
- Module 51: Sparkline Charts in Excel
- Module 52: Straight Line Depreciation
- Module 53: Strikethrough
- Module 54: Sum of Years Depreciation
- Module 55: Timeline in Pivot Table
- Module 56: VLOOKUP with 2 Criteria
- Module 57: VLOOKUP with DropDown List
- Module 58: VLOOKUP with MAX
- Module 59: VLOOKUP with MIN
- Module 60: Watch Window In Excel
Get a quote
- We offer a price match guarantee.
- Set-up is simple, with a fully branded LMS, single sign-on and API integration.
- It works on desktop and mobile, so your team can train wherever suits them.
Once you’ve sent your details, one of our team will be in touch to talk you through your training options.