One of the most important Excel features is Pivot Tables. This course covers creating Pivot Tables as well as using calculated fields and filters. You will learn to connect to external data sources such as Access and web queries. You will learn to use lookup functions and data tables to allow more sophisticated data conversion functions. This course will also show how to record and execute simple macros. This course is designed for students who need to use Pivot Tables and more advanced functions in Microsoft® Office Excel® 2010.
Microsoft Excel is commonly used for financially-related activities. The reason for its popularity is that the user can define custom formulas for calculating quarterly, half yearly and annual reports. This spreadsheet software also helps the individuals and professionals to effectively keep a track of sales leads, project status reports, and invoice reports. Microsoft Excel is also very popular among professionals from science background as it allows them to easily work with statistical formulas and graphing.
Excel 2010/2013 Intermediate or equivalent skills. Must be able to work with multiple worksheets, use named ranges, and work with functions.
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
|25-26thApril 2018||Training Centre: Wisma Goshen, Plaza Pantai, KL
|15th April 2018|
|FEE||PAX||Early Bird||After Early Bird|
|1||RM 475||RM 575|