Home  >   Excel

Microsoft Excel

Microsoft Excel Foundation

Microsoft Excel Intermediate

Microsoft Excel Advanced

Microsoft Excel Expert


Microsoft Excel Foundation

• Getting Started
• Starting Out
• What is Microsoft Excel?
• Opening Microsoft Excel
• Interacting with Excel
• Closing Excel
• Step-By-Step
• About Workbooks
• Creating a New Workbook
• Opening a Workbook
• Saving a Workbook
• About Excel File Types
• Closing a Workbook
• Step-By-Step
• Skill Sharpener
• Exploring your Workbook
• Using Worksheets
• The Active Cell
• Selecting Cells
• Exploring a Worksheet
• The Zoom Feature
• Step-By-Step
• Skill Sharpener
• Getting Help in Excel
• Using the Help Screen
• About Online Help
• About Offline Help
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• The New Interface
• The Quick Access Toolbar
• The Default Buttons
• Adding Buttons
• Removing Buttons
• Customizing the Toolbar
• Step-By-Step
• Skill Sharpener
• The Home Ribbon
• Clipboard
• Font
• Alignment
• Number
• Style
• Cells
• Editing
• Step-By-Step
• Skill Sharpener
• The Insert Ribbon
• Tables
• Charts
• Illustrations
• Shapes
• Links
• Text
• Step-By-Step
• Skill Sharpener
• The Page Layout Ribbon
• Themes
• Page Setup
• Scale to Fit
• Sheet Options
• Arrange
• Step-By-Step
• Skill Sharpener
• The Formulas Ribbon
• The Function Library
• Defined Names
• Formula Auditing
• Calculation
• Step-By-Step
• Skill Sharpener
• The Data Ribbon
• Get External Data
• Connections
• Sort and Filter
• Data Tools
• Outline
• Step-By-Step
• Skill Sharpener
• The Review Ribbon
• Proofing
• Comments
• Changes
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Excel Basics
• Working With Excel
• Columns, Rows, Cells, and Ranges
• Creating Worksheet Labels
• Entering and Deleting Data
• Printing Your Worksheet
• Step-By-Step
• Skill Sharpener
• Basic Excel Features
• What is AutoFill?
• What is AutoSum?
• What is AutoComplete?
• Working with Basic Formulas
• Step-By-Step
• Skill Sharpener
• Moving your Data
• Dragging and Dropping Cells
• How to Cut, Copy, and Paste Cells
• How to Cut, Copy, and Paste Multiple Cells and Items
• How to Use Paste Special
• How to Insert and Delete Cells, Rows, and Columns
• Using Undo, Redo, and Repeat
• Step-By-Step
• Skill Sharpener
• Smart Tags and Options Buttons
• What Are Smart Tags?
• The Error Option Button
• The AutoFill Option Button
• The Paste Option Button
• Setting Smart Tag Options
• Step-By-Step
• Skill Sharpener
• Editing Tools
• Using AutoCorrect
• Using Spell Check
• Using Find and Replace
• Adding Comments
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Editing Your Workbook
• Modifying Cells and Data
• Changing the Size of Rows or Columns
• Adjusting Cell Alignment
• Rotating Text
• Creating Custom Number and Date Formats
• Step-By-Step
• Skill Sharpener
• Cell Formatting
• Conditional Formatting
• The Format Painter
• Cell Merging and AutoFit
• Find and Replace Formatting
• Step-By-Step
• Skill Sharpener
• Enhancing a Worksheet’s Appearance
• Adding Patterns and Colors
• Adding Borders
• Working with Styles
• Step-By-Step
• Skill Sharpener
• Working With Charts
• Creating a Chart
• Formatting a Chart
• Modifying Charts with the Layout Ribbon
• Manipulating a Chart
• Enhancing a Chart with Shapes and Graphics
• Step-By-Step
• Skill Sharpener
• Working with Charts, Part 2
• Changing the Type of Chart
• Changing the Source Data
• Working with the Chart Axis and Data Series
• Saving a Chart as a Template
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Printing and Viewing your Workbook
• Using the View Ribbon
• Using Normal View
• Using Full Screen View
• Using Page Layout View
• Page Break Preview
• Step-By-Step
• Skill Sharpener
• Managing a Single Window
• Creating a New Window
• Hiding a Window
• Unhiding a Window
• Freezing a Pane
• Step-By-Step
• Skill Sharpener
• Managing Multiple Windows
• Switching Between Open Workbooks
• Arranging Workbooks
• Comparing Workbooks Side by Side
• Synchronous Scrolling, Resetting a Window, and Saving a Workspace
• Step-By-Step
• Skill Sharpener
• Printing your Workbook
• Opening Print Preview
• Using the Print Preview Ribbon
• Quick Printing
• The Print Dialogue
• Using Page Setup
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions


Microsoft Excel Intermediate

• Advanced File Tasks
• Using My Computer within Excel
• Using the My Places Toolbar
• Navigating with My Computer
• Performing Basic Tasks with My Computer
• Changing Views
• Step-By-Step
• Skill Sharpener
• Saving your Files
• File Formats
• File Properties
• AutoRecover
• Upgrading a Workbook
• Step-By-Step
• Skill Sharpener
• Using Templates
• Opening a Template
• Downloading a Template
• Using a Template
• Creating a Template
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Working with Functions and Formulas
• Using Formulas in Excel
• Understanding Relative and Absolute Cell References
• Basic Mathematical Operators
• Using Formulas with Multiple Cell References
• The Formula Auditing Buttons
• Fixing Formula Errors
• Displaying and Printing Formulas
• Step-By-Step
• Skill Sharpener
• Exploring Excel Functions
• What are Functions?
• Finding the Right Function
• Some Useful and Simple Functions
• Step-By-Step
• Skill Sharpener
• Using Functions in Excel
• Inserting Functions
• Using Functions and AutoFill to Perform Difficult Calculations
• Using the IF Function
• Working with Nested Functions
• Step-By-Step
• Skill Sharpener
• Working with Names and Ranges
• What Are Range Names?
• Defining and Using Range Names
• Selecting Nonadjacent Ranges
• Using AutoCalculate
• Step-By-Step
• Skill Sharpener
• Working with Array Formulas
• What are Array Formulas?
• Using Basic Array Formulas
• Using Functions with Array Formulas
• Using the IF function in Array Formulas
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Managing Tables
• Working with Tables
• What is a Table?
• Creating Tables
• Modifying Tables
• What is the Total Row?
• Step-By-Step
• Skill Sharpener
• Working with Records and Fields
• What are Records and Fields?
• Adding Fields by Inserting Columns
• Adding Records by Inserting Rows
• Quickly Adding Records to a Data Table
• Deleting Records or Fields
• Step-By-Step
• Skill Sharpener
• Working with Tables and Filters
• Sorting Data in a Table
• What is an AutoFilter?
• Custom AutoFilters
• Using an Advanced Filter
• Copying Filtered Records
• Step-By-Step
• Skill Sharpener
• Using Excel as a Database
• Filtering with Wildcard Characters
• Validating Your Data
• What are Database Functions?
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Enhancing your Workbook
• Customizing your Workbook
• Inserting a Symbol or Special Character
• Adding and Editing Shapes
• Creating and Altering Diagrams
• Changing the Diagram Type
• Incorporating Text
• Adding a Signature Line
• Step-By-Step
• Skill Sharpener
• Working with Text Boxes
• Adding a Text Box
• Selecting a Text Box
• Manipulating a Text Box
• Formatting a Text Box
• Step-By-Step
• Skill Sharpener
• WordArt
• Adding WordArt to your Spreadsheet
• Changing the Font Color
• Changing the Outline Color
• Adding Effects
• Step-By-Step
• Skill Sharpener
• ClipArt
• Finding ClipArt
• Inserting ClipArt
• Manipulating ClipArt
• Inserting a Photographic Image
• Step-By-Step
• Skill Sharpener
• Using Objects
• Creating New Embedded Objects
• Embedding Existing Files
• Editing Embedded Objects
• Embedding Parts of Files
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Finalizing Your Workbook
• Protecting your Workbook
• Protecting your Workbook
• Protecting your Worksheets
• Unlocking Cells
• Protecting your Excel Files
• Step-By-Step
• Skill Sharpener
• Finishing Your Workbook
• Using the Document Inspector
• Using the Compatibility Checker
• Marking a Workbook as Final
• Step-By-Step
• Skill Sharpener
• Using Excel in Word
• Inserting Excel Data in Word
• Linking Excel Data in a Word Document
• Modifying Excel Data after Insertion
• Insert an Excel Chart into a Word Document
• Step-By-Step
• Skill Sharpener
• Using Excel and Access
• Linking an Excel Workbook to an Access Database
• Importing Table, PivotTable, and PivotChart Data from Access
• Transforming an Excel Workbook into an Access Database
• Step-By-Step
• Skill Sharpener
• Using Excel With other Programs and Files
• Using Outlook to Send Excel Data
• Opening an Excel File in a Different Format
• Importing Data from a Text File
• Importing Data from External Data Sources
• Publishing a Workbook as a PDF File
• Faxing a Workbook
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions


Microsoft Excel Advanced

• Advanced Topics
• Setting Excel Options
• Changing Your User Name
• Changing your Default Font
• Changing Your Default File Format
• Setting Formula Options
• Changing the Appearance of Your Excel Interface
• Step-By-Step
• Skill Sharpener
• Excel and Windows
• Searching for Documents
• Using Office Diagnostics
• Checking for Updates
• Starting Excel Automatically when Windows Boots
• Step-By-Step
• Skill Sharpener
• Using the Excel Viewer
• What is the Excel Viewer?
• Downloading the Excel Viewer
• Using Excel Viewer
• Step-By-Step
• Skill Sharpener
• Review Questions
• Getting the Most From Your Data
• Getting The Most From Your Data
• Using Automatic Outlining
• Displaying and Collapsing Levels
• Grouping Data Manually
• Creating Subtotals
• Step-By-Step
• Skill Sharpener
• PivotTables
• What is a PivotTable?
• Creating a PivotTable
• Creating a PivotTable Frame
• Specifying PivotTable Data
• Rearranging PivotTable Data
• Step-By-Step
• Skill Sharpener
• More About PivotTables
• Modifying PivotTable Calculations
• Formatting a PivotTable
• Refreshing a PivotTable
• Charting a PivotTable
• Creating a PivotTable Based on External Data
• Step-By-Step
• Skill Sharpener
• Exploring Scenarios
• What is a Scenario?
• Creating a Scenario
• Creating a Scenario Summary Report
• Saving Multiple Scenarios
• Step-By-Step
• Skill Sharpener
• What If Analysis
• Using a One and Two Input Data Table
• Using Goal Seek
• Using Solver
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Excel and the Internet
• Excel and Hyperlinks
• What is a Hyperlink?
• Inserting Hyperlinks
• Modifying Hyperlinks
• Using Hyperlinks in Excel
• Step-By-Step
• Skill Sharpener
• Saving Workbooks as Web Pages
• HTM and MHTML Files
• Saving a Workbook as a Web Page
• Saving a Worksheet as a Web Page
• Saving a Chart as a Web Page
• Saving a Range as a Web Page
• Step-By-Step
• Skill Sharpener
• Getting Data from the Internet
• Importing from an External Data Source
• Creating a Web Query
• Saving a Web Query
• Refreshing a Web Query
• Step-By-Step
• Skill Sharpener
• Excel and Office Servers
• Publishing to a Document Server
• Saving to a Document Management Server
• Using Excel with Excel Services
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Advanced Excel Tasks
• Creating and Using Shared Workbooks
• Sharing a Workbook
• Opening and Editing a Shared Workbook
• Tracking Changes
• Resolving Conflicts in a Shared Workbook
• Step-By-Step
• Skill Sharpener
• Using Custom AutoFill Lists
• What is an AutoFill List?
• Creating a Custom AutoFill List
• Modifying a Custom AutoFill List
• Using a Custom AutoFill List
• Step-By-Step
• Skill Sharpener
• Using the VLOOKUP Function
• Using VLOOKUP to Find Data
• How to Find an Exact Match with VLOOKUP
• Finding the Closest Match with VLOOKUP
• Step-By-Step
• Skill Sharpener
• Linking, Consolidating, and Combining Workbooks
• Linking Workbooks
• Consolidating Workbooks
• Combining Worksheets
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions


Microsoft Excel Expert

• Add-ins, Smart Tags, and Digital Security
• Add-ins and the Trust Center
• What is a COM Add-in?
• Add-In Management
• Installing Add-ins
• Using the Trust Center
• Add-Ins
• Step-By-Step
• Skill Sharpener
• Information Rights Management
• What is IRM?
• Requirements for IRM
• Downloading and Installing the Rights Management Client Software
• Using IRM
• Opening an IRM Protected Document
• Step-By-Step
• Skill Sharpener
• Digital Signatures
• What is a Digital Signature?
• Obtaining a Digital Signature
• Attaching your Signature to a Workbook
• Step-By-Step
• Skill Sharpener
• Smart Tags and XML
• What is a Smart Tag?
• Inserting Smart Tags into a Worksheet
• Setting Smart Tag Options
• Creating Custom Smart Tags
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Macros, VBA, and Excel Programming
• Macros
• Recording Macros
• Playing a Macro
• Macro Security
• Step-By-Step
• Skill Sharpener
• More Macro Tasks
• Recording a Relative Reference Macro
• Running a Relative Reference Macro
• Assigning a Keystroke to a Macro
• Copying a Macro from a Workbook or Template
• Step-By-Step
• Skill Sharpener
• Visual Basic and Macros
• Opening the Visual Basic Editor
• Adding Code to your Macro
• Adding Comments to VBA Code
• Declaring Variables
• Prompting for User Input
• Iteration over a Range
• Using IF Then Else Statements
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Expert Topics
• Form Controls
• What is a Form Control?
• Adding a Control to a Worksheet
• Assigning a Macro to a Control
• Using Form Controls
• Step-By-Step
• Skill Sharpener
• Advanced Functions
• Using Financial Functions
• Understanding Logical Functions
• Applying Logical Functions
• Step-By-Step
• Skill Sharpener
• Using SharePoint
• Creating a Document Workspace
• Accessing a Workspace
• Publishing to a Document Workspace
• Step-By-Step
• Skill Sharpener
• User Forms and ActiveX Controls
• Creating a Blank User Form
• Adding Controls to the Form
• Adding Buttons and VBA Code
• Starting the User Form with a Macro
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions

Contact Us
+1 (514) 868-6262
Name:
e-mail:
Phone:
Country:
Programs:
Comments/Questions:
CAPTCHA Image

Different Image
www.collegecanada.com          www.collegecanada.com          www.collegecanada.com          www.collegecanada.com/ielts.php          http://collegecanada.com/aca_lan_tesol.php          www.collegecanada.com/tef.php          www.collegecanada.com/tefaq.php
Montreal: 1118 Sainte-Catherine W. #403, Montreal, Quebec, H3B 1H5 Tel: 514 868 6262 Fax: 514 868 0869 info@collegecanada.com
Toronto: 180 Bloor street West suite 1102, Toronto, ON, Canada, M5S 2V6 Tel: 416 926 0540     www.ccet.ca     study@ccet.ca