Registration Deadline Expired!!

Basic Excel Training

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

The course benefits professionals because it explains the key concepts and terminologies in basic Excel, helping participants to enhance their skills and work efficiently. The course is designed to ensure that complex ideas are delivered to participants simply, thereby supporting them to utilize  the full power of Microsoft Excel. Now, you need not have years of experience to master Excel, but enroll in our basic training course to learn Excel with fun in the shortest possible time and an interactive manner.

 

Who should attend

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.

 

Trainer

We carefully choose all our trainers with rich and vast experience in the financial sector. The course will be conducted by an experienced training consultant having more than 15 years of industry experience with some of the world’s leading financial institutions, specializing in corporate finance, investment banking, and corporate fundraising

  • 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.

  • Create formulas in a worksheet?

  • Learning the use of insert functions.

  • Reuse formulas and functions?

  • 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.

  • 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

  • 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?
  • 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?

  • 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.

  • Absolute versus relative referencing

  • Relative formulas and the problems associated with them.

  • How to create absolute references?

  • How to create mixed references?

  • change fonts, font size, and font color?

  • Italicising, underlining, and making text bold.

  • Subscript, superscript, and strikethrough text?

  • Learning the use of format painter.
  • apply alternate currencies?

  • Apply alternate date formats?

  • Learning to format clock time.

  • Formatting of calculated time.

  • 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?

  • 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?

  • Managing worksheets.

  • Managing workbook and worksheet views.

  • Managing workbook properties.

  • preview and print a workbook?

  • Setting up the page layout.

  • Configure headers and footers?

  • Sorting of data.
  • How to filter data?
  • Outlining and subtotaling data.
  • Consolidating data.
  • Working with logical functions.
  • Working with date and time functions.
  • 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).

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

Tags

Course Event
  • Date : 03-04 October 2024
  • Time : 10:00 am - 5:00 pm (Asia/Ho_Chi_Minh)
  • Venue : Vietnam-HCMC
Download Brochure

    Contact for more info.






    Related Public Training

    Basic Excel Training
    Business Model Innovation
    Bangkok

    Business Model Innovation

    The course equips you with a comprehension on

    Basic Excel Training
    Liquidity Risk Management Risk Management
    Singapore

    Effective Liquidity Risk Management

    This interactive workshop course is apt for participants

    Basic Excel Training
    Financial Modeling
    Ho Chi Minh

    Financial Modeling in Excel

    The objective of this program is to provide

    etn/basic-excel-training-7