|
Working
with Cells
Working
with Files
Formatting
Worksheet
Setup
and Printing
Worksheetd
and Workbooks
Formulas
and Functions
Charts
and Objects
Importing
Exporting Data
Templates
Links Reports
Formatting
Sorting Filtering
Macros
and Toolbars
Validating
and Auditing
Data Analysis Tools
Sharing and Security
Training Courses Info and Order
Online Computer Training Courses
Fruta Vida
Fast Weight Loss
Vitamin Supplements
|
- Working with Cells shows how to enter and edit data in worksheet cells and how to create hyperlinks.
- Working with Files shows how to locate, open, and save files.
- Formatting Worksheets shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an worksheet.
- Page Setup and Printing shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in worksheets.
- Worksheets & Workbooks shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in worksheets.
- Formulas and Functions shows how to work with formulas and functions in worksheets.
- Charts and Objects shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in worksheets.
- Importing and Exporting Data shows users how to import data from other applications into Excel, query a database application to extract data, and export data from Excel to other applications.
- Working with Templates, Links, and Report Manager shows the user how to work with templates, link workbooks, and use Report Manager.
- Formatting, Sorting, and Filtering Data shows users how to format numeric data, create custom and conditional formats, sort and group data, use data forms for data entry and retrieval, and use filters to extract data.
- Naming Ranges, Working with Macros, and Customizing Toolbars shows users how to create and use named ranges, and how to use lookup functions. It also shows how to record, run, and edit a macro, as well as hide, display, and customize toolbars.
- Validating and Auditing Data shows users how to validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell.
- Analyzing Data and Using PivotTables shows users how to use data analysis tools such as Goal Seek, Solver, and scenarios. It also shows how to use PivotTables and PivotCharts.
- Sharing Work and Adding Security shows users how to work with cell comments, apply workbook protection, and share and merge workbooks.
Technical Requirements
200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.
Learning comes to life with challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. Our proven methodology provides an unequalled experience with exceptional results
Learning that's Easy, Convenient and Affordable! High-quality, online, self-paced courses designed to help you achieve your goals.
Affordable annual subscription plans give you unlimited access to an entire suite of topics at prices that you just won't find anywhere else.
Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.
Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.
|