Excel 2010 Help and How-to | Excel 2010 Training | Excel 2010 Videos

Make the switch to Excel 2010

Training Are you switching to Excel 2010 from a previous version? This course is for you.

Getting started with Excel 2010

Article If you know Excel 2007, used an earlier version of Excel, or have never used Excel before, explore these resources to begin learning how to use the latest...

Get to know Excel 2010: Create your first spreadsheet

Training New to Excel? Learn how to create a spreadsheet, do basic math, create and format column titles, freeze the top row, and set some printing options.

Office 2010 Security: Protecting your files

Training In Microsoft Office 2010, when files open, Message Bars can alert you to useful information and potential problems with your files. Security Message Bars...

Get to know Excel 2010: Create formulas

Training Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions) to calculate things like monthly payments.

Download Office 2010 training

Article Get free, downloadable versions of many Office 2010 training courses. They’re in PowerPoint 2010 format, so you can customize them for group training or...

VLOOKUP: What it is, and when to use it

Training You may have heard of the VLOOKUP function, and you may have heard reasons why you should use it. But what does it do, exactly? In this training course...

Understand data at a glance with conditional formatting

Training Have you heard about conditional formatting? Get hands-on practice using conditional formatting to make data stand out.

Sparklines: Use tiny charts to show data trends

Training Overview As you look at rows and rows of data, sometimes it’s hard to immediately make sense of it. Add tiny charts called sparklines next to data to...

Use Excel tables to manage information

Training Learn how to use Excel tables to sort and filter data, get special table formatting, and see table formulas auto fill.

The IF function: what it is, and how to use it

Training Overview The IF function checks to see if a condition you specify is true, or false. If true, one thing happens; if false, something else happens. For...

How to create a basic chart in Excel 2010

Training Learn how to create a chart and how to make changes to a chart after you create it.

Save time by creating and running macros in Excel 2010

Training Overview Do you find yourself doing the same actions over and over again in your spreadsheets? Did you know you can create macros so that Excel can do...

Figure out dates by using formulas in Excel 2010

Training Figure out dates by using formulas in Excel 2010 Overview Use formulas to figure out dates such as how many workdays until vacation, or calculate the...

Plan payments and savings in Excel 2010

Training Learn how to use financial functions in Excel formulas to figure out payments and savings

Excel 2010 keyboard shortcuts I: CTRL key shortcuts

Training Learn Excel 2010 keyboard shortcuts. Learn CTRL key shortcuts that let you do everything from selecting and editing cells, to inserting cells, rows, and columns.

Excel 2010 keyboard shortcuts II: ALT key shortcuts

Training Learn how to use ALT key shortcuts that let you access almost any command in Excel 2010. These keyboard shortcuts are also called access keys, and they...

Saving a site as a template

You can save a site as a template at any time using the template option (Save site as template) on the Site Settings page in SharePoint. SharePoint Designer 2010 make it easy by providing a Save as Template option in the ribbon, which takes you to this page in SharePoint. Once you save the template, a solution file is created and stored in the Solution Gallery where you can download or activate the solution.

To save your site as a template using SharePoint Designer 2010, perform the following steps:

1. Open your site in SharePoint Designer 2010.

2. On the Site tab, in the Manage group, click Save as Template

 3.This takes you to the Save as Template page in SharePoint.

4. Specify a name to use for the template file in the File name field.

5. Specify a name and description for the template in the Template name and Template description fields.

6. To include the content of the site in the site template, check the Include Content box.

Note: Including the content of the site can increase the size of the template significantly. Keep in mind that the default size limit for a site template is 50 MB but may be less in your organization.

7. Click OK to save the template.

8. If all of the components on the site are valid, the template is built, and you see a message that says Operation Completed Successfully.

9. To download or activate the solution from the solution gallery, click the user solution gallery link and follow the steps in the procedure below.

10. Or, to return to your site, click OK.

 

Activating the site template in the solution gallery

Once you’ve saved your site as a template, a solution file (.wsp) is created and stored in the Solution Gallery for the site collection. From here, you can download or activate the solution.

To activate your site template, perform the following steps:

1. Browse to the top level site of your site collection in SharePoint.

2. Click Site Actions and choose Site Settings.

3. Under Galleries, click Solutions.

4. To activate your solution, click the pull-down menu beside your solution, and choose Activate

5. On the activate solution confirmation screen, click Activate.

Your solution now has an activated status in the Solution Gallery.

6. To download the solution, just click its name in the Solution Gallery.

7. In the File Download dialog box, click Save, and browse to the location where you want to save the solution.

What gets saved in a template

When you save your SharePoint site as a template, you’re saving the overall framework of the site. Most of the objects in a site are included and supported by the template.

There are a number of objects and features not supported however.

Supported

Lists

Libraries

External Lists

Data source connections

List views and data views

Custom forms

Workflows

Content Types

Custom Actions

Navigation

Site pages

Master pages

Modules

Web Templates

Not Supported

Customized permissions

Running workflow instances

List item version history

Workflow tasks associated with running workflows

People/group field values

Taxonomy field values

Publishing pages and publishing sites

My Sites

What is a SharePoint site template

SharePoint site templates are pre-built definitions designed around a particular business need. You can use these templates as they are to create your own SharePoint site and then customize the site as much as you like. You’re probably familiar with the default site templates, like Team Site, Blog site, and Group Work Site as shown here.

You can create your own site template based on a site you’ve created and customized in SharePoint. This is a powerful feature in SharePoint that allows you to create a custom solution and then share that solution with your peers, the broader organization, or outside organizations. You can also package the site and open it in another environment or application like Microsoft Visual Studio and further customize it there.

When you save your site as a template, you create a Web Solution Package, or WSP. A WSP is a CAB file with the solution manifest. The solution you create gets stored in the Solution Gallery for the SharePoint site collection. From there, you can download a copy of the solution or activate it on the server.

Installing SharePoint Designer

Choose the 32-bit or 64-bit version of Microsoft Office

Article Office 2010 is available in both 32 bit and 64 bit versions. 64 bit Office 2010 is good if you work with much larger sets of data. If not, we’re recommending...

Keep earlier versions of Office programs when installing Office 2010

Article This article warns that earlier versions of Office are removed when you install Office 2010. It also tells how to keep the earlier version of Office programs.

Activating SharePoint Designer

Activate Office 2010 programs

Article To activate an Office 2010 program, you must enter your 25-digit product key, if you haven't already done so during Setup.

Activate volume editions of Office 2010

Article If you are using this computer at work, you might be using a volume edition of Microsoft Office 2010.

Find the Product ID for your Office program

Article The Product ID, also known as PID key or PID, is specific to your Microsoft Office 2010 license and is verified during product activation . After your Office...

SharePoint Designer 2010 SP1

Microsoft SharePoint Designer 2010 Service Pack 1 (SP1) provides the latest updates for SharePoint Designer 2010.

This service pack includes two main categories of fixes:

• Previously unreleased fixes that were made specifically for this service pack. In addition to general product fixes, these fixes include improvements in stability, performance, and in security.

• All the public updates that were released through June 2011, and all the cumulative updates that were released through April 2011. 

How to obtain and install the service pack

To download the service pack from Microsoft Update, visit the following Microsoft website: Microsoft Update

Download the SP1 package from Microsoft Download Center

Download the Microsoft SharePoint Designer 2010 32-bit Service Pack 1 package now.

Download the Microsoft SharePoint Designer 2010 64-bit Service Pack 1 package now.

An unexpected error has occurred

Problem Description:

If you try to import a spreadsheet from within SharePoint Designer 2010 to create a list in SharePoint 2010 then you will get an error

"An unexpected error has occurred."

What exactly I am doing:

1.   Browse to a SharePoint site

2.   From the Site Settings menu click on "Edit In SharePoint Designer"

3.   Within SharePoint Designer, choose left menu "Lists and Items"

4.   From the Ribbon menu click "List from Spreadsheet"

5.   SharePoint Designer will launch the SharePoint site within a browser

6.   Add a title on the list and choose File then click Import

7.   You will get error message "An unexpected error has occurred"

After hours of troubleshooting and debugging, I got this issue resolved by using the following workaround.

Workaround:

1.   The URL when you try to load the page from SharePoint Designer will look something like the following and it will not work:

          http://server/_layouts/new.aspx?ListTemplate=SpreadsheetImport

2.   Append to the URL on the page that is being called from Sharepoint Designer with the following and reload the page.

          &ListBaseType=0&DisplayName=Spreadsheet+Import

Example:

http://server/_layouts/new.aspx?ListTemplate=SpreadsheetImport&ListBaseType=0&DisplayName=Spreadsheet+Import

I hope the above mentioned information will help you to resolve your issue. If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happyJ to help you as well as resolves your issues J J

Create and open sites by using SharePoint Designer 2010

Save a SharePoint site as a template

Article With Microsoft SharePoint Designer 2010, you can design and build robust SharePoint applications that include a rich set of data sources, customer-facing...

Managing SharePoint Designer 2010

Article SharePoint Designer 2010 Is a powerful web and application designer program for Microsoft SharePoint 2010 technologies. You use SharePoint Designer to create...

Video: Configure site security using SharePoint Designer 2010

Video Learn how to configure site security using SharePoint Designer 2010 by SharePoint MVP Asif Rehmani

Create SharePoint site pages

Article In Microsoft SharePoint Designer 2010, you can quickly and easily add pages to a SharePoint site and then customize those pages in the browser or in...

Master pages

Introduction to SharePoint master pages

Learn about master pages in SharePoint 2010 and how to customize them in SharePoint Designer 2010

Working with content placeholder controls

Article Master Pages contain a set of controls that define replaceable content regions on a page. Each content placeholder control on the master page can be mapped...

Customize a master page to brand your site

Article Master Pages provide the look and feel for all of the pages in your site. By changing the styles or content of the master page, you can quickly change the...

Customize your My Site master page

Article Master Pages provide the look and feel for all of the pages in your site. By changing the styles or content of a master page, you can quickly change the...

Data Views and forms

Create a custom list form using SharePoint Designer

Article SharePoint lists and libraries contain list forms that allow users to display, edit, and add items to a list or library.

Create a custom list view using SharePoint Designer

Article Show All Hide All You can create and customize list views using the browser, or you can create views using SharePoint Designer 2010

Web Parts for views and forms in SharePoint Designer 2010

Article In Microsoft SharePoint Designer 2010, you can create list views and data views as well as list forms and data forms.

Create a list or library using SharePoint Designer

Article Lists and libraries are the primary repositories for data in a SharePoint site. Nearly all of your data is stored in a list or in a library. Lists and libraries...

Create data forms using SharePoint Designer

Article with SharePoint Designer 2010, you can quickly create highly customized interfaces to your business data sources using forms. Forms are a vital part of...

Create data views in SharePoint Designer

Article with SharePoint Designer 2010, you can quickly create highly customized interfaces to your business data sources using Data Views. A Data View is a live...

Edit list forms using InfoPath 2010 in SharePoint Designer

Article Every SharePoint list contains a set of list forms that you use to view, edit, or add items to a list. Each list form displays the columns from that list...

Customize Data Views and forms using SharePoint Designer

Article A Data View is a live, customizable view of a data source from a SharePoint site. SharePoint Designer 2010 retrieves data from a data source in the form...

Video: Create Web Part connections using SharePoint Designer 2010

Video Learn how to Create Web Part connections using SharePoint Designer 2010 by SharePoint MVP Asif Rehmani

SharePoint Designer 2010 Videos

Video: Introducing SharePoint Designer 2010

Video Introducing SharePoint Designer 2010. Get a tour of the interface and then learn the four main areas of customization to create no-code solutions in SharePoint

Video: Create an approval workflow in SharePoint Designer 2010

Video Learn how to create and customize approval workflows in SharePoint Designer 2010. Includes the task process framework, the task process editor, and several...

Video: Managing SharePoint Designer 2010

Video This video will help you learn how to manage SharePoint Designer 2010, including how to: Hide master pages and page layouts Hide the web site URL structure...

Video: Business Connectivity Services - Authentication from the browser

Video In SharePoint Designer 2010, you can create an external content type to display data from an external SQL database in an external list in the browser. Learn...

Video: Publish globally reusable workflows in SharePoint Designer 2010

Video Learn how to publish globally reusable workflows in SharePoint Designer 2010 by SharePoint MVP Asif Rehmani

Video: Get to data using Web Services in SharePoint Designer 2010

Video Learn how to get to data using Web Services in SharePoint Designer 2010, presented by SharePoint MVP Asif Rehmani.

Video: Create Web Part connections using SharePoint Designer 2010

Video Learn how to Create Web Part connections using SharePoint Designer 2010 by SharePoint MVP Asif Rehmani

Video: Configure site security using SharePoint Designer 2010

Video Learn how to configure site security using SharePoint Designer 2010 by SharePoint MVP Asif Rehmani

Video: Customize workflow forms using InfoPath 2010

Video Learn how to customize workflow forms using InfoPath 2010 by SharePoint MVP Asif Rehmani

Cannot open pages in sub sites with SharePoint Designer 2010

What is happening? | What the issue is?

Cannot open pages in sub sites with SharePoint Designer 2010 even if users have Design or higher permissions at the sub site level

SharePoint Designer is a powerful application that enables the rapid creation, editing and deployment of content on the SharePoint platform. As such, certain mandatory permission levels are required. You use SharePoint Designer to create and customize data sources, views and forms, workflows, master pages, and more. When performed together, you can create real business solutions on the SharePoint platform.

Points to be noted: SharePoint Designer is designed to request and use SharePoint permissions that grant the rights of managing & designing at the SharePoint site level it is not design to use the permission at a smaller granularity level such as list item level permissions...

Conclusion:

To be able to use SharePoint Designer and modify SharePoint content, an user needs to be a member of one of the following groups at the site collection level: Site Collection Administrators group, the Designers group, and Owners group.

Reference Documents:

1.   http://technet.microsoft.com/en-us/library/cc262939.aspx

2.   http://technet.microsoft.com/en-us/library/cc721640.aspx

Workarounds:

1. Give the user Design permissions to the Master Page gallery and read permission to the rest of the site.

2. Copy down the Master Page to the sub site instead of inheriting.

Finally, it seems that this issue is by designJ

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J J

SharePoint Designer cache

SharePoint designer plays a very important role in terms of site

customizations. If it struck somewhere then it will be a big problem.

Would like to share such incident based on the same. By default all

sharepoint sites are blocked in designer in our enviornment, so if any user

wants to customize the site then he has put a seprate request for that

then site will be allowed to open it in sharepoint designer.

What happens exactely: I have allowed site to open in SPD but user was

not able to open and getting access denied. I tried opening the site in SPD

from my side then it opens fine without any issues so one thing was clear

that this is machine specifc. here cache comes into the picture.

1.   Close SharePoint Designer.

2.   Open My Computer

3.   Go to %System Drive%\Documents and Settings\%user%\Local Settings\Application Data\Microsoft\WebSiteCache

4.   Just delete all these directories and everything should work when you boot SPD).

5.   Restart the SharePoint Designer.

In case of any queries/questions regarding the above mentioned information then please let me know.
I would be more than happy to help you as well as resolves your issues, Thank you

Important Links on Windows SBS 2008

System requirements for installing Windows SBS 2008

Windows Server Update Services 3.0 SP2

Installation of Windows Small Business Server 2011, minimal hardware requirements for installation, error during installation

Windows Small Business Server

Quick glance about Microsoft Windows SBS 2008

New book: Windows Small Business Server 2011 Administrator’s Companion

Windows Small Business Server 2011 Essentials

Microsoft has published an useful information on this:
Windows Small Business Server (SBS) 2011 Essentials is ideal as a first server for small businesses with up to 25 users, Windows SBS 2011 Essentials provides a cost-effective and easy-to-use solution to help protect data, organize and access business information from virtually anywhere, support the applications needed to run a business, and quickly connect to online services for e-mail, collaboration and CRM. Benefits of Windows SBS 2011 Essentials include:

• Daily automatic backups of clients and servers.
• Affordable and easy to deploy, use, and maintain.
• Organize and access files from virtually anywhere.
• Effortlessly connects to online services in order to expand capabilities.

For more information about installing, configuring and using Windows SBS 2011 Essentials, visit Windows Small Business Server 2011 Essentials Online Help.