Description
Our Microsoft Excel & Word 2019 course is here to help you master both Word & Excel 2019!
This exceptional training bundle spans over 3 courses and includes 24 hours of in-depth training. Sign up now!
Microsoft Excel 2019 Beginner to Advanced (2 Courses):
Microsoft Excel is a worldwide used program, developed by Microsoft for Windows, Android, iOs, and macOS. Excel has lots of features including pivot tables, calculation, graphs, macro programming and much more.
Included in the Excel course is 16 hours of specially crafted and designed video tuition combined from 2 in-depth courses. The video tuition is designed by industry-leading experts with the best knowledge around.
What You’ll Learn in the Excel 2019 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 formatting cells and numbers
- Creating charts and graphs
- Sorting and Filtering
- Introduction to PivotTables
- Logical and lookup formulas – the basics
- 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
Microsoft Word 2019 (1 Course):
Companies and businesses all around the world use Word, and it is their go-to for document writing and word processing. It is one of the most popular tools that businesses and individuals use!
Despite all of this, Microsoft Word training often takes a back seat and isn’t focused on!
Microsoft Word needs to be used the right way, and then it can help you produce much more impactful and effective reports and documents and save you hours of time!
Studies show that you are most likely (without any training) using less than 20% of the functionally that Word offers! If you want to unlock that 80%, then it can have a massive impact on your work and life!
The in-depth Word 2019 course included in this Course Bundle teaches you the most relevant and important features that you need to know, and lets you put your newfound skills into practise!
The video tuition is designed by industry-leading experts with the best knowledge around.
With this Microsoft Word 2019 – Complete Training course, you will learn:
- How to get started with Word 2019
- Word 2019 basics including navigation, editing and saving
- Character formatting in Word including Format Painter and AutoCorrect
- How to properly work with bullets and numbering in Microsoft Word
- All about formatting paragraphs and managing lists
- Working with Tables in Word including formatting, converting data and formulas
- Page appearance including page-breaks, watermarks and styles
- All about Sectioning a document
- Inserting graphics, pictures, shapes, icons and 3D models (new for 2019)
- How to work with envelopes and labels
- All about mail-merge and operating Word at scale
- How to create an Index or Contents page
- Reviewing and Printing in Word and Page Setup
- Protecting a Word document and basic macros in Word
- Course Format
Sign up now!
What’s Included?
Unlimited 12 months access
Access anywhere, any time
Fast effective training, written and designed by industry experts
Track your progress with our Learning Management System
Unlimited support
Save money, time and travel costs
Learn at your own pace and leisure
Easier to retain knowledge and revise topics than traditional methods
Exam preparation quizzes, tests and mock exams to ensure that you are 100% ready
£239.00Add to basket
