Consolidating data multiple workbooks excel

10-Feb-2016 20:11 by 3 Comments

Consolidating data multiple workbooks excel

The Advanced Excel training will help me get my job done very quickly and easily.Manual steps that used to take hours will now take only a few minutes with the use of advanced formulas, macros and other tricks I learnt in the Excel 2013 workshop.

The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel.

It will impart the necessary skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2013, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

To Register for Microsoft Excel 2013 Training, Simply Register Online, and book your seat today.

Or send an online enquiry if you have any questions.

You can call Kamini at (65) 6296-2995 or email to [email protected] for any questions, or to register for the upcoming training class of Advanced Excel 2013.

We also offer Corporate Trainings for Advanced Excel 2013 version.

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet.

You have also used paper-based systems to store data that you run calculations on.

You now want to move that data to an electronic format.

In this course, you will use Microsoft Excel to manage, edit, and print data in a spreadsheet.

As you are now able to edit, format, and print basic spreadsheets, you now need to streamline repetitive tasks and display spreadsheet data in more visually effective ways.