Microsoft Excel is a spreadsheet establish by Microsoft for Windows, macOS, Android and iOS. Its main function is calculation, graphing tools, pivot tables, and a macro programming language.
Excel has the same basic features as every spreadsheet, which use a collection of cells arranged into rows and columns to organize data manipulation. They also display data as charts, histograms and line graphs.
Learn the expert features and functions in Microsoft Excel, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel.
In this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we will quickly move onto more advanced-level topics including VLOOKUP and HLOOKUP, IF statements, Sparklines, Pivot Tables and Charts, Macro Operations.
Suitable for beginners with Microsoft Excel but also for those who wish to cover the advanced topics in Excel, which will enable you to use Excel expertly within in a personal or commercial environment.
This course covers:
- Using advanced graphs and presentation techniques to maximize impact.
- How macros and VBA automate your spreadsheets and increase interactivity.
- How superpower functions can solve complex problems.
- Using PivotTables and PowerPivots to turn raw data into clear information that supports key decisions.