Microsoft Office Excel 2019
- Get trained as a professional in microsoft excel
- Excel for all level of learners – beginners to advance!
- Learn smart skill to enhance your career
- Professional training with certificate and more!
E-Learning Course:
Study at your own pace! 12 Month Access to learn at the comfort of your home – Anytime!! Anywhere!!!
Microsoft Office Excel 2019 Training
Gain comprehensive understanding of Microsoft excel in this three levels (Beginner, Intermediate & Advance) training bundle. This course is suitable for all level of users and will enable learner to understand the fundamentals of Microsoft Excel up to the advanced level.
Learner will be introduce to Microsoft Office Excel 2019, how to use office excel as a beginner or expert, how to format and modify excel sheets, how to perform calculation and using excel formula bars, SmartArt, Graphical Cell, Using Tables and Charts, Workbook and Worksheets, using PivotTables and Pivot Charts, data with charts, data validation, lookup functions, power pivot, data mapping and much more.
At the end of this course, learner should be well equipped as a professional excel user.
Studying this course from LPT via elearning route means you get quality, up to date training and contents, study materials, instructor led training, quizzes, test, plus the ability to study anywhere anytime, with 247 access to the learning portal for 12 months.
What's Included
During the course of your study, you will be tested via quizzes and mock exams where required. The course is delivered via interactive learning videos and study materials with 12 months access to study 247 anywhere anytime.
This course is a training video developed by industry experts with up to date information and the best learning outcome. It include module exercises, interactive courses plus:
Certificate of completion
247 course Access
365 Days Access
Reviews, Quiz & Mock Exam
24/7 Support
Interactive & Scenario based video learning
Compatibility on mobile, tablet, laptop and desktop
Course Introduction
Part 1
Getting Started with Microsoft Office Excel 2019
Navigate the Excel User Interface
Use Excel Commands
Performing Calculations
Modifying and Formatting Worksheet
Printing and Managing Workbook
Adding Borders and Colours to Worksheets
Basic Excel Customization
Part 2
Working with Lists and Functions
Analysing Data:
Create and Modify Tables
Intermediate and Advance Conditional Formatting Application
Visualizing Data with Charts
Creating Charts
Modifying and Formatting Charts
Use Advanced Chart Features
Using PivotTables and Pivot Charts
Create a PivotTable
Analyse Pivot Table Data
Present Data with Pivot Charts
Filter Data by Using Timelines and Slicers
Working with Graphical Objects
Insert and Modifying Graphical Objects
Using Array Formulas
Part 3
Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
Consolidate Data
Sharing and Protecting Workbooks
Collaborate on a Workbook
Protect Worksheets and Workbooks
Automating Workbook Functionality
Using Lookup Functions and Formula Auditing
Forecasting, Creating Sparklines and Mapping Data
Importing and Exporting Data
Internationalizing Workbooks
Working with Power Pivot
Advanced Customization Options
Working with Forms and Controls
Upon completing this training, learner be assessed by taking an online multiple choice questions with automatic grading.
FAQS
Will i get a certificate after completing this course?
Learner will receive a CPD Accredited Certificate in Microsoft office Excel 2019, upon course and exam completion.
What other methods of learning do you offer?
We offer this course as a Self-paced Elearning Course, Virtual Online Class, Blended Learning, Group Booking or In-house training. Contact us or search our website for other delivery type for this course title.
Rate & Review this course
We love feed backs! Kindly rate and review this course via the button below.
|
Submit your review
|
|
|
|
|
0 reviews
