Create
decision-making formulas by using range names and advanced functions.Display and
protect worksheet data by hiding and displaying columns and protecting cells.
Summarize data from several workbooks by creating and modifying formulas that link
workbook files
Troubleshoot and analyze data by using the @ ISERR function and the Backsolver.
Analyze information by substituting different sets of data into specified ranges by
using versions and version group.
Automate repetitive task by creating and running macros and scripts.
Enhance a worksheetJ ,s appearance by using a designer frames and style templates, and
print large worksheets by using print titles and changing the page orientation.
Customize the 1-2-3 work area by modifying an existing SmartIcon set and creating a
customized SmartIcon set; and work with the Internet by using built-in internet tools.