- MS Excel Basics
- EXCEL BASICS FOR BEGINNERS: Learn Excel and Use Basic Formulas, Functions, Charts and Pivot Tables in Less Than 10 Hours! (Excel For Beginners) Henry E. The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more (Excel.
- What is Microsoft Excel? Microsoft Excel is a program that provide worksheets comprised of rows and columns. Textual data can be stored in the workbook similarly to a Microsoft Word table, but the power of Excel is its ability to perform simple to complicated mathematical calculations. When you are ready to create some math formulas, see our.
- Editing Worksheet
- Formatting Cells
- Formatting Worksheets
Microsoft Excel is one of the most popular spreadsheet applications that helps you manage data, create visually persuasive charts, and thought-provoking graphs. Excel is supported by both Mac and PC platforms. Microsoft Excel can also be used to balance a checkbook, create an expense report, build formulas, and edit them. Opening Microsoft Excel.
- Working with Formula
- Advanced Operations
- MS Excel Resources
- Selected Reading
Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X.
Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.
By default, documents saved in Excel 2010 are saved with the .xlsx extension whereas the file extension of the prior Excel versions are .xls.
This tutorial has been designed for computer users who would like to learn Microsoft Excel in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications.
Before proceeding with this tutorial, you should have a basic understanding of Computer peripherals like mouse, keyboard, monitor, screen etc. and their basic operations. You should also have the basic skills of file management and folder navigations.
- Details
Training Summary
Excel is the most powerful tool to manage and analyze various types of Data. This Microsoft Excel tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process. This Excel for beginners course will help you learn Excel basics.What should I know?
Nothing! This Free Excel training course assumes you are a beginner to Excel.
What will you Learn?
Introduction
| Tutorial | Introduction to Microsoft Excel |
| Tutorial | How to Add, Subtract, Multiply, Divide in Excel |
| Tutorial | Excel Data Validation, Filters, Grouping |
| Tutorial | Excel Formulas & Functions: Learn with Basic EXAMPLES |
| Tutorial | IF, AND, OR, Nested IF & NOT Logical Functions in Excel |
| Tutorial | How to Create Charts in Excel: Types & Examples |
| Tutorial | How to make Budget in Excel: Personal Finance Tutorial |
Advance Stuff
| Tutorial | How to Import XML Data into Excel [Example] |
| Tutorial | How to Import CSV Data (Text) into Excel [Example] |
| Tutorial | How to Import MS Access Data into Excel [Example] |
| Tutorial | How to Import SQL Database Data into Excel [Example] |
| Tutorial | How to Create Pivot Table in Excel: Beginners Tutorial |
| Tutorial | Advanced Charts & Graph in Excel |
| Tutorial | What is Microsoft Office 365? Benefits of Excel on Cloud |
| Tutorial | CSV vs Excel (.xls) - What's the Difference? |
| Tutorial | Excel VLOOKUP Tutorial for Beginners: Learn with Examples |
| Tutorial | Excel ISBLANK Function: Learn with Example |
| Tutorial | Sparklines in Excel: What is, How to Use, Types & Examples |
| Tutorial | SUMIF function in Excel: Learn with EXAMPLE |
| Tutorial | Top 40 Microsoft Excel Interview Questions and Answers |
| Tutorial | Top 10 Excel Formulas Asked in an Interview & Answers |
| Tutorial | 15 Best Excel Course & Classes Online |
| Tutorial | 17 BEST Excel Alternatives |
| Tutorial | 15 BEST Excel Books |
| Tutorial | 85 Best Microsoft Office Classes Courses |
| Tutorial | 13 Best Free Microsoft Courses & Certification |
| Tutorial | Excel PDF |
Ms Excel For Beginners
Macros & VBA in Excel
Excel Basics For Beginners
| Tutorial | How to Write Macros in Excel: Step by Step Beginners Tutorial |
| Tutorial | How to Create Visual Basic for Applications (VBA) in Excel with Examples |
| Tutorial | VBA Variables, Data Types & Declare VBA Constants in Excel |
| Tutorial | Excel VBA Arrays: What is, How to Use & Types of Arrays in VBA |
| Tutorial | VBA Controls: VBA Form Control & ActiveX Controls in Excel |
| Tutorial | VBA Arithmetic Operators: Multiplication, Division & Addition |
| Tutorial | VBA String Operators |
| Tutorial | VBA Comparison Operators: Not equal, Less than or Equal to |
| Tutorial | VBA Logical Operators: AND, OR, NOT |
| Tutorial | Excel VBA Subroutine: How to Call Sub in VBA with Example |
| Tutorial | Excel VBA Function Tutorial: Return, Call, Examples |
| Tutorial | VBA Range Objects |