About Microsoft Excel Training Program Overview
Microsoft Excel is a Spreadsheet developed by Microsoft for Windows, MacOS, Android and iOS. It features Calculation, Graphing Tools, Pivot Tables, and a Macro Programming Language called Visual Basic for Applications. It has been a very widely Applied Spreadsheet for these Platforms, especially since Version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for Spreadsheets. Excel forms part of Microsoft Office.
Course Targeted Audience
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.
After Completion of Course
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.
Basic Excel Certification
Delphi Star Training provides a Basic Excel Certification letter at the end of the Course; it’s a Professional Document Work as a proof to show that a Potential Job Candidate has completed a Basic Excel Course and is eligible for a particular job. The Certification consists of your Grade / Marks achieved according to the performance of the Assignments / Case Studies you have done. The Certification card will be labeled with Course Name, Course duration along with a Grade.
In case you have a low grade for the first time, you can have a complete assistance from Delphi Star Training in finishing the Assignments / Case Studies with help from our Instructors. We are here to help you 24×7.
Upcoming Batch Schedules
|Training Type||Start Date|
|Blended – Classroom + Online||28.09.2018||Join Online|
|Live Instructor-Led Online||28.09.2018||Join Online|
Basic Excel Course curriculum:
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.
Using The Blank Workbook Template.
Saving a New Workbook on Your Computer.
Checking the Spelling.
Printing a Worksheet.
Safely Closing a Workbook.
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.
Using Undo And Redo.
Understanding Cells and Ranges.
Selecting Contiguous Ranges.
Selecting Non-Contiguous Ranges.
Using Special Selection Techniques.
Selecting Larger Ranges.
Viewing Range Calculations.
Creating an Input Range.
Creating Formulas that Add.
Creating Formulas that Subtract.
Formulas that Multiply and Divide.
Using the SUM Function.
Summing Non-Contiguous Ranges.
Calculating an Average.
Finding a Maximum Value.
Finding a Minimum Value.
Creating more Complex Formulas.
Common Error Messages.
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.
Absolute versus Relative Referencing.
Problems with Relative Formulas.
Creating Mixed References.
Understanding Font Formatting.
Working with Live Preview.
Changing Font Size.
Growing and Shrinking Fonts.
Making Cells Bold.
Changing Font Colours.
Changing Background Colours.
Using the Format Painter.
Practice Exercise Samples.
Understanding Cell Alignment.
Horizontal Cell Alignment.
Aligning to the Centre.
Vertical Cell Alignment.
Aligning to the Middle.
Wrapping and Merging Text.
Merging and Centering.
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.
Understanding Number Formatting.
Applying General Formatting.
Formatting for Money.
Formatting as Fractions.
Formatting as Dates.
Using the Thousands Separator.
Increasing and Decreasing Decimals.
Previewing before you Print.
Selecting a Printer.
Printing a Range.
Printing an Entire Workbook.
Specifying the Number of Copies
The Print Options.
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.
How does it work?
This is Basic Excel training:
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 ever had.
You will have access to 24×7 Technical Support. You can request for assistance for any problem you might face or for any clarifications you may require during the course. Take assistance of Excel Online Tutorial.
At the end of the Excel Training, you will have to work on a Project. You will receive a Grade and a Verifiable Certificate on the successful completion of this Project.
Mode Of Training
BASIC EXCEL CLASSROOM CUM ONLINE TRAINING (AED 499)
Duration: 05 Hours
Material: Step by Step Study Material with Screenshots.
Recordings: As we record all the Sessions, we provide complete Classes in Video form to review Later.
Support: 24/7 Live Support, any Queries are responded Quick.
Certification: Certificate on completion of Course