Meet Excel 2022: 9 of its best new features, from databases to handwriting tools - bulterthaders1937

I've just started exploring Stand out 2016. As one of the tentpole applications for the unused Office 2016, information technology has a quite a little of new features for lucky upgraders. Lease a closer look with me and see what you think.

1. Starring database enhancements

The database enhancements alone—which include merging few of the old Supplement programs so much as Power Pivot and Power Enquiry—more justify the upgrade. You'll find options for Power Queries; Data Models; Reports; Pivot Tables; Nonpareil-Click Forecasting; and some new, one-button workbook sharing through Power Bi for creating and using interactive reports and dashboards.

Quick psychoanalysis tools are a real timesaver, nudging you in the right direction with your information. After you've consummated your spreadsheet or table, select the entire roam. Note the lightning worksheet icon at the bottom right nook of the range: Click this icon, and a popup card appears that displays a one-half-dozen options for what to do with this information.

Note that from each one icon is a button/link to a submenu that provides more options (the selected icon turns dark green and nervy).

3. New charts

Excel has six brand-new charts to indicate off to your clients and colleagues. It's still an easy process to create them, too: Just play up the database table, select Introduce > Recommended Charts, then choose ace from the pictured samples.

Or, if you'Re not inclined to use unity of the recommendations, click the All Charts tab, select a category from the list, then select one of the designs from the pictured charts in this category.

We'll delve deeper into the new charts in an upcoming chromatography column, but hither are two to quicken your appetence:

Pareto sorts the bars by highest first and shows which bars have the biggest impact or highest income tax return. Function this chart data to decide where to assign your resources.

Waterfall (aka 'flying brick' chart) provides a visual method for viewing a series of sure and negative information, much as each month cash flows. Because the bars look to hover 'tween the commence and end columns, information technology looks sort of the like a falls, hence the name.

4. New templates

Excel's new templates come with sample information and charts, plus hands-on exercises that teach you how to use each templet.

08 Unprecedented template Cashflow—click the Let's Become Started button.

For example, in the My Cashflow templet, Excel encourages you to try the Stand out Information Model to manage your cash flow. Click the Net ball's Get going release, and Excel displays the My Cashflow charts. Mouse click the buttons 2013, 2014, or 2015 to see the chart data change by year.

09 New guide CashFlow chart

If you click the Go button, you can add some new information to the Sample Information spreadsheet, and so watch the charts change based on your new-sprung stimulus. Formerly you get the hang of it, honorable supercede Excel's sample data with some real data of your own and Excel does the rest. Strange new templates admit Timeworn Analysis and My Calendar.

5. 3D / Power Maps

These chromosome mapping tools were an board program in previous versions, but they'Re forthwith included in 2016. You can compare data such Eastern Samoa temperatures, operating theater rainfall, or populations of a given area terminated a mere time, rendered in trine-magnitude images.

You backside map out information (plot millions of rows of information visually on Bing maps), discover how data changes over time and space, and create and share stories (called Video recording Tours) about the entropy you've collected. Stay keyed for a complete review happening this excellent new feature in Excel 2016.

6. Easier coaction and sharing

Real-time collaboration is ultimately here. Ploughshare ideas, data, queries, reports; and Colorado-author worksheets, charts, graphs, Pivot Tables, databases, and more.

Click the Share button in the top right corner. When the Share panel opens, click the Save to Cloud button. The Backstage fare opens and displays the Spare Eastern Samoa screen. Choose the option that fits your situation—OneDrive, SharePoint, operating theater some other online location. Select the grade-appropriate folder and come home the Preserve clitoris.

Erstwhile saved, the document reappears with the Share panel open. In the Ask in People field of honor, click the open book icon and select colleagues from your address book in Outlook. Set permissions and notifications, and so click the Partake button to commit the document golf links to your designated colleagues.

7. Smart Lookup

This feature (available in most of the Business office 2016 programs) is like having the Internet on speed dial. Also called "Insights" from Bing, the information hails from various resources such as Wikipedia, the Oxford dictionary, Bing image lookup, and Bing Snapshot.

Just place your cursor connected any word or highlight any phrasal idiom on your spreadsheet and right on-clack. Take Smart Search from the dropdown list. The "Insights" dialog box opens happening the right and displays information and images about the subject you highlighted.

8. Tell Pine Tree State

Set happening the right side of the Ribbon menu after the last tab, this characteristic provides a search box with a light bulb that says "Tell me what you want to do." It's same your personal valet de chambre: Ask it a question, command it to suffice something, operating theatre select one of the Recently Used queries, and it obeys.

Just click the Tell Me box and type your wonder. A list boxful drops down with your current bespeak on clear; followed by jump choices (if thither are whatever); followed by the most Recently Utilized queries; followed by an option to select and purpose the official Help menus; followed by the Smart Search have, which adds the knowledge of the Net to help you get the right serve.

9. Ink Equations

This sunrise feature converts your written equations (or mathematical problems) to schoolbook, so you can insert them into your documents. You can use whatever tool works Charles Herbert Best for you—the mouse, a digital operating theater electronic stylus, or even your fingers—to indite the math equations/problems.

Just pick out Insert > Symbols > Equation, then chatter Ink Equation from the shed-down menu. A Preview blackboard box appears with writing tools displayed on the bottom.

That's every last for the big stuff, and Excel has a lot more surprises for its fans. Appease tuned for deeper dives into more than of the great features in Surpass 2016.

Source: https://www.pcworld.com/article/418577/meet-excel-2016-9-of-its-best-new-features-from-databases-to-handwriting-tools.html

Posted by: bulterthaders1937.blogspot.com

Share this post