Gain insights from your data
Position the data
Organize your text or numeric data into spreadsheets and workbooks. Seeing it in context helps you make better decisions.
Rearrange and reformat it
When you look at different versions of the data, Excel learns and recognizes your patterns and auto-completes the rest of the data. No macros or formulas are required.
Analyze the data
Excel will carry out complex analyses for you. You can summarize your data with previews of pivot-table options in order to compare them and choose the most appropriate.
Microsoft Excel is a spreadsheet application program developed by Microsoft for Windows, Apple Mac, Android and iOS. It provides calculation, graphing tools, pivot tables and Visual Basic for Applications which is a macro programming language. It used extensively across all types of organizations and is the industry standard for spreadsheets. Excel is a key component of Microsoft Office, which also includes Access, Word, PowerPoint and Outlook.
Microsoft Excel has all the standard features spreadsheets and then some. It uses a grid of cells arranged in numbered rows and letter-named columns to display and store your data and to organize automatic calculations on that data, for example to sum a list of values to provide a total. It has a wide array of supplied functions to meet financial, statistical and engineering needs.
Numerical data can also be displayed as graphs, such as pie-charts, bar charts, line graphs and histograms. It has powerful tools that allow users to analyse data using sectioning with pivot tables and to examine dependencies on various factors with scenario manager.
The Visual Basic for Applications (VBA) programming language allows the development of automatic execution of calculations and user interactions can be hidden to produce fully developed applications for specific purposes such as decision support systems, stock analyzers and dashboards.
Excel can also retrieve data from external databases and then analyze that data and present the results in various ways such as pivot tables or graphs. Excel can be part of a business intelligence solution to help manage organizations.
Our beginners’ Microsoft Excel course. This one day course is ideal for users new to Excel and assumes no knowledge of Excel. You will learn how to use the Excel user interface, enter data, use formulas and functions, format your work to look attractive and print and save your worksheets.
This course will extend your Excel knowledge and skills. If you have been using Excel for some time it’ll take your skills to the next level and streamline your work. This course shows you how to use advanced formulas, organize worksheet and table data, create advanced charts and graphics and analyze data using Pivot Tables, Slicers and PivotCharts. You will insert and modify graphic objects and customize and enhance workbooks. Why not find out what Excel can do for you?
In our advanced Excel course we will show you how to use Excel’s most powerful functions. You’ll skills that let you:
Enhance productivity by streamlining workflow, Collaborate with others, Audit worksheets and analyze data. In addition you’ll: Work with multiple worksheets, Import and export data, Integrate Excel data with the web and Structure workbooks with XML.
On our 2 day Excel VBA course, you’ll learn Applying Macros, Developing using Procedures and Functions, Using Objects, Controlling Program Flow, Utilising Variables and Expressions, Debugging the code, Handling Errors and Employing Forms and Controls.
This 1 day course will prepare you to create advanced workbooks and worksheets that you can use to produce dashboards. The ability to analyze large amounts of data, extract actionable intelligence from it, and present that information to decision makers is the key to operating a successful organization that is able to compete at a high level.
Upon successful completion of this one day Microsoft Excel training course, you will be able to use Power Pivot to analyze data from a variety of sources.
Upon successful completion of this course, you will be able to use Excel’s advanced PivotTable functionality to analyze your raw data.
History of Excel Versions
In-cell charts called sparklines
New Conditional Formatting Features in Excel 2010
Making your own ribbon in Excel 2010
Office 2010 backstage feature for document-related tasks
Many new formulas, most highly specialized to improve accuracy
Improved pivot tables
Excel’s new Start Screen helps you get to work more quickly
Enjoy a new Backstage View which is accessible from the File menu
Make Flash Fill magic – Its predictive data entry can detect patterns and extract and enter data that follows a recognizable pattern.
Simplify choices with Recommended Charts
Quickly analyze your data using the Quick Analysis tool
Answer questions instantly with Recommended Pivot Tables
Make quick reports with Power View
Share files and work with other people
Share work to your social networks
Major database enhancements with Power Pivot and Power Query
Read-only mode for Excel
Keyboard access for Pivot Tables and Slicers in Excel
New Chart Types such as Pareto and Waterfall
Excel forecasting functions
Support for multi-selection of Slicer items using touch
Time grouping and Pivot Chart Drill Down
Excel data cards