Basic Excel Training Course

The Excel introductory training course is a complete beginner’s course that includes all the basic concepts in Microsoft Excel. It enables you to master the basics of Microsoft Excel and use Excel with ease in your everyday routine. Our course also offers in-depth knowledge of the most common Excel functions used in the Office. The participants of this course will gain a strong foundation in Excel knowledge and skills. The course also includes a lot of one-to-one attention and time for asking numerous Excel-related questions.

Overview

All individuals who want to improve their basic excel skills should attend this course

• Middle to senior managers from different industries
• All professionals who want to deal or currently deal with financial modeling in their company
• Consultants, advisors, and other professionals who wish to improve their Excel skills

Methodology

The non-theoretical methodology includes interactive discussions, case studies, interactive games, and assignments to understand the concepts and their applicability.

Module – 1: Excel: Introduction

• Navigating through the Microsoft Excel
• Commands in Microsoft Excel
• Creating and saving a workbook and entering cell data in it.
• Learning the use of Excel help.

Module – 2: Making Calculations in Excel

• Create formulas in a worksheet?
• Learning the use of insert functions.
• Reuse formulas and functions?

Module – 3: Creating a New Workbook

• Learning the use of a blank workbook template.
• How to text, numbers, dates, and formulas in a workbook
• Saving a new workbook on your PC and safely closing it.
• Checking spellings and making basic changes in a workbook.

Module –4: Selecting Ranges

• Learning what ranges are.
• Select non-contiguous ranges, more extensive ranges, and rows and columns?
• Learning the use of special selection techniques.
• View range calculations

Module – 5: Sharing Workbooks

• Share workbooks through the Network and OneDrive?
• Opening of shared workbooks.
• Accept, reject, or disable tracked changes in a workbook?
• Add, navigate, edit, and delete comments in a worksheet?

Module – 6: Entering Data

• Fill a series, growth series, and a series backward?
• Creating, modifying, and deleting a custom fill list?
• Extracting data using Flash Fill and studying complex Flash Fill extractions.
• How do you extract dates and numbers?

Module – 7: Formulas and Functions

• Create formulas for adding, subtracting, multiplying, and dividing?
• Understanding functions and learning the use of SUM function for adding.
• Calculating the maximum value, minimum value, and average.
• Learning about the common error messages.

Module – 8: Formula Referencing

• Absolute versus relative referencing
• Relative formulas and the problems associated with them.
• How to create absolute references?
• How to create mixed references?

Module – 9: Formatting of Fonts

• Change fonts, font size, and font color?
• Italicising, underlining, and making text bold.
• Subscript, superscript, and strikethrough text?
• Learning the use of format painter.

Module – 10: Formatting of Numbers

• Apply alternate currencies?
• Apply alternate date formats?
• Learning to format clock time.
• Formatting of calculated time.

Module – 11: Applying Borders

• Apply borders to a cell and a range?
• Applying a bottom border and top and bottom borders.
• Learning the use of the More Borders command.
• Remove and erase borders?

Module – 12: Editing and Formatting a Worksheet

• Inserting, deleting, and adjusting cells, columns, and rows.
• Search and replace data?
• Applying text formats and number formats.
• Apply styles, themes, and basic conditional formatting?

Module – 13: Managing Workbooks

• Managing worksheets.
• Managing workbook and worksheet views.
• Managing workbook properties.

Module – 14: Printing Workbooks

• Preview and print a workbook?
• Setting up the page layout.
• Configure headers and footers?

Module – 15: Working with Lists

• Sorting of data.
• How to filter data?
• Outlining and subtotaling data.
• Consolidating data.

Module – 16: Advanced Functions

• Working with logical functions.
• Working with date and time functions.

Module – 17: How to Manage Some Shortcuts

• approach keyboard shortcuts in Excel?
• Learning the use of ribbon keyboard shortcuts for Excel.
• Create quick access toolbar keyboard shortcuts and custom keyboard shortcuts?
• Understanding the use of dialog box keyboard shortcuts for Excel (hotkeys).

Module – 18: Data Visualization with Charts

• create charts in Excel?
• Modify and format charts in Excel?

If you want to know more about the program, please refer to our course page at Riverstone Training schedule