AED 95
AED 495
Duration: Upto 15 Hours
Location: United Kingdom
Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.
Learn for less with 1Training discount courses online! You’ll love 1Training’s excellent quality, competitive prices, and first class learner support. With this excellent discount course you can expect professional qualification, which will enable you to enhance your CV in no time, and for less!
What skills am I going to get from this course?
✓ By enrolling to this course, you’ll learn how to manage cell contents in a worksheet.
✓ In this course, you’ll learn how to create financial reports.
✓ Having this course, you’ll learn accounting formulas, functions & specialized functions.
✓ In this course, you’ll learn cell attributes & cell formatting.
✓ This course will gain your knowledge of printing excel sheets.
✓ Logging in to this course, you’ll learn how to insert & modify graphic objects.
✓ On completion of this, course you’ll learn conditional formatting and data validations.
✓ At the end of this course, you’ll learn how to export, import & integrate data with other sources.
Course Duration:
Learners will have 365 days access to their chosen course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.
MICROSOFT EXCEL 2016 - BEGINNER
✓ Getting Started with Microsoft Excel
✓ Data Entering
✓ Creating Formulas and Functions
✓ Formatting
✓ Worksheet Views, Multiple Worksheets and Workbooks
✓ IF, VLOOKUP, and Power Functions, Security & Sharing
✓ Data Management, Data Analysis Tools
✓ PivotTables & Macros
✓ Exercise Files: Microsoft Excel 2016
MICROSOFT EXCEL 2016 - ADVANCE FORMULAS & FUNCTIONS
✓ Introduction to Excel 2016 Advance Formula and Functions
✓ Values and Formulas
✓ Operations in Formulas
✓ IF, AND, OR and NOT Functions
✓ VLOOKUP and HLOOKUP
✓ Tabulating Data and Multiple Criteria
✓ Median, Mode and Ranking Data
✓ Date, Time and Functions
✓ Array Formulas and Frequency Functions
✓ OFFSET and INDIRECT Function
✓ Different TEXT & Information Functions
MICROSOFT EXCEL 2016 - ADVANCE FORMATING AND TECHNIQUES
✓ Introduction to Excel Advance Formatting & Techniques
✓ Adjust Fonts, Font Sizes & Font Colours
✓ Adjust Cells and Tools
✓ Work with Formulas & Tables
✓ Adjust Row, Columns and Sheets
✓ Different Formatting Styles and Set up Data for Outlines
✓ Formatting Picture Styles
✓ Formatting Techniques – Restore Missing Data in a Column
How will I be assessed?
At the end of the course learners will take an online multiple-choice question assessment test. This online multiple-choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Upon successful completion of this course, all learners will be awarded a FREE e-certificate (PDF format), and can also pay only £19 to receive a printed version of the certificate if they wish.
What Certification am I going to receive?
Those who successfully pass this course will be awarded a Microsoft Excel 2016 – Advanced Level Certificate. Anyone eligible for certification will receive a FREE e-certificate with NO additional cost.
Write your own review
-
REVIEW_REVIEWERNAME REVIEW_DELETE
-
(REVIEW_RATING) REVIEW_REVIEWEDDURATION
REVIEW_REVIEWCOMMENT
COURSE DOCUMENT
Video Gallery

-
Contact Number:
-
Email:
-
Web Address:
Enquiry Form
RELATED COURSE
Choose from 5000+ available courses with new additions published every month
Financial Data Using Excel
Rating : 4.0
International Training Institute
Duration : Upto 15 Hours
Location : On site
AED 1,800
Financial Data Using Excel
Rating : 4.0
International Training Institute
Duration : Upto 15 Hours
Location : On site

Advanced Excel with Financial Modeling
Rating : 4.0
Zabeel International Institute of Management & Technology
Duration : Upto 16 Hours
Location : On site
AED 2,000
Advanced Excel with Financial Modeling
Rating : 4.0
Zabeel International Institute of Management & Technology
Duration : Upto 16 Hours
Location : On site

AED
145
745
Microsoft Excel 2016 Advanced
Rating : 4.0
STUDY365
Duration : Upto 5 Hours
Location : Self Paced

AED
120
745
Excel For Accountant – Level 2
Rating : 4.0
STUDY365
Duration : Upto 18 Hours
Location : Self Paced

AED
120
995
Microsoft Office Excel 2013 - Beginner
Rating : 4.0
STUDY365
Duration : Upto 4 Hours
Location : Self Paced

Microsoft Office Excel 2013 – Intermediate
Rating : 4.0
Duration : Upto 4 Hours
Location : Self Paced
AED
120
995
Microsoft Office Excel 2013 – Intermediate
Rating : 4.0
STUDY365
Duration : Upto 4 Hours
Location : Self Paced

AED
120
745
Excel for Accountant – Level 1
Rating : 4.0
STUDY365
Duration : Upto 14 Hours
Location : Self Paced

AED
145
995
Excel for Accountant – Level 3
Rating : 4.0
STUDY365
Duration : Upto 18 Hours
Location : Self Paced

AED
120
1,495
Microsoft Office Excel 2013
Rating : 4.0
STUDY365
Duration : Upto 32 Hours
Location : Self Paced

AED
120
995
Microsoft Office Excel 2013 – Advanced
Rating : 4.0
STUDY365
Duration : Upto 6 Hours
Location : Self Paced
