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.
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 “
- Lectures 0
- Quizzes 0
- Students 1
- Assessments Yes