Basic Excel Training

Benefits of Basic Excel Training

MS Excel is the cornerstone of each organizational function be it strategy, finance or accounting, operation, HR, Sales etc. Worldwide millions of professionals and students alike use Excel on a daily basis. MS Excel has many user friendly, time saving, exciting functions and tools that has the potential to increase productivity to new horizons but most of us are not aware of the un-discovered power of MS Excel.

Therefore, a strong working acquaintance of MS Excel would help professionals and students to succeed in their respective professional & career paths.

Basic Excel Outline:

Getting to know Excel

Starting Excel from the Desktop.
Understanding the Start Screen.
The Workbook Screen.
How Excel Works.
Using the Ribbon.
Showing and Collapsing the Ribbon.
Understanding the Backstage View.
Accessing the Backstage View.
Using Shortcut Menus.
Understanding Dialog Boxes.
Launching Dialog Boxes.
Understanding the Quick Access Toolbar.
Adding Commands to the Quick Access Toolbar.
Understanding the Status Bar.
Exiting Safely.

Creating a New Workbook

Understanding Workbooks.
Using the Blank Workbook Template.
Typing Text.
Typing Numbers.
Typing Dates.
Typing Formulas.
Easy Formulas.
Checking the Spelling.
Printing a Worksheet.
Saving a New Workbook on Your Computer.
Safely Closing a Workbook.

Working with Workbooks

Opening an Existing Workbook.
Navigating a Workbook.
Navigating using the Keyboard.
Using Go To.
Recent Files and Folders.
Understanding Data Editing.
Overwriting Cell Contents.
Editing Longer Cells.
Editing Formulas.
Clearing Cells.
Deleting Data.
Using Undo and Redo.

Selecting Ranges

Understanding Cells and Ranges.
Selecting Contiguous Ranges.
Selecting Non-Contiguous Ranges.
Using Special Selection Techniques.
Selecting Larger Ranges.
Selecting Rows.
Selecting Columns.
Viewing Range Calculations.
Creating an Input Range.

Formulas and functions

Understanding Formulas.
Creating Formulas that Add.
Creating Formulas that Subtract.
Formulas that Multiply and Divide.
Understanding Functions.
Using the SUM Function.
Summing Non-Contiguous Ranges.
Calculating an Average.
Finding a Maximum Value.
Finding a Minimum Value.
Creating more Complex Formulas.
IF Formulas.
Common Error Messages.

Copying Data

Understanding Copying.
Using Fill for Quick Copying.
Copying from One Cell to Another.
Copying from One Cell to a Range.
Copying from One Range to Another.
Copying Relative Formulas.
Copying to a Non-Contiguous Range.
Copying to another Worksheet.
Copying to another Workbook.

Formula Referencing

Absolute versus Relative Referencing.
Relative Formulas.
Problems with Relative Formulas.
Creating
Creating Mixed References.

Font formatting

Understanding Font Formatting.
Working with Live Preview.
Changing Fonts.
Changing Font Size.
Growing and Shrinking Fonts.
Making Cells Bold.
Italicising Text.
Underlining Text.
Changing Font Colors.
Changing Background Colors.
Using the Format Painter.
Applying Strikethrough.
Subscripting Text.
Superscripting Text.
Practice Exercise.
Practice Exercise Samples.

Cell Alignment

Understanding Cell Alignment.
Horizontal Cell Alignment.
Aligning Right.
Aligning to the Centre.
Aligning Left.
Vertical Cell Alignment.
Aligning Top.
Aligning Bottom.
Aligning to the Middle.
Rotating Text.
Indenting Cells.
Wrapping and Merging Text.
Merging and Centering.
Merging Cells.
Unmerging Cells.

Row and Column Formatting

Approximating Column Widths.
Setting Precise Columns Widths.
Setting the Default Column Width.
Approximating Row Height.
Setting Precise Row Heights.
Hiding Rows and Columns.
Un-hiding Rows and Columns.

Number Formatting

Understanding Number Formatting.
Applying General Formatting.
Formatting for Money.
Formatting Percentages.
Formatting as Fractions.
Formatting as Dates.
Using the Thousands Separator.
Increasing and Decreasing Decimals.

Printing

Understanding Printing.
Previewing before you print.
Selecting a Printer.
Printing a Range.
Printing an Entire Workbook.
Specifying the Number of Copies
The Print Options.

Creating Charts

Understanding the Charting Process.
Choosing the Right Chart.
Using a Recommended Chart.
Creating a New Chart from Scratch.
Working with an Embedded Chart.
Resizing a Chart.
Repositioning a Chart.
Printing an Embedded Chart.
Creating a Chart Sheet.
Changing the Chart Type.
Changing the Chart Layout.
Changing the Chart Style.
Printing a Chart Sheet.
Embedding a Chart into a Worksheet.
Deleting a Chart.

This Course contains Practical Work involving Practical Hands-On, Lab Assignments, and Real World Case Studies. This practical work can be done at your own pace. Delphi Star Training provides the best Excel Training Services you may ever have from anywhere else.

Learning Outcomes:

After the successful completion of the Basic Excel Training Program, Students will be able to:

Recognize Spreadsheet Terminology; Start Microsoft Excel and identify the components of the Excel Interface; create a new Workbook; open an existing Workbook; navigate Worksheets.
Enter and Edit Text, values, and Formulas; use Auto-fills; Review the order of Operations; save and Update a Workbook; and Save a Workbook in different File Formats.
Move and copy Data and Formulas; use the Office Clipboard; use Paste Link; view Formulas; work with Relative and Absolute References; Insert and Delete Ranges, Rows, and Columns.
Use SUM Function, Auto-Sum, and the AVERAGE, MIN, MAX, COUNT, and COUNTA Functions to perform Calculations in a Worksheet. Format and Merge Cells; apply Number and Color Styles; use the Format Painter Tool and setup Conditional Format Rules. Create, Format, Modify, and Print Charts based on Worksheet Data; work with various Chart Elements; apply Chart Types and Chart Styles.
Insert and Modify a Picture and Smart-Art Graphics, and represent Data Graphically.
Check Spelling; Find and Replace Text and Data; Preview and Print a Worksheet; set Page Orientation and Margins; Create and Format Headers and Footers; and Print Gridlines.

Program duration:

14 to 18 Hours

Who should attend the Basic Excel Training?

This Program is highly recommended for those who want to understand the Basic Concepts of Spreadsheets and want to demonstrate the ability to expertly use Microsoft Excel for Keying In, Manipulating and Reporting Data easily
Microsoft Excel for Beginners is best suited for people who are relatively new to Excel and want to get more out of Microsoft Excel to make the best use of the Software in their day-to-day use.
Learn Microsoft Excel Tips & Techniques that will make your work Faster, Efficiently, and you will be able to do complex tasks in a matter of minutes too.