microsoft office excel
, , , , , ,

How to Create Dynamic Cascading List Boxes In Excel

You may know how to create cascading validation drop down list in Excel. However, how to create dynamic cascading list boxes in Excel? This article introduces a VBA method to get it down.As below screenshot shown, you need to create a parent…
microsoft office excel
, , , , , ,

How To Extract first letter of each word from sentence in Excel

Supposing you have a list of countries’ name in your worksheet, and now, you need to extract the first letter of each word in the cell as following screenshots shown. Normally, there is no direct feature to pick up the first letter of each…
microsoft office excel
, ,

94. Excel: Complete list of Keyboard Shortcuts: Categorywise

This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel for Windows. This includes the access keys that you can use for Ribbon commands. FREQUENTRLY USED SHORTCUTS If you're new to…
microsoft office excel
, ,

93. Excel: General Keyboard Shortcuts

MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel.Ctrl + A − Selects all contents of…
microsoft office excel
, ,

92. Pivot Tables

A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form of a table) or in an external data file. A pivot table can help transform endless rows and columns of numbers…
microsoft office excel
, ,

91. Data Tables

In Excel, a Data Table is a way to see different results by altering an input cell in your formula. Data tables are available in Data Tab » What-If analysis dropdown » Data table in MS Excel.Data Table with Example Now, let us see…
microsoft office excel
, ,

90. Pivot Charts

A pivot chart is a graphical representation of a data summary, displayed in a pivot table. A pivot chart is always based on a pivot table. Although Excel lets you create a pivot table and a pivot chart at the same time, you can’t create a…
microsoft office excel
, ,

89. Simple Charts

A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets. Charts generated by early spreadsheet products were quite crude, but thy have improved significantly over the years.…
microsoft office excel
, ,

88. Securing Workbook

We can apply security to the workbook by the concept of protection available in the Review Tab of ribbon. MS Excel's protection-related features fall into three categories.Worksheet protection − Protecting a worksheet from being modified,…
microsoft office excel
, ,

87. Translating Worksheets

You can translate the text written in a different language, such as phrases or paragraphs, individual words (by using the Mini Translator), or translate your whole file with MS Excel 2010.Translation is available in the review tab of the…