- مدة الدورة التدريبية: 11 ساعة إبدأ الآن
- معتمدة من قبل: CPD GroupIAO
- الشهادة:
- طريقة تقديم الدورة: عبر عرض الفيديو
تفاصيل الدورة
OverviewMaster the use of the world’s most popular data analysis and office tool, with absolutely no previous experience or training needed.
This course will help you quickly become an expert in the use of Microsoft’s best-selling Excel, allowing you to be a valuable asset to any business or organization.
The Microsoft Excel Level 3 course will teach you how to manage finances, produce spreadsheets, and file invoices in no time. Our innovative training method will have you visualizing and presenting company data efficiently. Learn to impress your peers and managers with your intuitive use of Excel and make sure that your administration skills are faultless.
How will I get my certificate?
At the end of the course, there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.
Who is this course for?
There is no experience or previous qualifications required for enrolment on this Microsoft Excel Level 3. It is available to all students, of all academic backgrounds.
Career path
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring, etc.
COURSE CURRICULUM
Microsoft Excel 2019 New Features
- Introduction to Microsoft Excel 2019 New Features
- CONCAT
- IFS
- MAXIS
- MINI FS
- SWITCH
- TEXTJOIN
- Map Chart
- Funnel Chart
- Better Visuals
- Pivot Table Enhancements
- Power Pivot Updates
Performing Calculations
Modifying a Worksheet
Formatting a Worksheet
Printing Workbooks
Managing Workbooks
Working with Functions
Working with Lists
Analyzing Data
Visualizing Data with Charts
Using PivotTables and PivotCharts
Working with Multiple Worksheets and Workbooks
Using Lookup Functions and Formula Auditing
Sharing and Protecting Workbooks
Automating Workbook Functionality
Creating Sparklines and Mapping Data
Forecasting Data
Excel Templates
Resources
Assignment تحديث بتاريخ 10 January, 2024
المتطلبات
Our Microsoft Excel Level 3 is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or ;There is no time limit for completing this course, it can be studied in your own time at your own pace.