Blog Excel Courses
Basics,Advanced,Formatting,Function,Tables,Analyzing,Filtering Excel
SHARING WORKBOOKS Allowing Workbook Sharing Customizing Workbook Sharing Options Comparing and Merging Shared Workbooks
When you have completed this section you will be able to:
• Allow workbook sharing
• Customize workbook sharing options
• Compare and merge shared workbooks
IMPORTING DATA IMPORTING DATA TO EXCEL IMPORTING TEXT FILES Importing Text Files into Excel Importing Text using the Text Import Wizard
Importing Data to Excel/Why import data ?By
importing data, you don't have to retype the data you want to analyze in
Microsoft Excel. You can also update your Excel reports and summaries
automatically from the original source database whenever the database is
updated with new information If the information you have is in format other
than an Excel workbook format, then it needs to be imported and converted into
a recognized format by Excel in order to be manipulated within Excel.
TEMPLATES AND STYLES WORKING WITH TEMPLATES Creating a Template Applying Templates WORKING WITH STYLES Creating a Style Applying a Style Editing a Style Deleting a Style Copying Styles from another Workbook
Working
with Templates/Templates have the .XLT file extension. Templates contain
layout and formatting information, including text and graphics, layouts and
styles, headers and footers, formulas, and macros.
When
working with spreadsheets, you may wish to use the same layout or design. Instead of re-creating the design, you can
create a template.
Subscribe to:
Posts (Atom)