Excel 2019 BIBLE Michael Alexander Dick Kusleika Previously by John Walkenbach 精彩文摘

Understanding What Excel Is Used For

Excel is the world’s most widely used spreadsheet software and is part of the Microsoft Office suite.

Other spreadsheet software is available, but Excel is by far the most popular and has been the world standard for many years.

Much of the appeal of Excel is its versatility. Excel’s forte, of course, is performing numerical calcu-lations, but Excel is also useful for nonnumeric applications. Here are just a few uses for Excel:

Crunching numbers Create budgets, tabulate expenses, analyze survey results, and perform just about any type of financial analysis you can think of.

Creating charts Create a variety of highly customizable charts.

Organizing lists Use the row-and-column layout to store lists efficiently.

Manipulating text Clean up and standardize text-based data.

Accessing other data Import data from a variety of sources.

Creating graphical dashboards Summarize a large amount of business information in a concise format.

Creating graphics and diagrams Use shapes and SmartArt to create professional-looking diagrams.

Automating complex tasks Perform a tedious task with a single mouse click with Excel’s macro
capabilities.