Excel Tutorials and Tips, Part 2

Here is my second post of the Excel Tutorials and Tips at excel.tips.net that cover a host of Excel features as detailed in the links below, which are what we have judged to be the best ones for each topic. To help you become a better Excel user, these Excel tutorials and tips assist you with creating lists of transactions, then using those list to create charts and other analysis tools. (Here is my part 1 post of the Excel learning material from this site.)


Excel Tools:
Various application components can be implemented in Excel. These components include Combo Box and Drop Down Lists. These tutorials explain how to implement them in you worksheet.
 - Adding and Using a Combo Box
 - Adding Buttons to Your Worksheet
 - Creating Dependent Drop-Lists
 - Tracing Errors
 - Creating Scenarios
 - Understanding Auditing
 - Comparing Lists for Duplicates
 - Goal Seeking
 - Hiding Outline Symbols
 - Inserting a Voice Annotation in Your Worksheet

Sorting in Excel:
Sorting data in a worksheet based on certain criteria is paramount to achieving user-understandable data. And these tutorials below explain the sorting process
 - Controlling Sorting Order
 - Creating a Sort Order
 - Determining Sorting Criteria
 - Fixing Odd Sorting Behavior
 - Ignoring Selected Words when Sorting
 - Non-standard Sorting
 - Sorting Data Containing Merged Cells
 - Sorting Dates by Month
 - Sorting Worksheets
 - Sorting while Ignoring Leading Characters

Excel Workbooks:
Workbooks in Excel are the files themselves. And each workbook can hold multiple worksheets. The tutorials below explain the intricacies of working with Workbooks.
 - Accessing a Problem Shared Workbook
 - Creating a Workbook Clone
 - Calculating Only the Active Workbook
 - Making Changes in a Group of Workbooks
 - Merging Many Workbooks
 - Opening a Workbook to a Specific Worksheet
 - Sharing Your Workbook
 - Updating Links in Copied Files
 - Using a Single Password for Multiple Workbooks
 - Automatically Protecting After Input

Data Entry in Excel:
These Data Entry tutorials deal with the shortcuts used to enter data quickly in an Excel worksheet.
 - Entering Dates in Excel
 - Entering Dates Without Separators
 - Entering Large Time Values
 - Jumping to the Start of the Next Data Entry Row
 - Modifying Default Year for Dates
 - Quickly Entering Dates and Times
 - Recording a Data Entry Time
 - Using Early Dates
 - Adding Pop-Up Documentation to a Cell
 - Specifying a Data Validation Error Message

Excel Data Validation:
Validating data in an Excel sheet is as important as data entry itself and these tutorials teach you to validate the data in an Excel sheet.
 - Adding Pop-Up Documentation to a Cell
 - Changing Fonts in Data Validation Drop-Down Lists
 - Ensuring Unique Values in a Column
 - External Data Validation
 - Limiting Entries to Numeric Values
 - Limiting Input to a Format
 - Setting Data Validation Input Messages
 - Specifying a Data Validation Error Message
 - Triggering a Macro for Drop-Down List Changes

Excel Charts:
We now move onto the visual aspect of Excel. Charts help evaluate values in two columns and display them as charts. The tutorials below have an in-depth coverage of Charts in Excel.
 - Changing Chart Size
 - Changing Elements in Lots of Charts at One Time
 - Deleting a Chart
 - Excel Charts in PowerPoint
 - Labeling X-Y Scatter Plots
 - Moving a Chart’s Legend
 - Positive and Negative Colors in a Chart
 - Reordering the Display of a Data Series
 - Unlocking Charts
 - Using Go To to Jump to a Chart Sheet

Excel Graphics:
As with any application in Microsoft’s Office suite, graphics can be inserted in Excel as well. These tutorials deal with creating autoshapes as well as inserting image files.     
 - Creating an AutoShape
 - Displaying Images based on a Result
 - Formatting the Border of a Legend.
 - Inserting from a Camera or Scanner
 - Moving Drawing Objects
 - Placing Textbox Text Into a Worksheet
 - ScreenTip for an Image
 - Smoothing Out Data Series
 - Styles for Lines, Dashes, and Arrows
 - Watermarks in Excel

Excel PivotTables:
One of the most powerful features of Excel is Pivot Tables which is a reporting tool works independent of the data layout in the Excel sheet. To further explore the power of Pivot Tables, the tutorials will help you.
 - Bogging Down with Calculated Items
 - Changing the Default PivotTable Functions
 - Editing PivotTables without Underlying Data
 - Excluding Zero Values from a PivotTable
 - Maintaining Formatting when Refreshing PivotTables
 - Missing PivotTable Data
 - Reducing File Sizes for Workbooks with PivotTables
 - Suppressing Zero Values in PivotTables
 - Text Truncated in PivotTable
 - Weighted Averages in a PivotTable

Excel Files:
The section below explain the different files in Excel and their uses.
 - Adding a File Path and Filename
 - Aligning Cells when Importing from CSV
 - Appending to a Non-Document Text File
 - Avoiding Scientific Notation on File Imports
 - Comma-Delimited Differences for PC and Mac
 - Converting from SuperCalc
 - Correctly Saving Delimited Files
 - Creating a CSV File
 - Faster Text File Conversions
 - How Excel Treats Disk Files

Excel Add-Ins:
An Excel Add-In is a file that loads when Excel starts. This file can contain additional functionality to Excel, and the tutorials below explain how Excel Add-Ins work.
 - Automatically Loading Add-ins
 - Excluding a Specific Add-In at Startup
 - Removing Add-ins
 - The EDATE Function
 - Understanding Add-Ins
 - Using Custom Add-Ins
 - Converting Units
 - Finding the Analysis ToolPak Add-In
 - Adding a Report
 - Using the Report Manager

Online and Web:
The tutorials below explain Excel’s ability to interface with the web, including generating a web page with it.
 - Automatic Text in an E-mail
 - Extracting URLs from Hyperlinks
 - Get Rid of Web Stuff
 - Linking to a Specific Page in a PDF File
 - References to Hyperlinks Aren’t Hyperlinks
 - Retrieving Web Query Data without Interruption
 - Connecting To a Discussion Server
 - Filtering Web Discussions
 - Adding Excel Information to a Web Page
 - Generating a Web Page

Working with Other Programs:
Excel can also interface with other applications such as AutoCAD and Lotus 1-2-3, thereby allowing users to exchange data between them. Thee tutorials further explain this concept.
 - Exporting from Excel to AutoCAD
 - File Formats that Include Field Formats
 - Ignoring Other Applications
 - Importing Huge Data Files
 - Working with Lotus 1-2-3 Spreadsheets
 - Preparing Data for Import into Access
 - Snapshots of Excel Worksheets for PowerPoint
 - Working with Imperial Linear Distances
 - Embedding Fonts in Excel
 - Word Documents from Excel Macros

General Excel Tutorials:
The tutorials below follow a general theme of interacting with Excel providing file properties and editing custom dictionaries.
 - A Ruler in Excel
 - Additional Ways of Displaying a Hidden First Column
 - Backing Up Your AutoCorrect Entries
 - Changing Error Checking Rules
 - Changing Excel’s Starting Date
 - Controlling Display of Page Breaks
 - Determining Your Version of Excel
 - Editing Custom Dictionaries
 - Embedding Fonts in Excel
 - Finding Commands in Excel 2007

Popularity: 24% [?]