Microsoft Excel Data Analysis
Microsoft Excel training throughout the UK, including Manchester, Leeds, Birmingham, York, Carlisle, Newcastle, Sheffield, Glasgow, Edinburgh, Aberdeen, Derby, Norwich, Portsmouth, Swansea, Cardiff, Chester. For overseas training and contracts, please call to discuss your requirements.
Microsoft Excel Data Analysis – Course Outline
About This Course
With Excel's Data Analysis features, you will work with the following topics: PowerBI, PowerPivot, PowerQuery, PivotChart, and DAX
Target Audience
Delegates who have good working knowledge with Microsoft Excel
Excel's Power Query
After completing this course, students will be able to:
-
Cover all aspects of PivotTables
-
Understand the advantages of Power Query
-
Linking to databases
-
Linking tables
-
Filter data
-
Create custom formulae
-
Combine multiple files
-
Create lookup files
Course duration: one day
Excel's PowerPivot - Working with DAX
After completing this course, students will be able to:
-
Understand the DAX formula tool
-
Understand DAX measures
-
Work with multiple data sets
-
Work with Time Intelligence
-
Use conditional functions
-
Work with X functions
-
Work with custom calendars
Course duration: one day
