Microsoft Excel courses in Blackrock

The standard course content can be delivered over one day or customise to meet your specific requirements. it can be delivered on-site, to groups or one-to-one. In fact, we often customise it to suit the types of data, data sources and reports our clients use rather than stick to a standard course so that you…

After completing this course you will be able to build complex data analysis and decision making models; use what-if scenarios, solvers and build reports. You will be able to mine data with PivotTable and PivotChart reports; you will build complex interactive spreadsheets.

After completing this course you will be able to design and manage spreadsheets; apply best practices; troubleshoot complex models; analyse large amounts of data with PivotTables and PivotCharts; generate and customise charts to suit most purposes.

After completing this course you will be able to describe the main uses for Excel spreadsheets; create new spreadsheets; use tools and commands to edit existing spreadsheets; perform calculations and simple statistics; visualise data with pie and column charts; print professional looking workbooks including headers and footers, page numbers

After completing this course you will be able to record, edit and troubleshoot macros, understand the Excel Object Model, write manually simple programming routines in the Visual Basic Editor (VBE) environment as well as reuse and adapt existing code.

fter completing this course you will be able to describe the main ways to import and query data using Power Pivots workbooks in Excel, to generate PivotTable and PivotChart reports and to create relationships between Power Pivot tables.