7⃣5⃣8⃣8⃣0⃣2⃣0⃣8⃣8⃣6⃣
💻Techno Savvy Solapur🌍
___________________________________
Writter
Laxman Katekar
7588020886
Admin
Techno Savvy Solapur
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Learn Excell
MS office 13
Introduction
Excel files are called workbooks. Whenever you start a new project in Excel, you'll need to create a new workbook. There are several ways to start working with a workbook in Excel 2013. You can choose to create a new workbook—either with a blank workbook or a pre-designed template—or open an existing workbook.
To Create a New, Blank Workbook:
Select the File tab. Backstage view will appear.
Screenshot of ExcelClicking the File tab
Select New and then click Blank workbook.
Screenshot of Excel 2013Creating a new workbook
A new, blank workbook will appear.
To Open an Existing Workbook:
An existing workbook is a workbook that has been previously saved. To learn more about saving workbooks, visit our lesson on Saving and Sharing Workbooks.
Navigate to Backstage view and then click Open.
Screenshot of Excel 2013Opening a file
Select a location option:
Recent Workbooks displays all of your recently edited workbooks, including those saved to SkyDrive.
Screenshot of Excel 2013Viewing recently edited workbooks
SkyDrive gives you access to your SkyDrive folders. Select SkyDrive and then click Browse if you've saved your workbook to the cloud.
Screenshot of Excel 2013Opening a workbook from SkyDrive
Computer gives you access to the files you've saved locally on your computer. In our example, we will select this option and then click Browse.
Screenshot of Excel 2013Opening a locally saved workbook
The Open dialog box will appear. Locate and select your workbook and then click Open.
Screenshot of Excel 2013Opening a workbook
To Pin a Workbook:
If you frequently work with the same workbook, you can pin it to Backstage view for quick access.
Navigate to Backstage view.
Click Open. Your recently edited workbooks will appear.
Screenshot of Excel 2013Viewing recently edited workbooks
Hover the mouse over the workbook you wish to pin. A pushpin icon will appear next to the workbook.
Click the pushpin icon.
Screenshot of Excel 2013Pinning a workbook
The workbook will appear in Recent Workbooks until it is unpinned.
Screenshot of Excel 2013The pinned workbook
To unpin a workbook, simply click the pushpin icon again.
You can also pin folders to Backstage view for quick access. From Backstage view, click Open and then locate the folder you wish to pin, then click the pushpin icon.
___________________________________
Laxman Katekar
7588020886
___________________________________
Using Templates
A template is a pre-designed spreadsheet you can use to create a new workbook quickly. Templates often include custom formatting and predefined formulas, so they can save you a lot of time and effort when starting a new project.
To Create a New Workbook from a Template:
Click the File tab to access Backstage view.
Screenshot of Excel 2013Navigating to Backstage view
Select New. Several templates will appear below the Blank workbook option.
Select a template to review it.
Screenshot of Excel 2013Selecting a template
A preview of the template will appear, along with additional information about how the template can be used.
Click Create to use the selected template.
Screenshot of Excel 2013Creating a new workbook with a template
A new workbook will appear with the selected template.
You can also browse templates by category or use the search bar to find something more specific.
Screenshot of Excel 2013Searching for a template
It's important to note that not all templates are created by Microsoft. Many are created by third-party providers and even individual users, so some templates may work better than others.
___________________________________
Laxman katekar
7588020886
laxmankatekar.blogspot.in
___________________________________
Compatibility Mode
Sometimes, you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these kinds of workbooks, they will appear in Compatibility mode.
Compatibility mode disables certain features, so you'll only be able to access commands found in the program used to create the workbook. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.
In the image below, you can see that the workbook is in Compatibility mode. This will disable some Excel 2013 features, such as sparklines and slicers.
Screenshot of Excel 2013Disabled commands in Compatibility mode
In order to exit Compatibility mode, you'll need to convert the workbook to the current version type. However, if you're collaborating with others who only have access to an earlier version of Excel, it's best to leave the workbook in Compatibility mode so that the format will not change.
To Convert a Workbook:
If you want access to all of the Excel 2013 features, you can convert the workbook to the 2013 file format.
Note that converting a file may cause some changes to the original layout of the workbook.
Click the File tab to access Backstage view.
Screenshot of ExcelClicking the File tab
Locate and select Convert command.
Screenshot of Excel 2013Converting the workbook to the newest file type
The Save As dialog box will appear. Select the location where you wish to save the workbook, enter a file name for the presentation and click Save.
Screenshot of Excel 2013Saving a new version of the workbook
The workbook will be converted to the newest file type.
........continue next..
Please cant any changes
~~~~~~~~~~~~~~~~~~~~~~~~
Laxman Katekar
7588020886
laxmankatekar.blogspot.in
~~~~~~~~~~~~~~~~~~~~~~~~
💻Techno Savvy Solapur🌍
___________________________________
Writter
Laxman Katekar
7588020886
Admin
Techno Savvy Solapur
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Learn Excell
MS office 13
Introduction
Excel files are called workbooks. Whenever you start a new project in Excel, you'll need to create a new workbook. There are several ways to start working with a workbook in Excel 2013. You can choose to create a new workbook—either with a blank workbook or a pre-designed template—or open an existing workbook.
To Create a New, Blank Workbook:
Select the File tab. Backstage view will appear.
Screenshot of ExcelClicking the File tab
Select New and then click Blank workbook.
Screenshot of Excel 2013Creating a new workbook
A new, blank workbook will appear.
To Open an Existing Workbook:
An existing workbook is a workbook that has been previously saved. To learn more about saving workbooks, visit our lesson on Saving and Sharing Workbooks.
Navigate to Backstage view and then click Open.
Screenshot of Excel 2013Opening a file
Select a location option:
Recent Workbooks displays all of your recently edited workbooks, including those saved to SkyDrive.
Screenshot of Excel 2013Viewing recently edited workbooks
SkyDrive gives you access to your SkyDrive folders. Select SkyDrive and then click Browse if you've saved your workbook to the cloud.
Screenshot of Excel 2013Opening a workbook from SkyDrive
Computer gives you access to the files you've saved locally on your computer. In our example, we will select this option and then click Browse.
Screenshot of Excel 2013Opening a locally saved workbook
The Open dialog box will appear. Locate and select your workbook and then click Open.
Screenshot of Excel 2013Opening a workbook
To Pin a Workbook:
If you frequently work with the same workbook, you can pin it to Backstage view for quick access.
Navigate to Backstage view.
Click Open. Your recently edited workbooks will appear.
Screenshot of Excel 2013Viewing recently edited workbooks
Hover the mouse over the workbook you wish to pin. A pushpin icon will appear next to the workbook.
Click the pushpin icon.
Screenshot of Excel 2013Pinning a workbook
The workbook will appear in Recent Workbooks until it is unpinned.
Screenshot of Excel 2013The pinned workbook
To unpin a workbook, simply click the pushpin icon again.
You can also pin folders to Backstage view for quick access. From Backstage view, click Open and then locate the folder you wish to pin, then click the pushpin icon.
___________________________________
Laxman Katekar
7588020886
___________________________________
Using Templates
A template is a pre-designed spreadsheet you can use to create a new workbook quickly. Templates often include custom formatting and predefined formulas, so they can save you a lot of time and effort when starting a new project.
To Create a New Workbook from a Template:
Click the File tab to access Backstage view.
Screenshot of Excel 2013Navigating to Backstage view
Select New. Several templates will appear below the Blank workbook option.
Select a template to review it.
Screenshot of Excel 2013Selecting a template
A preview of the template will appear, along with additional information about how the template can be used.
Click Create to use the selected template.
Screenshot of Excel 2013Creating a new workbook with a template
A new workbook will appear with the selected template.
You can also browse templates by category or use the search bar to find something more specific.
Screenshot of Excel 2013Searching for a template
It's important to note that not all templates are created by Microsoft. Many are created by third-party providers and even individual users, so some templates may work better than others.
___________________________________
Laxman katekar
7588020886
laxmankatekar.blogspot.in
___________________________________
Compatibility Mode
Sometimes, you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these kinds of workbooks, they will appear in Compatibility mode.
Compatibility mode disables certain features, so you'll only be able to access commands found in the program used to create the workbook. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.
In the image below, you can see that the workbook is in Compatibility mode. This will disable some Excel 2013 features, such as sparklines and slicers.
Screenshot of Excel 2013Disabled commands in Compatibility mode
In order to exit Compatibility mode, you'll need to convert the workbook to the current version type. However, if you're collaborating with others who only have access to an earlier version of Excel, it's best to leave the workbook in Compatibility mode so that the format will not change.
To Convert a Workbook:
If you want access to all of the Excel 2013 features, you can convert the workbook to the 2013 file format.
Note that converting a file may cause some changes to the original layout of the workbook.
Click the File tab to access Backstage view.
Screenshot of ExcelClicking the File tab
Locate and select Convert command.
Screenshot of Excel 2013Converting the workbook to the newest file type
The Save As dialog box will appear. Select the location where you wish to save the workbook, enter a file name for the presentation and click Save.
Screenshot of Excel 2013Saving a new version of the workbook
The workbook will be converted to the newest file type.
........continue next..
Please cant any changes
~~~~~~~~~~~~~~~~~~~~~~~~
Laxman Katekar
7588020886
laxmankatekar.blogspot.in
~~~~~~~~~~~~~~~~~~~~~~~~