Have you ever opened a blank workbook in Excel and just stared at it, wondering where to begin? Or, do you spend most of your time just formatting cells to make your spreadsheet look pretty? Or, do you just wonder if there is a better way to create your spreadsheets? This course is designed to take you from a blank worksheet to a completed report. Our example will be a financial statement but you can use the knowledge gained in the course and apply it to your specific job function.
DESIGNED FOR
Anyone who wants to improve their Excel skills
BENEFITS
After attending this presentation you will be able to...
- Recall best practices when creating reports in Excel
- Identify ways to reduce manual entries when creating reports in Excel
- Recognize features that are more efficient for creating reports in Excel
- Indicate how you can use PivotTables to provide more flexibility in Excel reports
HIGHLIGHTS
The major topics that will be covered in this class include:
- Best practices for creating a report in Excel
- Getting data into Excel
- Techniques to efficiently create reports in Excel
- Using PivotTables to create interactive reports in Excel
COURSE LEVEL
Basic
PREREQUISITES
A basic understanding of how to use Excel
ADVANCE PREPARATION
None