Essential Excel Skills for Professionals

Excel for Professionals (Excel4Pros) is developed with requirements of the daily users of data analysis. In addition to function based learning, Excel4Pros centers its course around case-based learning, giving context to the user why we are using the Excel Tools. The course outline centers on multiple projects, which participants have to complete using various excel formatting, functions, analysis, and questioning. After the course, the participant will be able to apply Excel proficiently in the daily workplace, using best Excel practices.

Objective

Apply the best practice in data formatting and storing data for professional uses

Be efficient in the use of Excel

Apply the consistent formats across different units

Understand business analytics by asking right questions and extracting data

Create powerful, useful, and summarized visual information from large amount of data

Understand the needs of dashboards for management reporting

Present data into effective communications for Management

Essential Excel Skills for Professionals

1. Sorting and Filtering Functions
2. Formatting Functions
3. Data Validation
4. Pivot Tables and Charts
5. Viewing, Grouping, Analyzing Large Data Sets
6. Advanced Search Functions (VLOOKUP, Index Match)
7. Conditional Functions (Lookups, Ifs, Concatenate…)
8. Scenario Analysis
9. Creating Projects and Reports
10. Excel Shortcuts

Essential Excel Skills for Professionals

Tuition : 145,000 MMK

Total Hours : 21 hours

Lecturers : U Min Han Tun, CFA