How to display the top n records in an Excel PivotTable using built-in options Your email has been sent In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet ...

Did you know that Microsoft Office applications offer a special tab? It’s called the Developer tab and it provides easy access to several unique but advanced features like writing macros and importing ...

When we open a document in Word or a spreadsheet in Excel, its name is displayed on the Title Bar of Word and Excel respectively. When we create a new document or spreadsheet, its default name is ...

Microsoft Excel is full of little tricks and features that are designed to make it easier for you to set up and manage your spreadsheets. Though unlike formulas — which can be used to automatically ...

How to create an Excel drop down list from another tab Your email has been sent The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news ...

Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...