Duration: 1 Day
Lesson 1: Getting Started with Excel
• An Overview of Excel
• Navigate in Excel
• Select Data
• Enter Data
• Save a Workbook
• Obtain Help
Lesson 2: Modifying a Worksheet
• Move and Copy Data between Cells
• Fill Cells with Series of Data
• Edit Cell Data
Duration: 1 Day
Lesson 1: Creating and Applying Templates
• Create a Workbook from a Template
• Create a Custom Template
• Working with Comments
• Create a Hyperlink
• Use Web-based Research Tools
Lesson 2: Creating and Modifying Charts
• Create a Chart
• Format Chart Items
• Change the Chart Type
• Create a Diagram
Read more »
Duration: 2 Days
Course Content
Lesson 1: Streamlining Workflow
• Create a Macro
• Edit a Macro
• Customize Access to Excel Commands
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook’s Properties
• Modify Excel’s Default Settings
About this Course
Course length: 1 day
Course Description
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development. Read more »
