Basic & Advanced Excel

EXCEL COURSE OVERVIEW

The aim of this course is to teach participants how to use Microsoft Excel. Moreover, an introduction to data analysis using Power Pivot calculations and reporting, understanding and apply the fundamentals of Excel model for decision-making.
HRIB is providing “Excel Course” in Egypt in high impact capacity building workshop to individuals and organisations in a variety of industries then they can understand the value of analyzing data, forecasting, and making decisions using Excel, Indeed Excel Basics Course in Egypt will turn your skills to next level.

KEY BENEFITS

Firstly: Excel spreadsheets that work

Secondly: Managing huge data sets

Thirdly: Using some of Excel’s most common functions for example (SUM, LOOKUP, IF, AVERAGE, INDEX/MATCH, and many others…)

Fourthly: Excel PivotTables can be used to create a dynamic report.

Fifthly: Make the most of Microsoft Excel’s PowerPivot Add-In by learning how to use it.

Sixthly: Examine the formulas in Excel Worksheets to ensure that they are free of errors.

Lastly: Learn the power of Macros and VBA to automate your regular Excel tasks.

EXCEL COURSE OUTLINE

Firstly: Microsoft Office Excel: Getting Started

• Using Excel’s User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Make Use of Excel’s Help

Secondly: Carrying out Calculations

• Formulas for Worksheets
• Insert Functions
• Reuse Formulas and Functions

Thirdly: Making Changes to a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Data Retrieval and Replacement
• Use Proofing and Research Tools

Fourthly: Worksheet Formatting

• Use Text Formatting
• Application of Number Formats
• Align the Contents of the Cells
• Styles and Themes to Use
• Apply Basic Conditional Formatting
• Create and Use Templates

Fifthly: Workbook Printing

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

Finally: Managing Workbooks

• Worksheet Management
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Moreover, See Courses and Workshops

Lastly, Start learning with a wide range of best courses covering different subjects “ Talent Expert “