Microsoft Excel - Advance Level for Professionals

Date:04-05 May 2018
Time:10:00 am to 05:30 pm
Last Date of Registration: 02 May, 2018
Venue:DBI, Dhaka Chamber Building (11th Floor), 65-66 Motijheel C/A, Dhaka-1000

Course Fee: Tk. 4500

Contact: 01913745062, 9552562 (Ext 137),
Content: Discover the inside of MS-Excel interface, different types of Tools options and their activities apply, using of Function and Formula calculation for relevant or specific purpose, Find out TOP 10 categories of revenue, sales, expense, inventory counting etc. from relevant database source, Duplicate data identification and manage accordingly, Giant quantity of database sorting and managing, Filtering data, PIVOT-data table management and analysis process, Conditional formatting apply in MS-Excel worksheet, Percentage (%) calculation and its placing in proper way, Learn how to use VLOOKUP for find out required data from giant database list or data table, Graphical presentation of database information (different types of bar chart, pie chart, line graph etc and their purpose of using). Printable page layout setting. Provide tips and tricks and shortcut key using for saving valuable working time. Test of learning.