Business Team 2

IT USERS PROGRAMS

Develop. Grow. Succeed.

Microsoft Office Application & PowerBi

 
Intensive F7F Wix.JPG
Dynamic Dashboard wix.JPG
Intensive PPT wix.JPG

INTENSIVE  EXCEL FUNCTIONS & FORMULAS

1 day

What will you learn in this program?


-Cell & Sheet References, Name References, Tables References

- Number functions General Number Aggregation functions

- SUM(), COUNT(), AVERAGE(), MAX(), MIN()

- Text functions

-COUNTBLANK(), COUNTA(), LEFT(), RIGHT(), MID(), FIND()

- Date and Time calculation

- Logical Related Calculation IF()

- Logical Comparison

- Nested function/Formula, Array formula, - Database related functions

- VLOOKUP() & MATCH(

DYNAMIC DASHBOARD FOR DATA ANALYST WITH POWERPIVOT & POWERQUERY

1 day

What will you learn in this program?


- Loading tables into Power Pivot

- Linking tables with relationships

- DAX function

- Building reports with Data Model

- Insert Pivot Reports

- Visualizing reports with dynamic charts

- Refreshing report

-Cleans Data

  • Extracting and Connecting data source

  • Editing and merging data from different sources

Transform Data

  • Edit Queries

  • Loading and refreshing cleansed data

INTENSIVE POWERPOINT DESIGN

1 day

What will you learn in this program?

- Rules in creating presentation

- Understanding the whole structure of PowerPoint, Normal Layout and Slide Master Layout

- Color and font pairing

- Creating custom layout and theme

- Sharing custom theme created by you

Highlights!

  • infographic to show statistic and timeline

  • Advanced animation with trigger

  • Adding media (video & audio)

excel dynamic wix.JPG
Excel Mac wix.JPG
Excel Pivot Wix.JPG

MASTERING DATA PRESENTATION AND VISUALIZATION

2 days

Unlike the traditional pivot table and Excel sheets, user are limited to analyse data within a million row of data at a time, per table at a time (it is extremely slow). With the capability of Power Pivot, add ins of Business Intelligent engine to Excel, it has since supercharge your excel into owning super power...

AMAZING MACRO

2 days

This in-depth two-day instructor-led course provides students with the knowledge and skills to use advanced features of Microsoft Excel macros. Participants will learn how to record macros, execute macros in variety of different methods, edit macros and create simple custom controls

MAXIMIZING PIVOT TABLE

1 or 2 days

Upon completion of this program, participants should be able to :
• Understand the benefits of PivotTable Reports
• Convert raw data in an Excel worksheet into meaningful PivotTables and PivotCharts
• Manipulate the PivotTable layout
• Use grouping
• Create custom calculations
• Use formulas and create formulas outside of a report
• Create a PivotChart and publish it to a Web site

Female Teacher and Student

IT USERS PROGRAMS (MS OFFICE & OTHERS)

Develop. Grow. Succeed.

Microsoft Office Application & PowerBi

 
Excel logo 2.JPG
PPT wix 2.JPG
Excel logo 1.JPG

MICROSOFT EXCEL FOUNDATION

1 day

MICROSOFT POWERPOINT INTERMEDIATE

2 days

MICROSOFT EXCEL INTERMEDIATE

1 or 2 days

App Screens
Excel logo 3.JPG
Powerbi wix.JPG

MICROSOFT POWERPOINT MASTER CLASS

2 days

MICROSOFT EXCEL ADVANCED

2 days

POWERBI WORKSHOP FOR USERS

2 or 3 days