0
  • LOGIN

  • No products in the cart.

Login

Forgot Password?

Course Curriculum

Course Curriculum

Introduction
Level 1 Welcome 00:02:00
Start Here- All TheBasic
Opening Excel, And Creating A Shortcut 00:04:00
The Anatomy Of A Workbook 00:15:00
A Quick Review Of What’s Where 00:06:00
Always Do This First! – Save Your New Workbook 00:02:00
Let’s Enter Some Data 00:02:00
Editing Data 00:02:00
Ooops I Made A Mistake – Undo and Redo 00:01:00
Changing Appearance Of Text With Formatting – Fonts 00:09:00
A Quick Word On Formatting 00:01:00
Formatting Text – Alignment 00:03:00
Saving Time With AutoFilling Sequences 00:05:00
NEW! – POWER USER – Adding Your Own Lists To Autofill 00:04:00
Saving Time with Format Painter 00:03:00
Changing The Column Width 00:04:00
Tidy Large Titles With Merge And Centre 00:03:00
A Couple Of Shortcuts For Entering Data 00:04:00
Doing The (Simple) Math
Sums – The Old Fashioned Way! 00:03:00
Sums – Using Autosum 00:06:00
Copying Formulas 00:03:00
SUMming Horizontally 00:03:00
Basic Formulas – Subtraction 00:02:00
Basic Formulas – Multiplication 00:02:00
Basic Formulas – Division 00:01:00
Average Function 00:03:00
The Order Of Mathematical Operation 00:07:00
POWER USER – Evaluate Formula 00:05:00
Rearranging Things
Inserting New Columns And Rows 00:06:00
Moving Existing Columns And Rows 00:02:00
Cutting, Copying, Inserting And Deleting 00:06:00
Hiding Columns And Rows 00:03:00
Formulas: Learning The Clever Stuff
ROUNDing Functions 00:06:00
Formatting Numbers 00:02:00
A Primer In Building Complex Formulas 00:03:00
Buliding a Compex Formula 00:04:00
A Few more Essentials
Sorting 00:04:00
Wrapping Text And Soft Enter 00:04:00
Adding A New Worksheet 00:01:00
Creating A Simple Chart 00:04:00
Adding Borders 00:03:00
Customizing the Quick Access Toolbar 00:02:00
Simple Printing 00:04:00
Freezing For An Easier View 00:04:00
Getting Help 00:02:00
Filters 00:06:00
Highlighting Cells 00:02:00
Closing 00:01:00
Bonus Section: Absolute and Relative Cell References
$A1 Style – Absolute Relative 00:02:00
$A$1 Style – Absolute Absolute 00:03:00
$A1 Style – Absolute Relative 00:02:00
A$1 Style – Relative Absolute 00:02:00
Additional Resources
Resources : Microsoft Excel Basics 00:00:00

Microsoft Excel Basics

4.9( 7 REVIEWS )
550 STUDENTS
$ 249.00
TAKE THIS COURSE
Microsoft Excel Basics

Description

Microsoft Excel Basics Course is designed to provide learners with the knowledge and skills necessary to manage and apply the MS Excel tools at Basic Level. Microsoft Excel is a basic tool to perform arithmetic operations quickly and easily. It also allows the presentation of data graphically.

  • Learning outcome
  • Practical knowledge needed to fast track your career.
  • Learn the basic concepts of spreadsheet design, formulas and functions.
  • Learn all the tips, tricks, shortcuts, functions and formulas.
  • Acquire essential skills in Microsoft Excel.
  • Effectively utilize Excel to perform mathematical calculations.

Requirements

  • Learners will need Microsoft Excel and regular access to a computer with an internet connection.
  • High-speed broadband access (LAN, Cable, or DSL) is highly recommended for the optimal learning experience.
  • This course is available to all learners, of all academic backgrounds.
  • Why should I take this course?
  • 3.5+ hours of high-quality e-learning content.
  • Course completion certificate.
  • To improve the level of knowledge in Microsoft Office software.
  • To learn, measure and validate the general computer software skills.
  • To improve your productivity in the workplace.

Testimonial

Hear what our happy students want to say
The modules are easy to understand and there is help available if required. Besides great collection of exciting topics which make you come back for more.
It was a pleasure to do a course in SkillUp. The course is well organized and I could study at my own pace.
Super varied course content. From Healthcare and fitness to Therapeutic courses. What I particularly like are the course modules and the way they are arranged gradually. With my nutritional background, I have come to know and love completely different perspectives.
Recommendable! A unique experience, the courses have every detail covered. Enjoyed the course through and through.
The price is reasonable, and you know upfront of your costs. I would recommend Skill Up to learners who want to excel their skills or looking for self-development.
The modules are easy to understand and there is help available if required. Besides great collection of exciting topics which make you come back for more.
Previous
Next

Related Courses

Setup Menus in Admin Panel