Microsoft Office Excel Level 1
*GETTING STARTED WITH EXCEL
- Starting Excel Using Windows 7 (Or Previous Versions)
- Working with and Understanding Excel Ribbon
- Excel Ribbon: Navigation, Customizing, Collapsing and All You Need To Know
- Creating and Opening an existing file in Excel Workbook
- Close and Open Excel Workbooks Through VBA
- Convert an Excel File to PDF
- Save file in 97-2003 Format
- AutoRecover file that was never saved in Excel
- How to share Excel data with Word documents and other files
- Selecting The Blank Worksheet Template
- The Excel Cell Referencing System
- Entering Numbers And Text
- Default Text And Number Alignment
- Summing A Column Of Numbers
- Entering A Date
- Worksheets And Workbooks
- Saving A Workbook To Your Hard Disk
- Closing A Workbook
- Creating A New Workbook
- Opening A Workbook
- Switching Between Workbooks
- Saving A Workbook Using Another Name
- Saving A Workbook Using A Different File Type
- Getting Help Within Excel
- Searching For Online Help
- Alt Key Help
*EXCEL SELECTION TECHNIQUES
- Why Are Selection Techniques Important?
- Selecting A Cell
- Selecting A Range Of Connecting Cells
- Selecting A Range Of Non-Connecting Cells
- Selecting The Entire Worksheet
- Selecting A Row
- Selecting A Range Of Connecting Rows
- Selecting A Range Of Non-Connected Rows
- Selecting A Column
- Selecting A Range Of Connecting Columns
- Selecting A Range Of Non-Connecting Columns
- Recommended Techniques When Creating Or Editing Lists
Find, Select, Replace and Go To Special in Excel
*MANIPULATING ROWS AND COLUMNS WITHIN EXCEL
- Inserting Rows Into A Worksheet
- Inserting Columns Into A Worksheet
- Deleting Rows Within A Worksheet
- Deleting Columns Within A Worksheet
- Modifying Column Widths
- Modifying Column Widths Using ‘Drag And Drop’
- Automatically Resizing The Column Width To Fit Contents
- Modifying Row Heights
*MANIPULATING CELLS AND CELL CONTENT WITHIN EXCEL
- Copying A Cell Or Range Contents Within A Workbook
- Deleting Cell Contents
- Moving The Contents Of A Cell Or Range Within A Workbook
- Editing Cell Content
- Undo And Redo
- Copying Data Between Worksheets (Within The Same Workbook)
- Moving Data Between Worksheets (Within The Same Workbook)
- Moving Data Worksheets (Between Different Workbooks)
- Copying Data Between Worksheets (In Different Workbooks)
- Autofill
- Copying A Data Range Using Autofill
- Sorting A Cell Range
- Searching And Replacing Data
*EXCEL WORKSHEETS
- Switching Between Worksheets
- Renaming A Worksheet
- Recommended Techniques With Naming Worksheets
- Inserting A New Worksheet
- Deleting A Worksheet
- Copying A Worksheet Within A Workbook
- Moving A Worksheet Within A Workbook
- Copying Or Moving Worksheets Between Workbooks
*FONT FORMATTING WITHIN EXCEL
- Font Formatting Options
- Font Type
- Font Size
- Bold, Italic, Underline Formatting
- Cell Border Formatting
- Formatting The Background Colour
- Formatting The Font Colour
*ALIGNMENT FORMATTING WITHIN EXCEL
- Alignment Options
- Horizontally Aligning Contents In A Cell Range
- Centering A Title Over A Cell Range
- Cell Orientation
- Text Wrapping Within A Cell
- Aligning Cell Contents Vertically
- Format Painter
*NUMBER FORMATTING WITHIN EXCEL
- Number Formatting
- Decimal Point Display
- Applying And Removing Comma Style Formatting (To Indicate Thousands)
- Currency Symbol
- Date Styles
- Percentages
- Creating Formulas
- The Easy Way To Create Formulas
- Copying Formulas
- Operators
- Using Operators In Formulas
- Formula Error Messages
- Relative Cell Referencing Within Formulas
- Absolute Cell Referencing Within Formulas
*EXCEL FUNCTIONS
- What Are Functions?
- Common Functions:
- Sum Function
- Average Function
- Max Function
- Min Function
- Count Function
- The Counta Function
- The Countblank Function
- What Are ‘If Functions’?
- Using The If Function
*EXCEL CHARTS
- Inserting A Column Chart
- Inserting A Line Chart
- Inserting A Bar Chart
- Inserting A Pie Chart
- Resizing A Chart
- Deleting A Chart
Miscellaneous
*CHART TITLE OR LABELS
- Changing The Column, Bar, Line Or Pie Slice Colours In A Chart
- Modifying The Legend Fill Colour
- Changing The Chart Type
- Modifying Charts Using The Design Tab
- Modifying The Chart Title
- Modifying The Chart Axis
- Modifying The Chart Legend
- Modifying Chart Data Labels
- Displaying Chart Data Tables
- Modifying Chart Gridlines
- Copying And Moving Charts Within A Worksheet
- Copying And Moving Charts Between Worksheets
- Copying And Moving Charts Between Workbooks
*CUSTOMISING EXCEL
Modifying Basic Excel Options