Ms Excel Basic

by



  1. Ms Excel Basics

Steps to Creating a Basic Epidemic Curve Using Microsoft Excel 20 07 1 Step 1a – Open a blank Microsoft Excel 2007© spreadsheet by selecting the Microsoft button (1) at the upper, left portion of the window and then from the General tab, select the Workbook icon (2). Close the dialog box by selecting the OK button (3). MS Excel Basic Formulas Lecture By: Mr. Pavan Lalwani, Tutorials Point India Private Limited. This video will discuss in detail about the usage of MS excel and its basic functions. As MS excel is very important in our daily lives therefore it is mand. INTRODUCTION TO MS-EXCEL Excel is a computer program used to create electronic spreadsheets. Within excel user can organize data,create chart and perform calculations. Excel is a convenient program because it allow user to create large spreadsheets, reference information, and it allows for better storage of information. Excels operates like. Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas.

Ms excel basic shortcut keys

Ms Excel Basics

  1. 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. 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. 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. 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. 5. Popular
  6. 6. Formulas
  7. 7. Proofing
  8. 8. Save
  9. 9. Advanced
  10. 10. Customize
  11. 11. Popular Shortcut Commands
  12. 12. Advance Shortcut Commands
  13. 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. 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. 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. 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. 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. 18. Review Tab 1. Proofing 2. Comments 3. Changes Check Spelling, Translate Add Comments, Show All Comments Protect & Share Sheet, Protect & Share Workbook
  19. 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