Duration: 1 day
Remote Attendance: Click here for more information.
Course Description: This course covers different features of the interface, show students how to print, cover some simple scenarios and the basics of formatting. By the end of this course, students should be comfortable with creating a new spreadsheet, utilizing basic formulae, making a spreadsheet look professional and presentable, working with charts and graphic objects, and saving and printing a spreadsheet.
Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
Course Prerequisites: Students should be comfortable using the keyboard, mouse, and Start menu. No previous experience with other versions of Microsoft Excel is required.
|Identifying the Elements of the Excel Interface
||Creating a Basic Worksheet
|Creating Formulas in a Worksheet
||Inserting Functions in a Worksheet
|Inserting, Modifying, and Deleting Cells, Columns and Rows
||Searching For and Replacing Data
||Adding Borders and Colors to Cells
|Applying Number Formats
||Aligning Cell Contents and Applying Styles
|Defining the Basic Page Layout for a Workbook
||Refining the Page Layout and Apply Print Options
|Formatting and Managing Worksheet Tabs
||Managing the View of Worksheets and Workbooks
|Customizing General and Language Options
||Customize Proofing and Saving Options
|Customizing the Ribbon and Quick Access Toolbar
||Customizing the Functionality of Excel by Enabling Add-Ins
|Customizing Advanced and Trust Center Options
|Modifying and Formatting Charts
||Creating a Trendline
|Creating Advanced Charts
||Inserting and Modifying Graphic Objects
|Layering and Grouping Graphic Objects
Individual training passes: save up to 43%! For complete discount options » click here «
|# Courses||Total Cost||Cost Per Course||% Savings|