Sparklines
Sometimes you may want to analyse and view trends in your data without creating an entire chart. Sparklines are miniature charts that fit into a single cell. A Sparkline is a tiny chart in a worksheet cell that provides a […]
Read more →Month: June 2019
Slicers
Slicers are visual filters, introduced in Excel 2010. They are a powerful new way to filter pivot table data. Slicers provide buttons that you can click to filter PivotTable data. In addition to quick filtering, slicers also indicate the current […]
Read more →
People Graph
People Graph is a cool app for Office that transforms your cold data to vivid pictures. The new release includes eight new shapes, simplified data binding, and added new notifications and error handling. Most people are not aware of the nice […]
Read more →
Power Pivot (add-in) – an Introduction
PowerPivot is an add-in for Microsoft Excel that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables […]
Read more →
Clipboard Task Pane
When you copy a cell’s contents, formula or format, that information goes into the clipboard. The clipboard will hold the information until you decide to paste it somewhere else on the spreadsheet, or until you copy something new. Usually, the […]
Read more →
Excel keyboard shortcuts using function keys for Windows
Function keys F1 F1 alone displays the Excel Help task pane. Ctrl+F1 displays or hides the ribbon. Alt+F1 creates an embedded chart of the data in the current range. Alt+Shift+F1 inserts a new worksheet. F2 F2 alone edit the active […]
Read more →
Flash fill
Excel’s Flash Fill is a time-saving feature which fills in data for you when a pattern is evident. It can also can extract and insert as well as format and concatenate. This feature can even reverse text, numbers, dates and […]
Read more →
25 Very Useful Keyboard Shortcuts
To format any selected object, press ctrl+1 To insert current date, press ctrl+; To insert current time, press ctrl+shift+; To repeat last action, press F4 To edit a cell comment, press shift + F2 To autosum selected cells, press alt + = To see the suggest […]
Read more →
Conditional Formatting (Session3) – PRESETS
Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you’ll need to create a conditional formatting rule. Conditional Formatting Presets Excel has […]
Read more →
Conditional Formatting (Session2) – Formula-Based Conditional Formatting
Conditional formatting is a fantastic way to quickly visualize data in a spreadsheet. With conditional formatting, you can do things like highlight dates in the next 30 days, flag data entry problems, highlight rows that contain top customers, show duplicates, […]
Read more →