Category Archives: Excel

How to show all Formulas in Excel


To reveal all formulas in Excel Press Ctrl ~. Continue reading

Posted in Excel | Leave a comment

Basic Function


All functions follow a structure, they begin with = followed by the function name and a set of brackets. Continue reading

Posted in Excel | Leave a comment

Short Cut key for AutoSum


The shortcut key for AutoSum in Excel is Alt = Continue reading

Posted in Excel | Leave a comment

Naming cells in Excel


We create Range Names in Excel for cells that we might like to either: Quickly Navigate to , or to use in functions like Vlookup. If you select a range of cells and include the heading labels, however if the … Continue reading

Posted in Excel | Tagged | Leave a comment

How to create basic formulas in Excel


How to create basic formulas in Excel and understand the BODMAS rule – Order of operations Continue reading

Posted in Excel | Tagged | Leave a comment

How to capture dialog boxes


Alt print screen to capture dialog boxes Continue reading

Posted in Excel | Leave a comment

What is it with train and seat allocation


Train seating to slide or not to slide. Continue reading

Posted in Excel | Tagged | Leave a comment

Classic View – Pivot Tables


How to change Pivot Table Classic View. Options/ Display untick classic Pivot Table Layout. Continue reading

Posted in Excel | Leave a comment

Data Validation Lists


Create pre populated lists in Excel for efficient data entry purposes. Continue reading

Posted in Excel | Leave a comment

Custom view is greyed out


How to fix custom view being greyed out in Excel. Could be you have sheets grouped or you have Format as table activated. Custom view greyed out and i have no tables. Copy paste problem sheet to a new workbook. Training courses available: Analir Pisani 0414 417 059 Continue reading

Posted in Excel | Leave a comment