Booking options
£11.99
Course Images
Excel 2019 Intermediate
By Course Gate
(1)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
4 hours 39 minutes
All levels
Description
The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience.
Who is this course for?
Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality.
Requirements
Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc.
CPD Certificate from Course Gate
At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.
Career path
This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.
Course Curriculum
Intro | |||
Introduction | 00:01:00 | ||
Section 01 | |||
Linking Worksheets and Workbooks | 00:07:00 | ||
Linking Worksheets with 3D References | 00:05:00 | ||
Understanding the Consolidate Feature | 00:06:00 | ||
Section 02 | |||
What are Range Names | 00:06:00 | ||
Creating Range Names Using the Name Box and Define Name | 00:06:00 | ||
Creating Range Names Using Create from Selection | 00:03:00 | ||
Section 03 | |||
Understanding the Differences Between Sorting and Filtering | 00:03:00 | ||
Sorting Lists | 00:07:00 | ||
Filtering Lists | 00:06:00 | ||
Creating Subtotals | 00:05:00 | ||
Section 04 | |||
Creating Tables and Understanding the Benefits | 00:06:00 | ||
Understanding the Elements of a Table | 00:05:00 | ||
Formatting a Table | 00:05:00 | ||
Sorting and Filtering Tables | 00:04:00 | ||
Filtering with Slicers | 00:07:00 | ||
Calculating with Tables | 00:06:00 | ||
Removing Erroneous Table Data | 00:05:00 | ||
Exporting, Refreshing, and Converting Tables | 00:05:00 | ||
Section 05 | |||
What is Conditional Formatting | 00:03:00 | ||
Conditional Formatting-HIghlight Cells and Top Bottom Rules | 00:06:00 | ||
Conditional Formatting-Data Bars, Icon Sets, and Color Scales | 00:06:00 | ||
Using Custom Fonts and Colors | 00:03:00 | ||
Using Custom Conditional Formatting | 00:05:00 | ||
Modyfing or Removing Conditional Formatting | 00:04:00 | ||
Section 06 | |||
What are Charts | 00:06:00 | ||
Forecasting with Trendlines | 00:05:00 | ||
Creating a Chart Template | 00:04:00 | ||
Displaying Trends with Sparklines | 00:08:00 | ||
Creating Charts | 00:05:00 | ||
Understanding Chart Elements | 00:05:00 | ||
Modifying Chart Elements | 00:05:00 | ||
Changing and Moving Charts | 00:03:00 | ||
Filtering a Chart | 00:04:00 | ||
Formatting Charts | 00:13:00 | ||
Adjusting Numbering | 00:06:00 | ||
Creating Dual Axis Charts | 00:05:00 | ||
Section 07 | |||
What is a PivotTable | 00:05:00 | ||
Creating a PivotTable | 00:07:00 | ||
Working with the PivotTable Fields Pane | 00:10:00 | ||
Basic Data Organization and Analysis with PivotTables | 00:08:00 | ||
Formatting PivotTables | 00:05:00 | ||
Creating a PivotChart | 00:04:00 | ||
Modifying and Formatting a PivotChart | 00:04:00 | ||
Using Slicers and Timeline Slicers | 00:08:00 | ||
Section 08 | |||
Using the PivotTable and PivotChart Wizard | 00:03:00 | ||
Adding a Calculated Field | 00:04:00 | ||
Adding a Calculated Item | 00:04:00 | ||
Applying Conditional Formatting to a PivotTable | 00:06:00 | ||
Creating Filter Pages for a PivotTable | 00:04:00 | ||
Enabling the PowerPivot Add-in | 00:11:00 | ||
Recap | |||
Recap | 00:02:00 | ||
Certificate and Transcript | |||
Order Your Certificates or Transcripts | 00:00:00 |
About The Provider
Course Gate
London
(1)Welcome to Course Gate, your gateway to a world of knowledge and oppo...
Reviews
There are no reviews for Excel 2019 Intermediate yet.Why not be the first one to review this course?