About this course
What’s new in Excel 2019 Creating workbooks Entering text, numbers and working with dates Navigating workbooks Page setup and print options Working with rows, columns, and cells Cut, Copy and Paste Introduction to Functions and Formulas Formatting in Excel, including …
What's included
Certified instructors
Certificate of completion
Hands-on lab exercises
Interview Q&A prep
Free study materials
London-based training
Lifetime access
Placement support
Course overview
What’s new in Excel 2019 Creating workbooks Entering text, numbers and working with dates Navigating workbooks Page setup and print options Working with rows, columns, and cells Cut, Copy and Paste Introduction to Functions and Formulas Formatting in Excel, including formatting cells and numbers Creating charts and graphs Sorting and Filtering Introduction to PivotTables Logical and lookup formulas – the basics Advanced Microsoft Excel 2019 What’s new/different in Excel 2019 Advanced charting and graphing in Excel How to use detailed formatting tools Lookup and advanced lookup functions Financial functions including calculating interest and depreciation Statistical functions Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web. How to create awesome visualizations using sparklines and data bars Mastery of PivotTables and Pivot Charts Scenario Manager, Goal Seek and Solver Advanced charts such as Surface, Radar, Bubble and Stock Charts
Free preview lessons
Industry-Recognised Certification
Complete this course and earn a certificate recognised by employers across the UK and internationally. Prepare for official vendor exams with confidence and hands-on practical experience.