Microsoft Excel Advance هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

Have some experience with Excel and want to improve your skills? This course will help you learn Intermediate and Advanced Excel techniques. Whether you use Excel for work or study, this training will help you on your journey to becoming an Excel Expert!

This workshop is highly interactive, as participants will be challenged to step out of their comfort zones and demonstrate the techniques practically. You will learn how to find a value with VLOOKUP, create and format Pivot Tables, record Macros and more. Designed and delivered by internationally qualified and experienced trainer, the workshop can be tailored in alignment with your business objectives.

Course Content:

Conditional Formatting

• Formatting Cells Containing Values
• Clearing Conditional Formatting
• Working with Data Bars, Colour Scales and Icon Sets
• Creating and editing Sparklines

Sorting Data

• Performing An Alphabetical Sort
• Performing A Numerical Sort
• Sorting On More Than One Column
• Sorting By Vertically & Horizontally

Filtering Data

• Understanding Filtering
• Applying, Using and Clearing A Filter
• Creating Compound Filters
• Creating Multiple Value and Custom Filters
• Using Wildcards

Filling Data

• Understanding Filling
• Filling A Series
• Creating, Modifying and Deleting A Custom Fill List

Charting Techniques

• Adding Chart and Axes Titles
• Positioning The Legend
• Show Data Labels and Data Table
• Modifying The Axes
• Creating a combination chart
• Creating 2 Axis chart

Creating Charts

• Choosing The Chart Type
• Creating A New Chart
• Working With An Embedded Chart
• Resizing and changing Chart type

Advance Validation

• Creating drop down in cells
• Restricting values from list only
• Creating error messages
• Creating dependent lists

Text Options

• Text to Column, SubTotal and Paste Special
• Group / Ungroup
• Sharing workbook

Pivot Tables

• Understanding Pivot Tables
• Creating A PivotTable Shell
• Filtering A PivotTable Report
• Clearing A Report Filter
• Formatting A PivotTable Report
• Understanding and Creating Slicers

Dynamic Table

• Converting data into table
• Automation calculation in table
• Converting table to normal range
• Using table in Charts & Vlookup

Logical Functions

• Understanding Logical Functions
• Using IF To Display Text
• Using IF To Calculate Values
• Nesting IF Functions
• Using IFERROR, AND and OR Functions

Formula Referencing

• Absolute and Relative Referencing
• Problems with Relative Formulas
• Creating Absolute References

Macros

• Recording & Running Macros
• Creating button to run the macro
• Assigning shortcut to macro
• Deleting Macros
• Relative reference in Macros

Formulas

• Count, CountA, CountIF & CountBlank
• Sum, SumIF & SumIFs
• Networkdays
• Today, Now, Trim and Concatenate functions

Lookup Functions

• Normal Vlookup & Hlookup
• Vlookup with IFError
• Vlookup from Multiple Sheets using IFERROR
• Using IF Condition and Multiple criteria in Vlookup

File / Data Security

• Open & Modify file password
• Protect sheet from deletion, data copy or protect few cells, rows or columns

تحديث بتاريخ 03 March, 2020