Description
Streamline financial reporting and analysis by using Excel’s limitless features.The emphasis of this intermediate Excel class will provide timesaving techniques that will allow you to utilize the builtin features of Excel for analysis of data and perfection of reports. Learn the most commonly used functions and tools for successful reporting. Microsoft Excel skills are invaluable for a business. Whether creating reports or analyzing data, Microsoft Excel makes managing and tracking a breeze. Increase your productivity and effectiveness as a professional.
Date: 2022-04-26 Start Time: End Time:
Learning Objectives
Tips and Review
• Customizing Lists
• Utilizing Filters and Data Validation
• Quick Formatting Tricks
Creating and Working With Multiple-Sheet Files
• Creating a Multi-Sheet Workbook
• Writing a 3-D Formula for Calculations
• Formatting Multiple Sheets Simultaneously
• Creating Links Between Workbooks
Excel Formulas
• Nested Subtotals
• Using IF Functions (Conditional Statements)
• VLOOKUP Formulas and Arrays
• Understanding PivotTables and PivotCharts
Using Text Functions
• Using the Text to Columns Feature
• Using the Concatenate Function
• Using the TRIM Function
• Using the Upper, Lower, and Proper Text Functions
• Using the Paste Values and Paste Specials Feature
Charting Data in Excel
• Creating Combination and Specialty Charts
• Changing Chart Options
AIPB ,ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.
Lauritta Sowa-WiseOwlOps, Inc.
