Microsoft Excel

$ 462.00$ 525.00 Prices include 5% VAT

Clear
SKU: N/A Category:

Description

Microsoft Excel

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs.

Microsoft Excel training, Microsoft Excel course, learn Microsoft Excel

COURSE OUTLINE

BASIC LEVEL

User Interface

  • Ribbon User interface
  • Launching & Quitting
  • Help

Creating Spreadsheet

  • Creating a New Workbook
  • Navigating in Excel
  • Moving the Cell Pointer
  • Using Excel Menus
  • Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
  • Entering Values in a Worksheet and Selecting a Cell Range
  • Previewing and Printing a Worksheet
  • Getting Help from the Office Assistant
  • Saving a Workbook & Re-opening a saved workbook
  • Formatting a Worksheet
  • Creating Headers, Footers, and Page Numbers
  • Adjusting Page Margins and Orientation
  • Adding Print Titles and Gridlines, rows to repeat at top of each page

Formatting Fonts & Values

  • Adjusting Row Height and Column Width
  • Changing Cell Alignment
  • Adding Borders
  • Applying Colors and Patterns
  • Using the Format Painter
  • Using AutoFormat
  • Merging Cells, Rotating Text, and using AutoFit
  • Using AutoFill
  • Managing your workbooks
  • Switching Between Sheets in a Workbook
  • Inserting and Deleting Worksheets
  • Renaming and Moving Worksheets

Formulas

  • Creating a basic Formula
  • Calculating Value Totals with AutoSum
  • Editing & Copying Formulas
  • Fixing Errors in Your Formulas
  • Formulas with Several Operators and Cell Ranges

Working with the Forms Menu

  • Copy & Paste Filtered Records
  • Creating a Chart
  • Moving and Resizing a Chart
  • Formatting and Editing Objects in a Chart
  • Changing a Chart’s Source Data
  • Changing a Chart Type and Working with Pie Charts
  • Adding Titles, Gridlines, and a Data Table
  • Formatting a Data Series and Chart Axis
  • Annotating a Chart
  • Working with 3-D Charts
  • Selecting and Saving a Custom Chart
  • Using Fill Effects
  • Working with Other Programs
  • Modifying an Inserted Excel Worksheet
  • Inserting a Graphic into a Worksheet

Protecting a Workbook

  • Hiding Columns, Rows and Sheets
  • Splitting and Freezing a Window
  • Inserting Page Breaks
  • Advanced Printing Options
  • Entering Date Values and using AutoComplete
  • Editing, Clearing, and Replacing Cell Contents
  • Cutting, Copying, and Pasting Cells
  • Moving and Copying Cells with Drag and Drop
  • Collecting and Pasting Multiple Items
  • Using the Paste Special Command
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo, Redo, and Repeat
  • Checking Your Spelling
  • Finding and Replacing Information

ADVANCED LEVEL

Data

  • To name cells
  • To navigate workbooks using named ranges
  • To create named ranges based on cell values
  • To delete named cells/ranges
  • To AutoFormat a cell range
  • To remove the effects of AutoFormat
  • To create a custom number format
  • Using custom number formatting codes
  • To format a range of cells using conditional formatting
  • To use the Paste Special command
  • ‘Paste Special’ options
  • Transpose data

Protection

  • What is ‘worksheet protection’?
  • To protect a worksheet
  • To un-protect a worksheet
  • To protect cells
  • To unprotect cells

Display

  • To freeze column titles
  • To freeze row titles
  • To freeze row and column titles at the same time
  • To unfreeze rows or columns
  • To hide worksheets
  • To re-display hidden worksheets
  • To create subtotals
  • To remove subtotals

Security

  • To specify a password for opening a workbook
  • To specify a password for saving a workbook
  • To use the ‘read-only recommended’ option
  • To use the ‘Always create backup’ option
  • To protect a workbook
  • To un-protect a workbook
  • To remove a password from an Excel workbook

Linking

  • To link individual cells within a worksheet
  • To link charts to data within a worksheet
  • To link a cell range on one worksheet to another worksheet (in the same workbook)
  • To link charts between worksheets
  • To link data from one workbook to another
  • To link a chart from one workbook to another
  • Copying a chart from one workbook to another
  • To copy data to the Clipboard
  • To embed data (or a chart) from Excel into a Word document
  • To Paste Link selected Excel data / chart to a Word document
  • To consolidate data over several worksheets

Templates

  • What are templates?
  • To use a template
  • To create a template
  • To edit a template

Charts and Templates

  • To use the Chart Wizard to create a chart
  • To quickly create a chart using default settings
  • To change the angle of pie chart slices
  • To format the chart axis numbers
  • To format the chart axis scales
  • To format the chart axis text
  • To move a chart item
  • To resize a chart item
  • To re-position a chart title
  • To re-position a chart legend
  • To re-position a chart data label
  • To explode all the segments within a pie chart
  • To delete a data series in a chart
  • To add a data series to a chart
  • To modify the chart type for a defined data series

USING FUNCTIONS

  • What is the ‘Insert Function’ utility?
  • Ways to access the Function Wizard
  • To use the Insert Function to enter a function
  • Using the mouse to enter information into the Function Wizard
  • To use the TODAY function

PIVOT TABLES / DYNAMIC CROSSTAB

  • What are Pivot Tables?
  • To create a PivotTable
  • To drop data into the Pivot Table
  • To modify data and refresh the Pivot Table
  • To group data within a Pivot table

SCENARIOS / VERSIONS

  • What is the ‘Scenario Manager’?
  • Scenario Manager – an example
  • To show a scenario
  • To view an alternative scenario
  • To create a scenario summary
  • Data analysis
  • Statistical Analysis
  • Solver

 

Additional information

Choose Level

Basic, Advanced

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel”