English 
English
You will learn how to use some of the more common functions like IF statements, CountIF , Vlookup, Hlookup and SumIf. You will also see how you can create create superb visualisations using charts and maps. The Pivot tables and charts feature will enable you to manage and report on large data sets and remain in control of your data no matter how complicated the raw data set looks.
Outline is below:
· Conditional formatting
· Average function/Count
· Maximum function/Sum
· Minimum function/SumIF
· Basic Scenarios
· Sheet Layout and design
· Named Cells/Ranges
· Absolute Referencing/ percentages
· Basic Pivot Tables
· Using 3-D Referencing
· Goal Seek
· Data Tables
· Sheet and cell Protection
· Linking Sheets and Workbooks
· Using Array Formulae
· Using Group and Outline/Saving Views
· Naming Worksheets
· Using the Subtotals Feature
· Creating Templates
· Basic Lookups/Basic IF
- Automate Excel features - link sheets and files
- Understand how Pivot tables work
- Gain knowledge of data analytical tools
Once bought, the course will be accessible by clicking the "MY COURSES" button on the toolbar placed on top of the website, or accessing to the "Learn" section on your Student Dashboard.
The course price includes: lifetime access to the course material (including attachments and handouts), access to the course's Thread board where you can get in touch with the teacher and other fellow students eduCoins and eXP (variable values directly related to the price of this course), Certificate of Completion when the course is fully completed.
