Advanced MS Excel 2013

Advanced MS Excel 2013

Tonar Systems Advanced MS Excel Course 2013 course covers all the Excel functions to perform financial, mathematical or statistical calculations such as, DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros. You will also get to implement an Excel project towards the end of the course.

Prerequisites This Advanced MS Excel course is designed to anyone who wants to become a pro in Excel 2013. Also this course enables you to turn data into information with powerful tools to analyze, communicate, and share results. It can help you work better in teams, help to protect and control access to your work. • Skills: Excel Basics. • Software: Windows 7 / 8 – 32 / 64-Bit, Microsoft Office 2013 • Hardware: 500 MHz processor, 256 MB Ram, 3 GB HDD. • Internet: 1.0 Mbps Broa

Why learn Advance Excel Course 2013? Excel is one of the most used software applications of all time. This course is designed for the users those who want to perform accurate and rapid calculations with results ranging from simple calculation to complex financial analyses. Advanced MS Excel Course helps you to structure and present your data impressively.

Course Objectives After the completion of Advanced MS Excel 2013 course at Tonar Systems, you will be able to: 1. Understand Excel Abilities and its Functions. 2. Explain Data Security, Formatting and Analyzing concepts. 3. Understand the specialized functions like DSUM, DMAX etc. 4. Explain the advanced options of Pivot Table. 5. Summarize data by using Sparklines. 6. Record and play a macro. 7. Edit a macro using VBA Editor. 8. Explain how to manage scenarios. 9. Describe the restric

Classes Start On

2018-12-17 00:00:00.000000

Course Duration

30 Days

Course Price

Price : 5000 Rs.