Basic Excel Training

Riverstone Training Pte Ltd

The Excel introductory training course is a complete beginner’s course that includes all the basic concepts in Microsoft Excel. It enables y

Pullman Bangkok Hotel G

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.OverviewThe 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<ul><li>Middle to senior managers from different industries</li><li>All professionals who want to deal or currently deal with financial modeling in their company</li><li>Consultants, advisors, and other professionals who wish to improve their Excel skills</li></ul>Methodology  The nontheoretical methodology includes interactive discussions, case studies, interactive games, and assignments to understand the concepts and their applicability. TrainerWe 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.Course ContentModule – 1Excel: 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 – 2Making Calculations in Excel• Create formulas in a worksheet?• Learning the use of insert functions.• Reuse formulas and functions?Module – 3Creating 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 – 4Selecting 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 calculationsModule – 5Sharing 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 – 6Entering 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 – 7Formulas 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 – 8Formula Referencing• Absolute versus relative referencing• Relative formulas and the problems associated with them.• How to create absolute references?• How to create mixed references?Module – 9Formatting 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 – 10Formatting of Numbers• apply alternate currencies?• Apply alternate date formats?• Learning to format clock time.• Formatting of calculated time.Module –11Applying 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 – 12Editing 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 – 13Managing Workbooks• Managing worksheets.• Managing workbook and worksheet views.• Managing workbook properties.Module – 14Printing Workbooks• preview and print a workbook?• Setting up the page layout.• Configure headers and footers?Module – 15Working with Lists• Sorting of data.• How to filter data?• Outlining and subtotaling data. • Consolidating data.Module – 16Advanced Functions• Working with logical functions.• Working with date and time functions.Module – 17How 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 – 18Data Visualization with Charts• create charts in Excel?• Modify and format charts in Excel?If you need further information, please visit www.riverstonetraining.com.sg or send mail at info@riverstonetraining.com.sgRiverstone – Corporate Traininghttps://www.riverstonetraining.com.sg