Microsoft Excel Basics
495 Students
GET ACCESS TO THIS COURSE ALONG WITH 3000+ ONLINE COURSES FOR A YEAR FOR JUST £49. GET NOW
Save 0.00 % - Offer ENDS SOON
Access All Courses for Only £49
14-Day Money-Back Guarantee
-
1 Year
Access -
Level 2 - Certificate
Skill Level -
3 hours, 35 minutes
Duration
Description
Learn to master the world’s leading spreadsheet program with the Microsoft Excel Basics course.
Microsoft Excel allows you to create, view, edit, and share your files with others quickly and easily. In the course, you will know the basic ideas of spreadsheet design, formulas and functions that will allow you to develop fully working models. You will learn to create simple formulas and functions in an Excel worksheet. The course shows you how to filter, sort and find the data by using the world’s most popular spreadsheet software. Next, the course shows you how to create graphs and charts in the spreadsheet program. Finally, you will learn to format the page layout and how to print your work.
Shortly, the course will help[ you to use the software like a pro.
Assessment:
This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.
Certification:
After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for?
Microsoft Excel Basics is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
Requirements
Our Microsoft Excel Basics is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
-
Welcome to Excel Basics 00:02:00 -
Important Points 00:02:00
-
The Excel Interface 00:04:00
-
Creating a New Workbook 00:04:00
-
Pointer Shapes 00:03:00
-
Opening and Closing Workbooks 00:04:00
-
Moving around with Keyboard and Mouse 00:05:00
-
Opening Multiple Workbooks 00:06:00
-
Renaming Sheets 00:03:00
-
Copying and Moving Sheets 00:05:00
-
Inserting and Deleting Sheets 00:06:00
-
Changing Sheet Tab Colours 00:02:00
-
Copying and Moving Cells 00:06:00
-
Copying and Moving by Dragging 00:04:00
-
Using the Fill Handle 00:04:00
-
Inserting Rows and Columns 00:04:00
-
Deleting Rows and Columns 00:06:00
-
Hiding Rows and Columns 00:04:00
-
Adjusting Column Widths 00:06:00
-
Adjusting Row Height 00:05:00
-
Copying by Using the Fill Handle 00:06:00
-
Copying Using the Shortcut Menus 00:10:00
-
Selection Methods 00:07:00
-
Cell Alignment 00:05:00
-
The Format Painter 00:04:00
-
Simple Formatting 00:07:00
-
Fonts, Font Size and Font Colour 00:07:00
-
Cell Borders 00:03:00
-
Cell Patterns 00:04:00
-
Introduction to Formulas and Functions 00:08:00
-
Invoice Walkthrough 00:04:00
-
Absolute Cell References 00:07:00
-
Functions 00:07:00
-
Named Ranges 00:05:00
-
Outlining 00:06:00
-
Sorting 00:05:00
-
Filtering 00:05:00
-
Tables 00:09:00
-
Inserting Charts in Excel 2010 00:04:00
-
Adding Charts in Excel 2013 00:05:00
-
Sparklines 00:04:00
-
Setting and Clearing a Print Area 00:04:00
-
Page Breaks and Column Headers 00:04:00
Frequently Asked Questions
Most courses do not require prior qualifications unless stated otherwise on the course page. Please check the individual course description for any specific entry requirements.
Learners must usually be 16 years or older to enrol. However, learners under 16 may join with parental or guardian consent.
Yes, if you do not pass the exam on your first attempt, you may retake the exam up to 3 times, depending on the course terms.
You will normally have 1 year of access to your course from the date of enrolment. Course duration may vary, and the estimated study time is mentioned on the relevant course page.
Yes, our courses are available worldwide. You can enrol and study from any country as long as you have an internet-connected device.
