Microsoft Excel 2013 – Basic to Advanced Level
Course
Online
Become an expert at using Excel!
-
Type
Intensive course
-
Methodology
Online
-
Class hours
60h
-
Duration
Flexible
Immerse yourself in the world of Excel with this Microsoft Excel 2013 – Basic to Advanced Level Course, offered by 1 Training, that Emagister.co.uk has added to its educational catalogue.
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.
By enrolling to this course, you’ll learn how to manage cell contents in a worksheet, to create financial reports, to insert & modify graphic objects, to export, import & integrate data with other sources, among other functions.
Besides, every 1 Training course offers you the opportunity to study 24/7 wherever you are in the world. These intensive online trainings are open to anyone with an interest in the topic and give you access to world-class learning led.
Don't miss this chance and join this course now. Contact 1 Training through Emagister.co.uk. You will receive all the information needed to take a step further in your career!
Facilities
Location
Start date
Start date
About 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."
"Job hunters & School leavers
College or University students, graduates & Teachers
Personal assistant & Receptionist
Assistant for company director
New or Temporary staff
Office Administrators & Office managers
Office clerk, Marketing assistant & Administration Assistant
Secretary or Executive
Account assistance, Bookkeeper & Accountant
IT professionals & Businessman"
You’ll need a computer or tab with an internet connection and Microsoft Office software installed in it. Also, it’s better to have a notepad and a pen with you.
If you pass the exam successfully then you will be awarded a Certificate in Microsoft Excel 2013 Basic to Advanced Training.
On receiving your request, one of our staff members will call you or send you a message by explaining everything about the course you are requesting information, including how you can sign up, payment options, exam, and enrollment requirements etc.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Excel
- Access
- Microsoft Excel
- Financial
- Export
- Import
- Financial Training
- Microsoft excel training
- MS Excel
- Bookkeeper
- Worksheet
- Financial Performance
- Accountant
- Business Profit or Loss
- Accounting Formulas
- Excel Sheets
- Modify Graphic
- Account Assistance
Teachers and trainers (1)
David Nicol
Course Administrator
Course programme
COURSE CURRICULUM
MICROSOFT EXCEL 2013 - BEGINNER
- Identify the Elements of the Excel Interface
- Create a Basic Worksheet & Use the Help System
- Create Formulas in a Worksheet
- Insert Functions in a Worksheet
- Insert, Manipulate, and Delete Cells, Columns, & Rows
- Search, Replace Data & Spell Check a Worksheet
- Modify Fonts, Add Borders and Color to Cells
- Align Cell Contents & Apply Cell Styles
- Printing Workbook Contents
- Format and Manage Worksheet
- Manage the View of Worksheets and Workbooks
- Customize General and Language Options
- Customize Formula
- Customize Proofing and Save Options
- Customizing Other of Excel Functions
MICROSOFT EXCEL 2013 - INTERMEDIATE
- Apply Range Names
- Use Specialized Functions
- Analyzing Data with Logical and Lookup Functions
- Insert and Modify Graphic Objects
- Layer and Group Graphic Objects
- Customizing Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
MICROSOFT EXCEL 2013 - ADVANCED
- Apply Conditional Formatting
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
- Create Sparklines and Scenarios
- Perform a Statistical Analysis with the Analysis ToolPak
- Create Interactive Data with Power View
- Consolidate Data
- Link Cells in Different Workbooks
- erge Workbooks
- Export and Import Excel Data
- Integrate Excel Data with the Web
- Create a Web Query
What skills will I gain?
- 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:
You will have 2 Months (60 days) access to your online study platform from the date you purchased (enrolled) the 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.
How will I be assessed?
- At the end of the course you will have one Quiz test that will be marked automatically and you will be received an instant grade.
- You will have a mock exam that you can prepare yourself for the final exam. After successfully passed your exam, you only need to pay £30 for your certificate
Additional information
Completing this training course will show any potential employer that you are comfortable and confident with using key Microsoft Excel applications. This Qualification is helpful for any Office job, such as PA, Secretary, and Administrator or any other role in the office environment. Being able to demonstrate you have a high level of Microsoft Office skills will help you stand out to employers.
Microsoft Excel 2013 – Basic to Advanced Level