|
Provided by: Act Training Excel Level 2Computer |
 |
Training
Provided by Act Training
Intermediate level one day hands-on instructor led course on Microsoft Excel. Topics include: Creating Embedded Charts, Creating Chart Sheets, Modifying Charts, Formatting a Chart, Using Graphic Objects to enhance worksheets and charts, Sorting Data, Filtering Data (including setting multiple condition criteria).
The prerequisite for this course is Excel Level 1 or equivalent knowledge.
Related Software Programs or Products: Microsoft Excel
|
|
||||||||||||
Excel Level 2
Lesson 1: Creating Charts
Creating a Chart Sheet using a shortcut key
Creating an Embedded Chart
Comparing Chart Sheets with Embedded Charts
Lesson 2: Modifying Charts
Chart Types
Modifying Embedded Charts
Adding and Deleting Chart Items
Moving and Sizing Chart Items
Lesson 3: Formatting a Chart
Formatting Chart Text
Formatting Labels
Formatting the Chart
Printing a Chart Sheet
Lesson 4: Using Graphic Objects
Adding Graphic Objects
Formatting Graphic Objects
Using Graphic Objects to Enhance Worksheets and Charts
Lesson 5: Sorting Data
Single-level Sorting
Multiple-level Sorting
Sorting Options
Importing Data
Design Considerations
Lesson 6: Filtering Data
Filtering a List
Custom Criteria
Multiple-condition Criteria
Managing a Filtered List
Creating a Chart Sheet using a shortcut key
Creating an Embedded Chart
Comparing Chart Sheets with Embedded Charts
Lesson 2: Modifying Charts
Chart Types
Modifying Embedded Charts
Adding and Deleting Chart Items
Moving and Sizing Chart Items
Lesson 3: Formatting a Chart
Formatting Chart Text
Formatting Labels
Formatting the Chart
Printing a Chart Sheet
Lesson 4: Using Graphic Objects
Adding Graphic Objects
Formatting Graphic Objects
Using Graphic Objects to Enhance Worksheets and Charts
Lesson 5: Sorting Data
Single-level Sorting
Multiple-level Sorting
Sorting Options
Importing Data
Design Considerations
Lesson 6: Filtering Data
Filtering a List
Custom Criteria
Multiple-condition Criteria
Managing a Filtered List
About The Training Provider: Act Training
Act Training - We provide training in Computer Applications such as Microsoft Word, Excel, PowerPoint, Access, Outlook, Sage Accounts and Sage Payroll; Professional IT subjects such as CompTIA A plus, CompTIA N plus, MCP, MCSA, MCSE and CISCO; Office skills such as Bookkeeping, Accounting, Pitman & Teeline Shorthand, OCR Text Processing and Keyboard skills.
These subjects are taught on site for individuals...
