We are an Official Microsoft Partner. All Seven Institute trainers are Microsoft Certified.
By the end of this course you will know how to create spreadsheets, input data, understand how to print documents, how to perform simple calculations, you will learn basic formulas and functions, spreadsheet editing for a professional and presentable look. You will be introduced to using charts, copying, formatting and exploring the excel environment.
By the end of this course you will be comfortable using Excel functions and Excel formulas to calculate data over multiple worksheets and workbooks. You will learn to use Excel tables, in particular working with data (sorting, protecting, filtering, updating themes), data consolidation, conditional formatting, fixing formula errors, working with IF functions, how to view data in a variety of formats and printing complex documents.
By the end of the Excel Advanced course you will learn to use What-if analysis tools, advanced spreadsheet analysis tools including PivotTables, PivotCharts, Look Up funtions, advanced list functions, nested functions, and Excel macros for spreadsheet automation. You will be able to make the most of your date using the Excel PowerPivot add in for advanced data analysis.
The course will take your already elevated excel skills to the next level. You will be exposed to a variety of excel functions including financial functions, logical functions, time and date functions, text functions, lookup functions, reference functions, math functions, and other advanced formulas to perform complex operations and solve common problems. The Advanced Excel formulas and functions course is highly practical and focuses on creating Nested functionality.
By the end of the course you will know how to work with form controls and active x controls, be efficient working with advanced analysis tool, an introduction to excel PowerPivot and PowerView, solving advanced Excel tasks, you will also be introduced to VBA coding.
You will learn Visual Basic Programming within the Excel application. By the end of the course you will be able to create and edit your own automated procedures. The course covers objects, variables, VBA editor Window, Developing with procedures and functions, procedure core structures, forms and controls, program execution, using pivot table object, debugging and handling errors.
After attending VBA Advanced course you will know how to use arrays efficiently, understand and create class modules, know how to use ADO objects to import data from MS Access, Macro security application, distributing macros by saving as an Add-in, writing code that will allow you to interact with other Microsoft Office Applications such as Microsoft Word, writing and using code to interact with Microsoft Access Database an analysing this data in Excel.
Learn main Excel Charting Concepts: such as chart elements and charting related elements on the ribbon. You will be able to display data as a chart and master an advanced degree of editing the charts: inserting objects, scaling, adjusting positions, working with legends, axes and gridlines, designing tab configuration, formatting, using templates efficiently, working with chart types, changing chart’s data source and more.
By the end of this course you will know how to describe and create a PivotTable, how to efficiently work with PivotTable data, how to format PivotTables, apply a style as well as manually format a PivotTable, how to use a classic PivotTable layout. After this course you will also know how to work with advanced PivotTable tasks, use a calculation, a PowerPivot, Pivot Charts and how to use Macros with Pivot Tables.
By the end of the Excel PowerPivot add in Training you will know how to connect to and import data from a variety of formats including notepad, CSV, copy/paste, Microsoft Access and other databases. You will learn how to manipulate data in the data model, how to manage relationships in PowerPivot including the ability to create PivotTables based on multiple tables. You will also be able to create a PowerPivot chart from a PowerPivot data model and be introduced to DAX formulas for PowerPivot.
After this course you will know what is DAX for PowerPivot and what it is used for, how to write DAX formulas, how to use calculated columns, operations and operator precedence, how to use DAX aggregate functions in PowerPivot, how to use DAX fundamental functions for PowerPivot. The course covers DAX date and time functions, DAX text functions, DAX math functions AND TRIG functions as well as many other powerful DAX functions.