Excel -The Essential

Excel -The Essential
Featured

Excel -The Essential

Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Santosh Srivastava teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data.

Topics include:

  • What is Excel and what is it used for?
  • Using the menus
  • Working with dates and times
  • Creating simple formulas
  • Formatting fonts, row and column sizes, borders, and more
  • Inserting shapes, arrows, and other graphics
  • Adding and deleting rows and columns
  • Hiding data
  • Moving, copying, and pasting
  • Sorting and filtering data
  • Printing your worksheet
  • Securing your workbooks
  • Tracking changes

Lessons

  1. Overview : Getting Started

    1. Creating a new workbook

    2. Understanding the Excel application window

    3. Open, Save and Close a workbook

  2. Entering and editing data

    1. Entering data into a cell

    2. Entering a labels, values, date and times

    3. AutoComplete

    4. Editing, cancel and delete cell content

    5. Using Undo and Repeat

  3. Managing your worksheet layout

    1. Selecting cells, columns, rows and ranges

    2. Navigating within a worksheet

    3. Adjusting the column width and row height

    4. Inserting or deleting cells, rows and columns

  4. Formatting your worksheet

    1. Character and number formatting

    2. Applying borders

    3. Text Alignment

    4. Using Format Painter

  5. Formulae and Calculations

    1. Creating a formula

    2. Understanding relative cell references

    3. Calculations with percentages

    4. Using AutoFill

    5. Adding a column or row of numbers with AutoSum

  6. Printing your worksheet

No Comments

Post a Reply

Teachers