Excel formulas can be used for basic number crunching, such as addition or subtraction, as well as more complex calculations, such as finding a student's average on test results and calculating mortgage payments. Formulas in Excel always begin with an equal sign ( =). The equal sign is always typed into the cell where you want the answer to appear. MS Excel Basic Formulas Lecture By: Mr. Pavan Lalwani, Tutorials Point India Private Limited.
- 1. MS Excel 2007 Training 2015 Ms Excel 2007 Training (Basics) User Interface, custom settings and all tabs Vikash kumar MS Excel Formulas, Functions & VBA macros
- 2. In this session Introduction to MS Excel Sheet Excel Options Popular Shortcut Commands Advance Shortcut Commands Home Tab Insert Tab Page Layout Tab Formulas Tab Data Tab Review Tab View Tab
- 3. The ribbon Name Box Quick access toolbarF o r m u l a B a r C o l o u m n s h e a d I n g s RowsHeadIngs Sheets Zoom Work Area
- 4. Excel Options With this command we can customize excel with our requirements. Here we learn about :- 1. Popular 2. Formulas 3. Proofing 4. Save 5. Advanced 6. Customize
- 5. Popular
- 6. Formulas
- 7. Proofing
- 8. Save
- 9. Advanced
- 10. Customize
- 11. Popular Shortcut Commands
- 12. Advance Shortcut Commands
- 13. Home Tab 1. Clipboard 2. Font 3. Alignment 4. Number 5. Styles 6. Cells 7. Editing Cut , Copy , Paste, Format Painter Font face, Font Color , Size , Border , Cell color Alignment , Orientation , Wrap Text , Merge & Center Number & text Formatting Conditional Formatting , Table Style , Cell style Insert Delete & Format cells Auto Functions , Auto Fill, Clear , Find & select
- 14. Insert Tab 1. Tables 2. Illustrations 3. Charts 4. Links 5. Text Pivot Table, Table Picture ,Clip Art , Shapes , Smart Arts Columns, Line, Pie, Bar, Area, Scatter Etc. Hyperlinks Text Box, Header & Footer, Word Art, Signature Line
- 15. Page Layout 1. Themes 2. Page Setup 3. Scale To fit 4. Sheets Options 5. Arrange Themes, Color, Font, Effects Margins, Orientations, Backgrounds etc. Height, Width, Scale Gridlines, Headings Selection Pane, Group, Rotate
- 16. Formulas 1. Functions Library 2. Define Name 3. Formula Auditing 4. Sheets Options 5. Arrange All Type of Functions / Formulas Name Manager, Define Name, etc. Height, Width, Scale Gridlines, Headings Selection Pane, Group, Rotate
- 17. Data Tab 1. Get External Data 2. Connections 3. Short & Filter 4. Data Tools 5. Outline From Access, From Web, etc. Edit Links, Refresh All Short , Filter Text to columns, Remove Duplicates, Data Validation Selection Pane, Group, Rotate
- 18. Review Tab 1. Proofing 2. Comments 3. Changes Check Spelling, Translate Add Comments, Show All Comments Protect & Share Sheet, Protect & Share Workbook
- 19. View Tab 1. Workbook Views 2. Show & Hide 3. Zoom 4. Windows 5. Macros Normal, Page Layout, Page Break, Custom Gridlines, Formula Bar, Headings Zoom In , Zoom Out New Window, Arrange Window, Freeze Panes Macros
This section explains the basics of Excel.
Ms Excel Basic Parts
1 Ribbon: Excel selects the ribbon's Home tab when you open it. Learn how to use the ribbon.
2 Workbook: A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.
3 Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
4 Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.
5 Find & Select: Learn how to use Excel's Find, Replace and Go To Special feature.
6 Templates: Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.
7 Data Validation: Use data validation to make sure that users enter certain values into a cell.
8 Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.
9 Print: This chapter teaches you how to print a worksheet and how to change print settings.
10 Share: Learn how to share Excel data with Word documents and other files.
Ms Excel Basics Pdf
11 Protect: Encrypt an Excel file with a password so that it requires a password to open it.