Microsoft Excel 2007 In Simple Steps

 

Top 10 Excel Tips



        Launch Excel
        Select a cell
        Select a worksheet
        Create a basic formula
        Create a chart from all chart types
        Create a table
        Draw a shape
        Configure page size and orientation
        Protect a worksheet
        Share a worksheet

 

 

Chapter 1 – Starting to use Excel

·        Launch Excel

·        Open a new blank workbook

·        Open an existing workbook

·        Explore the Ribbon

·        Choose menu commands

·        Work with the Quick Access Toolbar

·        Choose dialogue box options

·        Use the status bar

·        Use task and window panes

·        Create a workbook from a template

·        Navigate a workbook

·        Manage multiple windows

·        Save a workbook

·        Save a workbook in different formats

·        Switch views

·        Close a workbook and quit Excel

·        Change workbook properties

·        Find help while you’re working

·        Update Excel

 

 

Chapter 2 – Learning essential workbook techniques

·        Select a cell

·        Select rows and columns

·        Select multiple worksheets

·        Make special range selections

·        Enter a label

·        Enter a value

·        Automatically enter data with AutoFill

·        Insert or delete cell contents

·        Find cell contents

·        Replace cell contents

·        Move cell contents using the clipboard

·        Move data using drag-and-drop

·        Clear cell contents

·        Check your spelling

·        Activate smart tags

·        Insert a smart tag

·        Check your spelling

·        Translate text

·        Change proofing options

 

 

Chapter 3 – Managing workb