Frequently Asked Questions

	Via email and the various search engines we receive a number of requests. For the best result, retype your question into the search bar next door and search for exactly where on this site the answer is. Alternatively, to see all the types of questions scroll down. Otherwise here is a brief summary of what this site offers.	Web AuditExcel.co.za

Below we have summarized some of the more common questions. Look below (or use the search facility at the bottom) to find out where on the site we can help you. 

Your Excel Answers	The Question!
Categories All the functions and formula split into the various categories as per Microsoft Excel.	excel formulas tutorial, excel functions tutorial, excel function tutorial, free excel formulas, what are the functions of spreadsheet, exel formula, formula 1, free online excel commands, making formulas in excel spreadsheets tutorial, formulas in excel, dsum, dcount, daverage
PDF to Excel Easy method to convert PDF files to Excel	Convert PDF files to editable Word, Excel, HTML or Text files! Able2Extract is a simple and fast solution. No Risk, Download a FREE Trial Now! CLICK HERE
Debt Not sure why but we often get asked about debt, debt consolidation etc. Our basic advice is try and avoid debt where possible and think about your retirement plans. We have put together a page on retirement planning, so see how you are doing!	excel spreadsheet debt consolidation, debt free excel spreadsheet, debt,  debt consolidation,  debt management,  debt help,  debt relief,  consolidate debt,  debt consolidation loan,  debt reduction,  debt free,  debt solution,  business debt,  debt consolidation services, vba code debt management, debt management spreadsheet, debt consolidation spreadsheet, debt reduction excel, debt reduction excel spreadsheet, retirement planning,  retirement planning spreadsheet, retirement spreadsheet, financial planning for retirement, retirement planning calculator, retirement income planning, retirement planning services, retirement investment planning, retirement planning tool, early retirement planning, retirement planning software
Financial The financial functions that have been developed for excel. Especially useful for corporate finance!	pmt, cumipmt, excel cumprinc, cagr, compound annual growth
Sarbanes Oxley and Spreadsheets Thoughts and ideas on the SOX and spreadsheets. What the risks are and how to address them.	spreadsheet controls, sox, spreadsheet control, sox spreadsheet testing, benefits of spreadsheets, sox spreadsheets, backup formula, change control spreadsheet, benefits of using spreadsheets, spreadsheet for sox, sox spreadsheet controls, excel spreadsheet version control, spreadsheet policies, spreadsheet control test plan, various spreadsheet controls sox, spreadsheet controls sox, "risk inventory", spreadsheet testing, auditing with excel, excel helpful in risk management, "spreadsheet audit", sox act, spreadsheet test audit, risk management spreadsheets, spreadsheet control excel, testing of spreadsheets,it controls, spreadsheet controls sarbanes, auditing co, sarbanes-oxley spreadsheets, ms excel change control version control sox, spreadsheet in an organisation, sarbanes-oxley, protecting excel sarbanes spreadsheet password, sarbanes-oxley spreadsheet controls, spreadsheet control sarbanes oxley, sarbanes, excel input control,
Statistics Microsoft excels statistical functions	excel rank function guide.
Text Microsoft excels test functions	excel help concatenate, join contents of two columns,
VLOOKUP Due to its popularity, we have created an entire page on VLOOKUP. What it is, how to use it, what the risks are!	excel database tutorial, excel vlookup tutorial, lookup excel, vlookup tutorial, nested vlookup, vlookup excel tutorial, vlookup tutorials, vlookup in vba, v lookup excel, how to use vlookup in excel, learning excel vlookup, excel tutorial vlookup financial modeling, excel vlookup help, microsoft excel vlookup, excel tutorial vlookup, vlookup, excel, excel vba vlookup, excel vlookup problem, microsoft online training vlookup, vlookup+excel, vlookup-excel, vlookup excel help, microsoft excel, vlookup, microsoft excel v lookup, vlookup tool, excel vlookup training, vlookup how to, nesting vlookup, help with the vlookup command on microsoft excel, "learn excel" vlookup, vlookup + excel, tutorial on v lookup in ms excel, excel vlookup examples, vlookup in excel macro, "vlookup tutorial", vba excel vlookup, tutorials on vlookup function in excel, vlookup vba, use vlookup in vba, spreadsheet vlookup, excel lookup, excel, vlookup tricks, vlookup excel guide, vlookup on excel, excel problems vlookup, vlookup training, excel vlookup function exercise, excel vlookup video, training on vlookup, help with vlookup in excel, excel lookup tutorial, vlookup examples in excel, how to use transpose in excel, vlookup microsoft excel, "excel" and "vlookup", v lookup excel tutorial, excel vlookup problem, free excel vlookup instructions, free training on excel vlookup, microsoft excel vlookup example, how to do vlookup, linked workbooks, vlookup excel examples, vlookup online tutorial, excel vlookup errors, excel tutorial v lookup, vlookup exel example, advanced vlookup in excel, how to perform a vlookup in excell, swap excel column into rows, vlookup problem, vlookup in vba excel, examples of vlookup, excel vlookup not working, excel vlookup example,
What If Some of the more useful functions and tools in Excel when it comes to what if and breakeven analysis.	excel solver tutorial, break even spreadsheet, break even analysis, breakeven analysis, decision modelling with spreadsheets, break-even analysis spreadsheet, spreadsheet break even analysis, break-even spreadsheet, corporate finance models, "breakeven formula", break even analysis in excel, corporate finance help, choose function, excel break even formula, break even analysis,excel,
Basics A selection of video clips relating to the basics of using Microsoft Excel, i.e. what everyone should know	auditing toolbar, excel audit tool, excel auditing, excel spreadsheet design, spreadsheet audit, spreadsheet auditing, spreadsheet design, excel auditing toolbar, excel formula audit.
Dates Some useful functions in Excel for handling dates.	excel calendar, free excel calendar.
How some errors happen Excel tutorials that show you how errors happen with some functions.	excel vlookup problems, problems with vlookup, spreadsheet error, spreadsheet risk, spreadsheet risks, vlookup error, vlookup errors, vlookup problems, excel spreadsheet errors, absolute referencing in excel spreadsheet, excel #ref! error, #ref! excel error, spreadsheet error check, spreadsheets errors.
Logical Movie clips on how to use the logical features e.g. IF, AND, OR etc	excel if commands, excel tutorial if, if commands in excel,
Lookup and Reference Tutorials on how to use the VLOOKUP function.	excel vlookup, how to use vlookup, v lookup, vlookup, vlookup example, vlookup examples, vlookup excel, vlookup help, vlookup in excel, vlookup in excel, how to use vlookup, nested vlookup, vlookup function, vlookup formula, nesting vlookup, excel vlookup function, vlookup tutorial, vba vlookup, excel formula vlookup, excel vba vlookup, vlookup function in excel, excel vlookup help, microsoft excel vlookup, vlookup excel example.
Other tools Some of the other tools in Excel that provide significant functionality	excel find external links, excel find replace special characters, excel find special characters, excel replace special characters, find external links excel, find external links in excel, find link excel external, using find across the entire workbook, excel pivot table tutorial, excel chart tutorial, excel tutorial pivot, excel charts tutorial, excel pivot tables tutorial, excel graph tutorial, group and ungroup data in excel, find and replace in excel, excel replace * character, excel conditional format, excel replace "special characters", "find external links in excel", how to replace special characters in excel, autofilter 3 criteria, excel go to special, build audit trail in excel, excel + find + replace, external link information in excel, replace special characters in excel, excel replace special character, linked spreadsheets, find replace excel, excel highlight links, excel "find external links", excel "go to special", risk management with excel, find excel external links, linking cells in excel, excel "find special characters", find special characters excel.
Spreadsheet Professional Learn more about the Excel add-in that we distribute	break even analysis spreadsheet, breakeven analyses, break-even analyses, breakeven analysis spreadsheet, breakeven formula, breakeven spreadsheet, sensitivity analysis excel, spreadsheet comparison, spreadsheet comparison tool, compare spreadsheet, compare spreadsheets, spreadsheet compare, compare two spreadsheets, auditing excel spreadsheets, comparison spreadsheet, excel tool chartered accountants, excel for audit, spreadsheet audit tool, excel audit tools, audit, audit spreadsheet software, "spreadsheet professional", spreadsheet auditing tool, auditing using excel, excel auditing tool, formula audit analysis excel results, audit excel spreadsheet, how to compare spreadsheet, spreadsheet analyses, auditing as a tool for it problems and solution., spreadsheets comparisons, free excel tools, excel model audit, professional spreadsheet, comparison of spreadsheets, excel audit software, spreadsheet auditing software.
Tips and Tricks Various tips and tricks for using Microsoft Excel	excel tips, excel tip and trick, excel automatic sorting, automatic sorting in excel, automatic sorting excel, automatic sort excel, cagr excel, league table spreadsheet excel, how do you calculate the cagr excel, "tricks in excel".
Home Page For some of the queries it is useful to understand all the products and services we provide, which are available on the home page.	audit excel, audit spreadsheet, audit spreadsheets, auditing, auditing excel, auditing in excel, auditing spreadsheets, excel as audit tool, excel audit, excel risk management, excel spreadsheet audit, risk management excel, risk management spreadsheet, types of spreadsheet, types of spreadsheet software,
What we Don't Do We believe strongly that macros and VBA use in Excel should be limited. If a spreadsheet requires significant macros and VBA, you should probably not be using Excel.	excel macro, excel vba.
War Stories Spreadsheet errors are starting to have a real impact on the business world. This page gives an up to date record of the recent losses.	excel errors, spreadsheet error losses, spreadsheet errors.
Training Index We have compiled a number of video clips showing you how to use the various aspects of Microsoft Excel.	advanced excel, advanced excel training, excel chart, excel class, excel exercise, excel formula, excel function, excel help, excel lesson, excel manual, excel model, excel models, excel online training, excel pivot table, excel spread sheet, excel spreadsheet, excel spreadsheet controls, excel spreadsheet formula, excel spreadsheet help, excel spreadsheet problems, excel spreadsheet solutions, excel spreadsheet training, excel spreadsheets, excel template, excel time sheet, excel timesheet, excel tip, excel tip and trick, excel training, excel training course, excel tutorial, excel tutorials, exel, features of spreadsheet, financial model, financial modelling, financial spreadsheet, free excel, free excel download, free excel lesson, free excel spreadsheet, free excel spreadsheets, free excel template, free excel training, free excel tutorial, free microsoft excel, free microsoft excel download, free microsoft excel tutorial, free spreadsheet training, how to use excel, how to use microsoft excel, learn excel, learning excel, macro en excel, microsoft excel, microsoft excel formula, microsoft excel help, microsoft excel training, microsoft excel tutorial, professional spreadsheets, spreadsheet, spreadsheet formula, spreadsheet formulas, spreadsheet functions, spreadsheet help, spreadsheet modelling, spreadsheet problems, spreadsheet professional, spreadsheet solutions, spreadsheet training, spreadsheet use, tutorial excel, excel macro tutorial, ms excel tutorial, excel 2003 tutorial, advanced excel tutorial, excel 2000 tutorial, online excel tutorial, in excel tutorial, excel online tutorial, basic excel tutorial, tutorial for excel, excel 2002 tutorial, excel tutorial for, excel formula tutorial, excel spreadsheet tutorial, tutorial microsoft excel, excel advanced tutorial, excel tutorial online, excel xp tutorial, for excel tutorial, tutorial on excel, excel tutorial advanced, excel 97 tutorial, tutorial in excel, excel microsoft tutorial, basic tutorial excel, excel tutorial pdf, tutorial for microsoft excel, microsoft excel 2000 tutorial, excel tutorial download, excel tutorial and, excel tutorial on, tutorial on microsoft excel, office excel tutorial, tutorial excel 2003, basic for excel tutorial, tutorial de excel, excel tutorial in, download excel tutorial, advance excel tutorial, tutorial excel xp, tutorial excel formulas, tutorial excel 97, download tutorial excel, en excel tutorial, tutorial de excel en, tutorial de excel avanzado, tutorial de excel gratis, tutorial excel avanzado, tutorial excel gratis, tutorial excel pdf, free excel tutorials, free online excel training, free excel help, using microsoft excel macro, exel training, learn exel, free excel training online, excel use, exel download, excel training free, tutorials, free excel formula, online excel training, "excel training", excel+tutorials, "free excel training", free spreadsheet, business excel spreadsheets, excel modelling exercise,template, free online vba video, free online training on ms-excel, free lesson in excel, macro exel tutorial, free online excel tutorials, 'microsoft excel training', "free excel tutorials", spreadsheet modeling, free audio excel tutorial, online excel test, the model solution clip, ms excel, excel spread sheets, combine excel spreadsheets, fancy excel spreadsheets, free online spreadsheet, excel training material, learn excel free, free online advanced excel tutorials, excel macros using video, microsoft exel, world cup spreadsheet, excel training online, excel solution, miricle solutions, excel training software, auditing + cpa + cfa, professional excel spreadsheets, link excel filters into one spreadsheet, "free microsoft excel tutorial", link data between sheet in excel, "advanced excel training", free formulas for excel, professional skills audit, modeling with spreadsheet solution download, "free microsoft excel download", index function excel, use of spreadsheet in research, spreadsheet free, free excel online, excel highlights all cells, excel spreadsheet review, microsoft excel tutorials, free advanced excel tutorial, spread sheet help, free microsoft excel training, excel skill, advanced excel function tutorial video download free, free excel vba training, using excel, for dummies, excel free formulas, free online excel test, building excel models, excel project, spreadsheets use, help with exel, benefits of using a spreadsheet, professional looking excel, excel macros + timesheet excel, free online excel tutorial, online excel exercise, free microsoft excel tutorials, excel spreadsheet free, "free excel tutorial", free online excel manual, benefits of a spreadsheet, timesheet template, free training vba, address spreadsheet, exercise +excel +spreadsheet, free exel, free excel questions, excel spreadsheet downloads, online spreadsheet training, free excel courses, find special characters in excel, spreadsheet benefits, excel free online tutoring, excel training pdf, complex excel spreadsheets, free spreadsheet solutions, free excel learning, advanced excel video based tutorials, free excel manual, excel solutions,

Quote of the page: Questions are never indiscreet. Answers sometimes are.- Oscar Wilde

Terms and Conditions:

Please visit our Terms and Conditions page to understand how you can use this free resource.