Get Access To 2500+ Courses For A Year For Just £49. GET NOW
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.
Course Curriculum
| Welcome to Excel Basics - The Ultimate Beginner's course | |||
| Welcome to Excel Basics | 00:02:00 | ||
| Important Points | 00:02:00 | ||
| Excel Basics | |||
| 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 | ||
| Worksheets | |||
| 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 | ||
| Formatting | |||
| 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 | ||
| Formulas | |||
| 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 and Filtering Data | |||
| Sorting | 00:05:00 | ||
| Filtering | 00:05:00 | ||
| Tables | 00:09:00 | ||
| Charts | |||
| Inserting Charts in Excel 2010 | 00:04:00 | ||
| Adding Charts in Excel 2013 | 00:05:00 | ||
| Sparklines | 00:04:00 | ||
| Printing | |||
| Setting and Clearing a Print Area | 00:04:00 | ||
| Page Breaks and Column Headers | 00:04:00 | ||
| Assessment | |||
Course Reviews
No Reviews found for this course.
Related Courses
- PRIVATE
- 1 year
- Level 2 - Certificate
- Course Certificate
- Number of Units43
- Number of Quizzes0
- 3 hours, 35 minutes
Instructors
