1,116 total views, 2 views today
Excel training in Los Angeles and anywhere in Switzerland, USA, Great Britain and Germany.
Discover trough examples of real case studies in detail all options available in the MS Excel analysis tool add-in for business or statistics analysis.(more...)
Being able to set up and use common business mathematical models and tools in relation to business decision support (in various fields such as finance, quality, R&D, Marketing, etc.) using specialized functions, the solver and the MS Excel analysis toolpack.(more...)
Learn the procedures to automate simple repetitive taks in MS Excel with recorded macros. The main objective of this training is to get prepared to the VBA training (automate without the macro limitations)(more...)
Master all the different types of charts and their options of formatting, analyzing, printing and dynamic behavior.(more...)
Learn every MS Excel 2007 and 2010 conditional formatting features by using basic or advanced criteria.(more...)
Learn the basic features of a worksheet application such as creation of small tables with basic functions and formulas. Create basic charts using the standard options from the wizard. Learn the worksheets' basic settings for printing layout.(more...)
Create professional forms and tables ready for corporate deployment, to be used as corporate templates.(more...)
Indeep the PowerPivot and Power BI courses by addressing the 120 most important functions (formulas) of the DAX formula and query language (Data Analysis eXpressions) to create more complex dynamic Pivot tables with statistical measures or elaborated time intelligence measures, or to create DAX queries. This training also prepares the attendee for the Power BI 70-778 certification and for the Power BI Desktop training.(more...)
Import/export of data from or to MS Excel using various available data files type.(more...)
Learn the useful and essential techniques for the management, the synthesis and the analysis of data lists (databases) with the standard tools and options of MS Excel.(more...)
Extract data from various sources and benefit from calculation functions and formatting tools of PivotTables and PivotCharts to aggregate and report simple data collection.(more...)
Create an MS Excel table with functionalities close to MS Project for micro-projects management, for personal tasks management or team planning.(more...)
Take a look at the Power View add-in, which allows you to publish dynamic, interactive, and real-time updated dashboards on the SharePoint Intranet or Office 365. The various tabular, matrix, charts, columns, lines, pie charts and geographic charts will be studied in detail and their known limitations will be communicated by the trainer. This training also prepares the attendee for the Power BI Desktop training.(more...)
Learn to use and combine the 100 most common MS Excel functions in statistics, logic, database, time management, text modification and finance.