Introduction to Microsoft Excel
Course Overview
Introduction to Microsoft Excel training, empowers participants with key skills to: create and edit worksheets, implement formulas and functions, sort and filter detail data with tables and slicers. Visualise the numbers in a consumable and professional format analysing data with charting, conditional formatting, sparklines, and pivot tables.
This course is delivered over 3 full days.
Key Information
                                    Course Length
                                    
                                    
                                    
                                    
                                                                                    24 hours
                                                                                                                
                                
                                        Learning Method(s)
                                        
                                                                                    Online materials
                                                                                
                                                                                                                                                                                                                Online assessment
                                                                                
                                                                                                                                                                
For Individuals
Cost and Funding Information
                                                Full Cost Price
                                                
                                                                                                    £1,314.00
                                                                                                                                                
Study this course
Get in touch with us today to register your interest
Register interestBuy the course today and begin your journey to qualification
- Efficiently navigate and manipulate worksheets and workbooks
- Implement an income and expense statement with formulas, functions and names
- Design a reusable data entry template that protects formulas
- Implement conditional formatting to analyse sales information
- Connect, prepare and validate data employing editing tools, formulas, and Flash Fill
- Identify, sort and select detail data with tables and slicers
- Present and analyse data with conditional formatting, charting, sparklines, and printing parameters
- Construct IF functions that make decisions - present results visually
- Combine data with 3-D formulas
- Analyse summary data with PivotTables and implement a quick dashboard