Excel Course

ADVANCED EXCEL COURSE IN DUBAI

Excel Course is just what you’ll need to increase excel skills confidence and take your current excel skills to the advanced excel level!

Excel Course Pivot Tables take data management for the user to another level, you can organize long lists of information and create custom tables from a list of entries or a database.

Excel Course “IF” function is a condition statement, to display if the condition is met, and if the condition isn’t met.

Learn Excel filter and Sort are though there are some similarities, there are some differences. While sorting rearranges entries in a particular order, filtering enables you to display only the specific information you need.

Excel Training VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index number position. VLOOKUP function is a built-in function in Excel can be used as a worksheet function in Excel. As a worksheet function, VLOOKUP function can be entered as part of a formula in a cell of a worksheet. Advanced Excel Course Chart function is useful when presenting your results, you don’t deal with too much text and numbers.

Excel Course Benefits:

Advanced Excel training skills you’ll gain in this one week is more practical in less time to use at your work place. Advanced Excel Course training provides you to work with hands-on exercises without wasting your valuable time.

EXCEL COURSE TOPICS FOR DISCUSSION:

UNIT-1:

 Microsoft Excel Ribbon & shortcut menus

 Practice to format Excel worksheets

 Practice  to use simple Excel worksheet basic functions that auto sum, max, min and average

 Preparing worksheet tables 

 Practice to use Conditional Formatting features

UNIT-2:

 Practice Absolute and Relative Cell References

 Lists – Filtering, Auto filtering & Advanced Filtering

 Sorting – Custom & Multiple Column Sorting

UNIT-3:

 Summarize data using key worksheet functions like IF, SUMIF, COUNTA and COUNTIF 

 Excel data-Group, Outline and Subtotal

UNIT-4:

 How to use VLOOKUP and HLOOKUP

 Linking – Workbooks, Exporting & Importing Data

 Practice to prepare business charts 

 Generate report with Pivot Table and Pivot Chart.

UNIT-5:

 Excel Financial Functions PMT()

 Data Tables – One Input & Two Input Data Tables

 Data Consolidation

UNIT-6:

 How to Remove Duplicates

 How to use page setup and print features

 Excel Security – Workbook, Worksheet and Cell Protection & Hiding

 Sharing Workbooks

VIDEO LESSON

 

Instructor-led Training.

Experienced Trainers.

Certificate on Completion

Duration: 1 Week
Certificate 

$200

Enquire Now!


Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp