Excel

Colorado Computer Training, Ltd.
Fort Collins, Colorado, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Understanding Excel
Examining the Projects
Examining the Excel Window
Entering Text and Formulas
Entering and Editing Data
Working with Columns and Rows
Understanding Formulas
Understanding Functions
Using Paste Function
Entering More Formulas
Moving and Copying Data
Looking at the Office Clipboard
Cutting, Copying and Pasting
Moving Cells
Using Fills
Exploring Formula Construction
Understanding Cell References
Using Relative/Absolute References
Using More Functions
Formatting Worksheet Appearance
Adjusting Rows and Columns
Formatting Numbers
Aligning/Formatting Text
Applying Borders and Shading
Working with and Understanding Charts
Creating/Modifying Charts
Printing Worksheets
Adjusting Page Setup
Setting Up Headers and Footers
Setting Print Titles and Options
Setting Print Areas
Using Help - Appendix
Using the Help Window
Using the Contents Card
Renaming Worksheets
Moving Worksheets
Using Lists
Working with Databases
Sorting Lists
Using AutoCorrect
Understanding Paste Function
Using Logical Functions
Using Financial Functions
Using Date Functions
AutoFormatting Worksheets
Formatting Worksheets
Using Page Breaks
Working with Objects
Using 3-D References
Understanding 3-D Workbooks
Linking Worksheets
Showing Formulas and References
Using Excel and the Web
Understanding the Web
Saving as Different File Types
Working with Web Pages
Using Templates
Customizing Templates
Entering Data
Using Microsoft Map
Working with Data Maps
Adding Data to Data Map Objects
Reconfiguring Data Maps
Using Templates
Working with Records and Ranges
Using Data Forms
Using Named Ranges
Formatting Numbers
Using Custom and Conditional Formatting
Sorting Lists
Using Macros
Using Grouping and Outlines
Applying Data Filters
Understanding Advanced Filters
Understanding Importing
Importing from Text Files
Querying Databases
Importing from HTML Files
Exporting to Other Applications
Creating PivotTables
Adjusting PivotTables
Showing and Hiding Information
Using PivotTable Pages
Using PivotTables and the Web
Creating PivotCharts
Using Data Analysis Tools
Using Solver
Understanding Scenarios
Understanding Goal Seek
Auditing a Worksheet
Protecting and Sharing Workbooks
Applying Protection and Sharing
Setting File Passwords and Properties
Using Data Validation
Using Comments
Tracking Changes
Merging/Linking Workbooks
Printing Worksheets and Reports
...''

Phone:(970) 222-2535

School Address:

731 Bonita Ave
Fort Collins, CO 80526 USA

Jobs & Resumes: Fort Collins
Houses & Roommates: Fort Collins

MS Access
Outlook
PowerPoint
FrontPage
MS Word

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.