• No products in the basket.
5

1

190

Overview Microsoft Excel beginner to advanced course is designed to take you from a beginner to an advanced level Excel user, so you can finally …

Original price was: £194.00.Current price is: £19.99.

Overview

Microsoft Excel beginner to advanced course is designed to take you from a beginner to an advanced level Excel user, so you can finally impress your colleagues and friends with your spreadsheet skills. Are you tired of feeling like a Microsoft Excel newbie? Want to upgrade your spreadsheet game from "meh" to "Wow!"? Well, look no further! Throughout the course, you'll learn how to create and edit spreadsheets, work with data, create charts and graphs, and use advanced functions and formulas.

You'll also learn how to use Excel's built-in tools for data analysis, such as formatting and sorting, so you can quickly find the information you need. And all that without the need to call your nerdy cousin for help! One of the key features of this e-course is that it is designed to be hands-on, with plenty of exercises and real-world examples to help you practise and apply what you've learned. Whether you're a student, a professional, or just someone who wants to improve their Excel skills, this e-course has something for you. So, are you ready to take your Excel skills from zero to hero? Enrol in this e-course now and start mastering the powerful features of Excel today!

What Will You Learn?

  • How to create and edit spreadsheets
  • Techniques for working with data
  • Creating charts and graphs
  • Using advanced functions and formulas
  • Data analysis tools such as formatting and sorting

Who Should Take The Microsoft Excel Beginner to Advanced Course?

  • Professionals who want to improve their
  • Excel skills
  • Students who want to learn Excel from beginner level to advanced level
  • People who have basic understanding of computer usage and internet navigation
  • Anyone who is looking to learn advanced features of Excel
  • Suitable for all levels of users, from complete beginners to experienced
  • Excel users
  • People who have a sense of humour and are willing to have fun while learning

Requirements

To enrol in this e-learning course, students will need a computer with internet access and a recent version of Microsoft Excel installed. No prior experience with Excel is required, making it accessible for all levels of learners. A sense of humour is recommended.

Course Currilcum

    • Work 00:05:00
    • Alignment in Excel 00:07:00
    • Worksheet and Input data 00:02:00
    • Introduction to Formula Sum 00:07:00
    • Duplicating data & formula 00:08:00
    • More on duplicating data & formula 00:02:00
    • Moving and copying data in excel 00:03:00
    • Moving around and activating cells using keyboard 00:05:00
    • Practice 00:00:00
    • Making a simple salary sheet in Microsoft Excel 00:15:00
    • Water bill calculation area wide with chart 00:12:00
    • Making a marksheet 00:08:00
    • QAT (quick access toolbar) 00:03:00
    • Error Meaasges in Microsoft Excel 00:04:00
    • Freez panes, Max & Min value, Find in Excel 00:05:00
    • Copying Excel sheets in Excel 00:04:00
    • How to create custom Tab in Excel 00:04:00
    • Textbox & Shape in Excel 00:07:00
    • How to remove grid lines in Excel 00:00:28
    • Merging cells & AutoSum 00:04:00
    • Count & Round function in Excel 00:05:00
    • Using find and replace 00:02:00
    • Named ranges in Excel 00:09:00
    • Save as types in Excel 00:02:00
    • Introduction to if function 00:04:00
    • Conditional formatting 00:05:00
    • Using conditional formatting to trace a customer 00:06:00
    • Insert pictures and icons 00:04:00
    • Number formats in Excel 00:04:00
    • Print area in Excel 00:03:00
    • Custom sorting 00:05:00
    • Tables in Excel 00:07:00
    • Text to column 00:03:00
    • Flash fill 00:02:00
    • Data validation in Excel 00:10:00
    • Data validation part-2 00:01:00
    • Nested If 00:04:00
    • Count if in Excel 00:04:00
    • Charts in Excel 00:09:00
    • Composite chart and printing chart 00:06:00
    • Making a mental math practise sheet 00:07:00
    • Electricity bill calculation sheet 00:21:00
    • Order Certificate 00:05:00

Course Reviews

5

5
1 ratings
  • 5 stars1
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. 660e67d653b22 bpthumb Microsoft Excel Beginner to Advanced
    Great intro
    5

    A very helpful info to using spreadsheets for lots of different tasks.

Template Design © Course Line. All rights reserved.