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
Ultimate Project Management Template
20+ Excel Project Management Pack
20+ PowerPoint Project Management Pack
10+ MS Word Project Management Pack
» 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 VBA Reference||Project Management Reference|