Subscribe
Tutorial search

Excel Insert Tutorials


Sort by:
Excel Vlookup
Excel Vlookup
This tutorial teaches you how to insert the Vlookup function in Excel.
Difficulty:
How to insert cells in Excel
How to insert cells in Excel
When we work with spreadsheet sooner or later we will need to insert Cells into existing sheet.
Difficulty:
Autofill
Autofill
Autofill is a useful feature that will help you insert data such as days, months, etc. It will also let you create your own custom lists.
Difficulty:
Using Sparklines in Excel 2010
Using Sparklines in Excel 2010
Use Sparklines in Excel 2010 as a visualisation tool to see data trends at a glance. Sparklines are mini charts inserted inside cells of Excel 2010.
Difficulty:
Quick Insertion and Deletion
Quick Insertion and Deletion
This tutorial looks at all three aspects of spreadsheet security, giving you pointers on the best ways to preserve the integrity of your spreadsheet as well as guard against its more sensitive information from falling into the wrong hands.
Difficulty:
Camera tool in Excel
Camera tool in Excel
The Camera tool allows you to select a range of cells and literally insert a live picture into a spreadsheet. Any change to the range of cells will automatically update the image.
Difficulty:
5 Simple Tips to Help You Boost Your Productivity on Using Excel Program
5 Simple Tips to Help You Boost Your Productivity on Using Excel Program
This Excel 2007 tutorial here can really help you to save plenty of your precious time when using the program. Here are the tips: Tip 1: Always name your workbook and save it to a location that you will be able to find and open it later. When saving the workbook, you need to give a meaningful, descriptive file name that can represent the contents of the workbook. If you never save the workbook, you will be unable to view the workbook in the future. Also, you must aware the location (folder) where you saved the file because once saved, you may need to re-open the file for viewing or editing. Tip 2: You should know the different between Save and Save As when saving your workbook. The Save As command will ask you – where to save the file as well as the file name – every time you try to save a file. The Save command will only ask you on the first time you save a file. If you open an old file, it will save to the location where you open the file with the same file name. Tip 3: Knowing the different data entry techniques such as AutoFill, AutoComplete, and Pick List can save your time when entering data into the Excel worksheet. Knowing those techniques can really save lots of your time. With AutoFill, you can easily type days of a week, months of a year within seconds. The AutoComplete and Pick List help you quickly and easily insert a same data within the range of cells. The limitation in AutoComplete can be overcome using the Pick List. Tip 4: Always name your worksheets so that you can identify amongst the various worksheets. This is different from naming the workbook. By default, a workbook contains 3 worksheets, namely Sheet1, Sheet2 and Sheet3. You can increase the numbers of worksheets as you wish. Give a proper worksheet name is as important as the workbook name. This will allows you to easily determine the contents of a worksheet. To change the worksheet name, just right click on the worksheet tan and choose Rename. Tip 5: Always use the Excel Help as your personal assistant when you encounter Excel related tasks/problems. Trust me that the Microsoft Office Excel Help act like your personal portable coach. You can found most of your solutions to your problems here. So, if you’re not utilising it before, please start using it now. To get help, click on the Microsoft Office Excel Help icon (top-right of the screen) or you also can press the keyboard F1 button to launch the Excel Help window. To discover more Excel secrets, I would like to invites you to claim your free 2 ebooks when you go to http://www.msoffice-tutorial-training.com From Wong Hing.
Difficulty:
Inserting And Deleting Rows And Columns
Inserting And Deleting Rows And Columns
By the end of this module, learners should be able to: Insert rows and columns Delete rows and columns
Difficulty:
Inserting And Deleting Cells
Inserting And Deleting Cells
By the end of this module, learners should be able to: Insert cells Delete cells Merge cells
Difficulty:
Insert a New Worksheet in Excel 2007
Insert a New Worksheet in Excel 2007
You may wish to insert a new worksheet in your Excel 2007 workbook so you can add a new sheet of information to your workbook. In this tutorial, you will learn how to insert a new worksheet in Excel 2007.
Difficulty:
Insert Data from Excel to SQL Server
Insert Data from Excel to SQL Server
Shows how to read data from an Excel spreadsheet and insert it into a SQL Server database using VBA and ADODB.
Difficulty:
How to Insert a Picture into a Pie Chart
How to Insert a Picture into a Pie Chart
Liven up boring pie charts, by adding pictures to them.
Difficulty:
Inserting A Column
Inserting A Column
Sometimes we (all) make mistakes or things change. If you have a spreadsheet designed and you forgot to include some important information, you can insert a column into an existing spreadsheet.
Difficulty:
Copy Forumulas: Absolute Positioning
Copy Forumulas: Absolute Positioning
Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the Column letter or a $ before the Row number (or both). This is called Absolute Positioning.
Difficulty:
Inserting A Row
Inserting A Row
Likewise, we can also insert rows.
Difficulty:
Search Term(s) (1): insert