Advanced Excel Training courses .pdf
Original filename: Advanced Excel Training courses.pdf
Author: Windows User
This PDF 1.5 document has been generated by Microsoft® Word 2016 / www.ilovepdf.com, and has been sent on pdf-archive.com on 14/09/2017 at 09:03, from IP address 182.64.x.x.
The current document download page has been viewed 261 times.
File size: 338 KB (2 pages).
Privacy: public file
Download original PDF file
Advanced Excel Training courses
Who is it aimed at?
Administrative officials, and in general, people with knowledge in the application of functions in
Excel Advanced course valid for Excel 2007, Excel 2010 and Excel 2013.
The Advanced Excel Course is aimed at training administrative staff, and in general, people who have
previous knowledge of Microsoft Excel at an intermediate level. The course will allow the student to
apply higher level processes in the use of Excel tools, such as Macros, forms, templates, menus, and
databases, among others; which will be of great utility to you for more complex processes in your work.
At the end of the Advanced Excel Course, the participant will be able to apply and design complex
functions such as macros, forms, templates, menus, and databases in Microsoft Excel.
Creating and Modifying Pivot
Creation and modification of dynamic tables from a data table, application and allocation of filters to
them to achieve a better search of information. Organization of dynamic tables to maintain a correct
order and application of totals and subtotals to the data entered.
Setting Value Fields
Assignment of the format indicated to the values that we have in our dynamic table, to obtain a better
representation of these and a greater understanding on the part of the user. Customize the operation of
dynamic values by applying simple calculation formulas already reviewed in advance.
Data Management in PivotTables
In the Advanced Excel Course, we will learn about Data Management, calculations, and support for
changes in Pivot Tables. Change source data from the PivotTable, deleting a PivotTable. Management,
updating, and control of multiple dynamic tables in the calculation book.
Creating and modifying dynamic listings from a pivot table created from a data table in a spreadsheet in
Microsoft Excel. Customizing the layout of the PivotTable and specifying the corresponding options in
the same table. Correct display of the created list.
Creating and modifying dynamic charts from the selection of a Pivot Table. Design, presentation, and
format of the same, assignment of additional elements of great utility. Graphical options to optimize
tasks, filters input and update data to be incorporated after the graph has been created.
What is the maximum time frame for the Microsoft Excel Advanced Online Course?
In both individuals and companies, the deadline for the course is flexible and to agree with the student
or business. These courses are designed to be carried out comfortably by those who have to combine
dedication to the course with their daily work.
Is there a schedule for the course?
In the case of the Advanced Excel training course, the access to the contents is available 24 hours, so
that the student can access at his discretion even on holidays and at any time. In these sessions, the
student can view the videos of the lessons, as well as perform the exercises and practices proposed.
However, consultations with the teacher are taken care of during working hours.
Do you receive a course certificate?
At the end of the online Microsoft Excel Advanced Course, the student receives a certificate attesting to
the success of the course and if necessary, specifying the course hours and content of the course.