Excel Basics Tutorials

Home/Excel/Excel Basics Tutorials

Excel Basics tutorials are for beginners with no knowledge of Excel, in this section we cover the introduction to MS Excel, Objects and Tools available in Excel, Data entry and Formatting. By end of this session you will have understanding about Excel and be more confident using Excel to start work with excel.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


» Getting Started with Microsoft Excel:
In this section I will introduce the basic features of Microsoft Excel, one of the tools in the MS Office Package.

» Introduction to Microsoft Excel and Creating First Excel File:
Microsoft Excel is one of the tools in the Microsoft Office Package; it is used to create spreadsheets. It has many in-built functions and tools to work with data and create different type of reports and dashboards. It also provided the feature to the users to work behind the existing tools and can enhance its capabilities. To implement functionality beyond a regular spreadsheet, Microsoft Visual Basic programming environment is provided with Microsoft Office Excel. This programming language is called as Visual Basic for Application (VBA).

» Introduction to Excel Interface and Objects:
We have seen what is Excel and what we can achieve using Excel in the previous section. In this section we will what are the different objects in Excel to do our jobs and pictorial representation of Excel Interface.

» Entering Data and Moving in the Worksheet:
Entering Data and Moving in Excel Worksheet is very easy and you find that it is the time saver for data entry. You can enter any numbers, text, dates in Excel and you can format as per your requirement.

» Formatting Data and Formatting Cells:
One of the beauty of the Excel is rich formats, we can format the numbers, fonts, font color, background color, alignments and many more things we can do in Excel. This tutorial will help you to learn Formatting Data and Formatting Cells in Excel.

» Copying, Moving and Pasting Data:
When we are working with the data most of the time we may required to copy/move the data from one location (range) to another location. This tutorials will explains you Copying Moving and Pasting Data in Excel.

Downloads and Links

» Excel Downloads
Useful Link
» Shortcut Keys
» Excel Tips

By |January 1st, 2013|Excel|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

vba for pivot tablesvba start programvba range propertiesexcel spreadsheet examples templateshow to combine multiple excel sheets into oneexcel vba check boxexcel averageifsresource capacity planning excel templateall shortcut keys of excel 2007sumifs examplesexcel greater than formuladelete empty cells in excel3d plots in excelhow to learn vlookup in excel 2010excel function sumifado odbc connection stringexcel saveas fileformatvba calling a subdcl queriesconnection string vbasql excel vbaexcel macro activecellproject planning worksheet templatesql basic interview questions and answersremove excel worksheet passwordvba coding for dummiesvba excel worksheetsvba pop up boxms excel 2007 shortcut keys listhow to dedup in excelddl dml dcl tcl commands in sql with examplesmacro to consolidate data from multiple worksheetshot to merge cells in exceltable pivot excelms excel 2007 vlookuppassword protect excel workbookvb macroexcel macro case statementproject management gantt chart templateexcel macro definitionautofilter field vbahow to unlock excel fileexcel vba with sheetsexcel dashboard templates xlshow to use sumif function in excelms access visual basic commandsexcel 2007 sumifadvanced excel macro tutorialrun query from vbahow to use average function in excel 2007technical interview questions for freshers with answersmysql oledb connection stringlookup command in excelexcel 2007 offsetvba code for excel examplesexcel vba odbc connection stringexcel using macrostechnical interview questions and answers for fresherscreate a check box in excelexcel logical formulashow to use iferror function in excel 2010sorting formula in excelexcel userform listboxfind duplicate values in excelusing vlookup in excel 2010useful excel macroms access remove duplicatesexcel macro concatenate stringshortcut to insert column in excelvba code to unprotect excel workbookexcel macro savemerge duplicate rows in excel 2010excel developer tab 2013what does sub mean in vbainsert button excelvba active workbooksorting tabs in excelcbo boxofficeexcel conditional andexcel function in vba