Details 
|
This live virtual workshop is for business users who are currently using Microsoft Excel, but who want to take their skills to the next level. In this workshop, users learn powerful techniques that can help them save significant time, manipulate data and extract important business insights, present information in a compelling way, and collaborate with others more effectively. This is a summary of the main concepts presented and the features covered: 1. Data manipulation: Managing budgets and projections, as well as handling large lists of data. Basic and advanced formulas, 3-D ranges, sorting and filtering techniques, database functions, and several other features are covered. 2. Data presentation: Using the powerful analysis and reporting tools, such as PivotTables and charts, to extract important information, and present it appropriately to various audiences. This also includes formatting options, printing options, using hyperlinks, and web pages to make presentations more effective and more user-friendly. 3. Data entry and validation: Using Excel's ability to gather and validate data when applicable. This includes validation rules and conditional formatting, as well as using forms to easily enter, modify, and view data. 4. Collaboration: Enabling multiple users to review and edit workbooks by sharing them on the network or via e-mail. Protecting sheets or cells within a sheet to ensure data integrity and confidentiality. Tracking changes, reviewing changes, and accepting changes. 5. Efficiency: Using templates and styles to reuse worksheets, and to set standards and ensure consistency. This also includes dozens of shortcuts and tips that can be applied on a daily basis.
|
|
|
