Microsoft Excel is a powerful spreadsheet program that can provide you tools to help you work with your data. Solve complex mathematical problems with the many built in functions and formula. Share your information with others; limit their access where necessary and even monitor their changes.
Excel is one of the most common programs used by business professionals
Excel is used in many businesses to keep information easy to find, organized and updated. The data management features can help you with your financial models. This course will also review some of the basics to make sure you are up to speed before learning more advanced features.
Easily solve mathematical equations:
- Create financial forecast spreadsheets using the financial functions
- Manage data scenarios to look at results based on different inputs
- Manage data using subtotals, pivot tables and other data management tools
Easily work as a group on projects and combine information into one spreadsheet. Create templates to act as spreadsheet shells when you have worksheets that are used over and over again. This makes it easy to create new worksheets that uses that same formatting and functions, but have different input data.
Share your work with others:
- Work with the workgroup features for workbooks to share files, merge approved users changes or limit access
- Create templates
Benefit from the tools that Excel provides to make integrating with other programs a breeze. Share information easily between workbooks and worksheets and avoid duplicate data entry.
This course will teach you to:
- Import data into spreadsheet from other programs and use the data management functions
- Create three-dimensional workbooks, and link workbooks and worksheets
You don't have to be a computer programmer to write mini programs in Excel. Excel's macro recorder helps you write programs with ease.
Automate your tasks:
- Create macros and VBA applications that run set procedures automatically.
Prerequisites
This course is a continuation of the
Microsoft Excel for Beginners course. Students will need to have completed that course or be familiar with the topics covered in that class.
Requirements
Students will need a copy of Microsoft Excel. A 30-day trial is available.
Email this page