Ravindra BagaleCourses & study guides

1. Excel Basics

By Last updated:

Chala mitrano, aaj aapan Excel chi olakh karun gheuya. Ribbon, workbook, sheet, cell references, formatting, rupee format, freeze panes aani named ranges – he sagla ya module madhe aahe. Ha paaya (foundation) pakka zala tar pudhche sagle modules ekdum sope vattil. Ghabru naka, ek ek step karuya.

What you will learn in this module

  • The Excel window: ribbon, Quick Access Toolbar, Name Box, formula bar and status bar
  • Workbooks and worksheets, and the practice dataset used in this book
  • Relative, absolute and mixed cell references (the F4 key)
  • Cell formatting, number formats, rupees in Indian comma style and dd-mm-yyyy dates
  • Custom number formats, Freeze Panes and named ranges

Concepts in this chapter

  1. 1.1The Excel Interface
  2. 1.2Workbooks, Worksheets and Our Practice Dataset
  3. 1.3Relative, Absolute and Mixed References
  4. 1.4Formatting Cells
  5. 1.5Number Formats: Rupees in Indian Style and Dates
  6. 1.6Custom Number Formats
  7. 1.7Freeze Panes
  8. 1.8Named Ranges

The chapter recap is at the end of the last concept page.