Microsoft Publisher is a very effective desktop publishing program that helps you design and develop professional quality documents, including creating newsletters, flyers, logos, signs, forms and much more.  With Publisher's features, you can also combine text, graphics, illustrations, and photographs.  Publisher also uses additional tools over and above those usually found in word processing packages.  The application also includes design templates, graphic manipulation tools, color schemes, and multiple page wizards and templates.

Anderson School District in Pendleton, SC, has provided the following Publisher Tutorial.  It teaches you how to use many features of Publisher, such as creating an advertising flyer, adding color and border to a text frame and editing graphics.  All of the features demonstrated here are also available in Publisher 2003.

Microsoft Publisher Tutorial
(pdf format, 5 pages, 148kb)

• Starting Publisher
• Creating an Advertising Flyer
• Editing Text
• Graphics
• Adding Color and Border to a Text Frame:
• Adding an Attention Getter:
• Saving
• Newsletters
• Importing a File into a Newsletter
• Editing Personal Information Components
• Editing Attention Getters
• Editing the Graphics
• Inserting a Line with Arrows

Here are a total of 187 Excel articles, tutorials, and examples for learning how to create, work with, and use Excel Formulas. These learning materials are hosted by three Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, which host over 500 excellent Excel Articles and Tutorials.

187 Excel Formula Tutorials and Examples

• Absolute References
• Adding every other cell in a column with =SUM(MOD…
• Array to Columns
• Array-CSE Further Uses
• Array-CSE Uses
• Array-CSE Entering using Conditional Sum Wizard
• Arrays-CSE
• Attendance Tracker using COUNTIF
• AutoAverage - using the dropdown next to AutoSum to access other functions
• Automatically add a character in a cell
• Automatically get the date and time with =NOW() Function
• Auto-Update Charts upon entering new data
• Averaging Highest-Lowest
• Averaging Range Values
• Avoid error displays in formulas
• Avoiding error displays in formulas
• Calculating a conditional average
• Calculating Age and Birthdays
• Car Loan Payments in Excel with =PMT() function.
• Calling a Function
• Cell Value vs. Displayed Text
• Change a Cell Value without Changing the Formula
• Changing #N/A to "Your Response" text with =IF()
• Changing 'All Caps' to proper text with =PROPER()
• Changing Cell References
• Changing grades (in numeric format) to Letter Grades with =VLOOKUP
• Changing Numbers to Text
• Color -Shading Cells
• Compare ranges by using an array-CSE-formula
• Concatenate values: (Bringing two cell Values together as one)
• Concatenating a cell with text and a cell with a date
• Concatenation
• Conditional Formatting - Referencing another sheet
• Conditional Sum Wizard
• Convert 11.5 to 11 minutes and 30 seconds
• Convert Text to Proper Case
• Coordinates - Degrees, Minutes, Seconds
• Count Between Two Values
• Count Text or Numeric Entries with COUNTA instead of COUNT
• CountIF in an Array-CSE
• CountIf or Sumif with two conditions
• Counting Cells with specific content with =COUNT
• Counting distinct entries in a range
• Creating a "Mega-formula"
• Creating proper names format with =PROPER()
• Custom Function: Parsing with characters
• Dates in Excel from TechTV
• DATEDIF to find the difference between dates
• Dates -Adding and Subtracting
• Dates -As Intervals
• Dates - Calculating # of Days from Today
• Dates -Creating a Series
• Dates -DATEDIF Function
• Dates -Day of the Week(Month)
• Dates -Day of the Week(Year)
• Dates -Determining Quarters
• Dates -Difference Between
• Dice in Excel using RANDBETWEEN
• Dates -Distributing
• Dates -Easter Calculation
• Fill a Range with Weekdays
• Dates -First and Last Day of the Month
• Dates -First Monday
• Dates -Julian
• Dates -Leap Years
• Dates -Number of days in a month
• Dates -Thanksgiving Calculation
• Dates -The day of the year and days remaining
• Dates - Live formula to calculate Today
• Dates -Two Digit Year
• Dates -Week Numbers (ISO)
• Duplicate Entry - Identify
• Duplicate Tooltip over DDE Formula
• Dynamic Range
• Find and Replace
• Find the elapsed time between two time entries
• Find the longest entry in a range of text entries
• Finding an average between two data sets
• Finding Minimum and Maximum Values
• Force a global recalculation
• Formatting Time Values
• Formula Auditing
• Formula to add years to a given date
• Fractions in Excel
• Grades -Calculating and Converting
• Have an IF statement return "Yes"-"No" with =IF
• Hiding your formulas
• High and Low Values - =MAX
• Holidays -Calculating
• How to calculate and display the largest value with =MAX
• How to create a "Top 9"
• How to Reverse the Sign on a Difference
• INDEX(MATCH())
• INDIRECT
• Joining two Columns
• Joining Text in two columns with the Concatenation Operator
• Keeping a running total in an adjacent column with =SUM
• Latitude and Longitude
• Lists -Auto-Numbering
• Lists -Common to Two Lists
• Lists -Minimum and Maximum Values
• Lists -Transpose (Reverse) Order
• Lists -Unique to One of Two
• Loan Payments in Excel with =PMT() function.
• Lookup -Closest Match
• Lookup -Multiple Criteria
• Lookup -Return Value to Left
• Magic Squares in Excel
• Math Exercise Sheets in Excel using RANDBETWEEN
• Matching Lists vith VLOOKUP
• Merge Values to One (using Area Code and Phone Number)
• Most or Least Common Value
• Multiply Hours by Rate
• Named Range
• Naming a Worksheet as the value of a target cell with =INDIRECT Function
• Nested Function
• No Blank Cells
• Ordinal Numbers
• Parsing Dates with =MID Function
• Parsing -Names
• Parsing -Phone Numbers
• Parsing phone numbers with =MID Function
• Paste Special Values to prevent #REF! errors
• Perform two-way table lookups
• Pricing -Bracketing and Progressive
• Proper Case - Changing a Name to Proper Case
• PROPER() function to convert text to upper and lower case
• Random Samples with RAND
• Range -Convert to Columns
• Range -Dynamic
• Range -Named
• Range -Transpose
• Range -Used Cells
• Range -Variable
• Ranking Data
• Ranking without repetitive ranks with =RANK and =COUNTIF
• Referencing a sheet indirectly
• Referencing Cells
• Relative Cell References
• Return End Of Month Date with =DATE
• Return File Name
• Return Nth Value
• Returning specific data on examining a range
• Returning Zero instead of #N/A with =IF()
• Round time to the nearest quarter hour
• Round values to the nearest fraction
• Rounding Numbers with =CEILING
• Rounding numbers with =ROUND
• Rounding time to a specific value
• Rounding to n significant digits
• select Random numbers from a column with =RAND()
• Show Formulas
• Splitting the contents of a cell/column into two distinct cells/columns
• Strings -Counting Characters
• Strings -Counting Characters
• Strings -Extracting Words from a String
• Strings -Most or Least Common
• Sum Every Nth Value
• Sum only the visible cells
• Sum the largest values in a range
• SUMIF in an Array - CSE
• SUMIF to conditionally sum data
• SumIf with two conditions
• Summing times that exceed 24 hours
• Text and values in one cell
• Text value response to input with =IF
• Time -Adding and Subtracting
• Time - Adding When Total is over 24 hours
• Time -Between Two Dates
• Time -Calculating Overtime
• Time -Quick Entry Method
• Time -Range last Updated(Not available after Excel '97)
• Time -Rounding
• Transforming Data With Formulas
• Transpose a Range
• Unique Entries -Counting
• Unique Entries -Extracting
• Unique Entries -Ranking
• Use Index and Match to lookup a cell to the left of your key cell
• VLOOKUP
• Use absolute references when tracking student grades
• Working with Dates with =DATE
• Working with time formats with =TEXT
• Worksheets -Referencing Previous and Next
• Worksheets -Return Sheet Name
• Write a Formula that always points to the same column, but is free to move to different rows as it is copied
• Zero Values-Ignoring

Here is a comprehensive linked list of 67 Excel articles, tutorials, and tips covering Excel Add-ins, Excel Charting and Graphing, and Pivot Tables. These learning materials are hosted by three excellent Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, all together containing over 500 Excel Articles and Tutorials.

These Excel articles and tutorials are presented in this post within these categories:

Add-Ins for Excel - Find out where to get Excel add-ins and how to use them.

Charts and Graphing in Excel - Learn how to Chart and Graph in Excel, from beginning to end.

Pivot Tables - Learn this important Excel data analysis feature.

9 Add-Ins for Excel

• Add-Ins - Free, Third-Party Add-Ins
• Analysis Tool Pack-Excel
• Cool accessories for Excel
• Empower Excel with the amazing DigDB Add-In
• Games in Excel
• The Spreadsheet Assistant for Excel
• Use MathEasy Add-In to simplify entering math formulas
• Using the Analysis ToolPack
• Using the Small Business Financial Manager in Excel with Quickbooks Data
  

31 Charting and Graphing Excel Tutorials

• Add a Trendline with 3 clicks
• Business Diagrams & Org Charts
• Charting with Time on the X-axis
• Charting Tips
• Create a Chart with 1 Keystroke
• Create a Time Line
• Creating a thermometer style chart
• Creating a transparent chart series
• Creating combination charts
• Demonstrate fractions with a pie chart
• Drawing with Excel - grid paper
• Expand the Chart Range
• Extend the Data Range
• Extending with Data Points
• Format Charts with Right-Click
• Histogram - Create a Dual Sided Histogram in Excel
• Gantt Chart with Conditional Formatting
• Handle missing data in a line chart
• In-cell Column Chart
• Layouts for column charts
• Multiple charts on a single Chart sheet
• Non-graphic chart directly in a range
• Saving a chart as a GIF file
• SmartArt Graphics in Excel 2007
• Speedometer Charts in Excel
• Students creating bar charts for survey data
• Summarize Data using a Pivot Charts
• Tips for the 'Perfect Chart'
• Track Progress Towards a Goal
• Track Student Reading Progress with a Dynamic Chart
• Thermometer Charts

27 Excel Tutorials on Pivot Tables

• Access Data with Pivot Tables to Break Through Excel's 65,536 row limit
• Add Median to Pivot Tables with DigDB's One-Step-Summary
• Advanced Pivot Table Tips
• Cursor Meaning when Dropping Fields on a Pivot Table
• Monthly Summarizing
• Pareto Analysis with Pivot Tables
• Percent of Total in a Pivot Tables
• Pivot Charts
• Pivot Table: Use the Group Feature to Change to Monthly or Annual Output
• Pivot Tables: Consistent Colors on all Charts
• Pivot Tables: Correct Out-of-Sequence Data
• Pivot Tables: Group Daily Report up to Months
• Pivot Tables: Top 10 Customer Report with Top 10 AutoShow
• Pivot Tables: Use AutoFormat with Pivot Tables
• Pivot Tables: Use VBA to Print All Page Fields
• Pivot Tables: Use VBA to Transform Data for Optimal Analysis
• Pivot Tables to analyze market research data
• Pivot Tables to Summarize Data
• Produce a report for every department with Show Pages
• Replace Pivot Tables with DigDB's One-Step-Summary
• Summarize Data by the Hour( =Hour() )
• Summarizing data with a pivot table
• Seasonality Analysis with a Pivot Tables
• Summary Table to Database Table
• Unique list of customers with a Pivot Tables
• Using Edit - GoTo to Clean up your Pivot Table
• What is a Pivot Table?

Allen Wyatt's Word Tips provides you over 1,600 free tips and tricks on how to use Word better, faster, and more easily. You can quickly access the answers you need in two ways:

1. Find a topic or feature area below that you need to learn more about, then click on the link. (A bracketed number after a topic indicates the number of articles related to that topic.)
   
2. Enter your question or keywords in the search box at the top-right corner of every page.

Search for answers:
  

Information in this Word learning resource site covers several versions of Microsoft Word, including Word 97, Word 2000, Word 2002, and Word 2003. Tips are clearly marked as to the versions to which they apply.

Over 1600 Microsoft Word Tips

• Bullets and Numbering [52]

• Creating Documents [3]

• Customizing Word [81]

• Editing [331]

• Fields [108]

• Files [139]

• Find and Replace [71]

• Footnotes and Endnotes [38]

• Formatting [494]

• General [80]

• Graphics [163]

• Headers and Footers [25]

• Languages [6]

• Macros [358]

• Master and Subdocuments [8]

• Online and Web [30]

• Outlines [12]

• Printing [172]

• Shortcut Keys [47]

• Sorting Information [11]

• Styles [40]

• Tables [125]

• Templates [25]

• Tools [363]

• Using the Mouse [12]

• Word's Environment and Interface [112]

• Working with Other Programs [23]

The Microsoft Office Specialist Certification program (MOS) provides computer program literacy, measures proficiency, and identifies opportunities for skills enhancement. Successful candidates receive an Office Specialist certificate that sets them apart from their peers in the competitive job market. Microsoft’s MOS (Microsoft Office Specialist) certification is meant for people in any industry and with various job roles who want to demonstrate a high-level of proficiency in the various Office applications: Word, Excel, Access, PowerPoint, and Outlook.. The Microsoft Office Specialist program is the only comprehensive, performance-based certification program approved by Microsoft to validate desktop computer skills using the following Microsoft Office programs:

• Microsoft Word
• Microsoft Excel
• Microsoft Outlook
• Microsoft PowerPoint
• Microsoft Access
• Microsoft Project

Here are several free training documents and tutorials that will help you study and pass the Microsoft Office Certifcation Exams for each given application. These tutorials and practice exams will help you learn and master the Microsoft Office applications, you can use and study these even if you are not planning to take the exam(s). The Cramsession training documents here (pdf format) are available after you register for free.

Word XP MOS Practice Exams with Answers

• MOS Microsoft MOS-WXP v03 19 04 082q
• MOS Microsoft MOS-WXP v04 08 05 082q

Excel XP MOS Practice Exams with Answers

• MOS Microsoft MOS-EXP v10 13 04 084q
• MOS Microsoft MOS-EXP v04 01 05 084q
• MOS Microsoft MOS-E2E v05 12 05 030q

Outlook XP MOS Practice Exams with Answers

• MOS Microsoft MOS-OXP v03 18 04 083q
• MOS Microsoft MOS-OXP v04 07 05 083q

PowerPoint XP MOS Practice Exams with Answers

• MOS Microsoft MOS-P2K v04 16 04 032q

Access XP MOS Database Practice Exams with Answers

• MOS Microsoft MOS-AXP v03 22 04 082q
• MOS Microsoft MOS-AXP v05 23 05 082q

 

MOS XP Cramsession Study Guides

• Access XP / 2002 Study Guide
• Excel XP / 2002 Study Guide
• Outlook XP / 2002 Study Guide
• PowerPoint XP / 2002 Study Guide
• Word XP / 2002 Study Guide

MOS XP Cramsession Expert Study Guides

• Excel XP / 2002 Expert Study Guide
• Word XP / 2002 Expert Study Guide

MOS 2000 Cramsession Study Guides

• Access 2000 Study Guide
• Excel 2000 Study GuideOutlook 2000 Study Guide
• Powerpoint 2000 Study Guide
• Project 2000 Study Guide
• Word 2000 Study Guide

MOS 2000 Cramsession Expert Study Guides

• Excel 2000 Expert Study Guide
• Word 2000 Expert Study Guide