• Post category:StudyBullet-17
  • Reading time:8 mins read

Excel Part 1: Foundation - Free Preview
Embark on your Excel journey: Start effortlessly, grasp the essentials, and build better worksheets.

What you will learn

By the end of this course, you will have the skills and knowledge to create and develop Excel worksheets and workbooks with confidence.

With this level of proficiency, you’ll be able to work effectively with and analyze critical data, thereby contributing to the success of your organization.

Discover Excel’s features and functions to manipulate, organize and interpret data, empowering you to make informed decisions and drive business outcomes.

Join us on this training journey to unlock your Excel potential and enhance your organization’s data-driven success.

Description

DESCRIPTION

Excel is an essential office tool offering powerful data visualization and analysis, yet many people only just manage to scratch the surface of it by using a mere 10% of its capabilities.

Join us, in this beginner-friendly video training course, on a transformative journey to harness the full power of Excel. You’ll learn to organize, analyze, update and present your data efficiently, empowering you to make well-informed decisions based on insightful analyses.

This training course lays the groundwork for your Excel proficiency, arming you with the essential knowledge and skills you’ll need to navigate the software with confidence. Once you’ve understood the core concepts and mastered the basics, you’ll gain the expertise to make Excel work for you.

THIS COURSE IS SUITABLE FOR YOU, IF

  • You are an Excel beginner looking to build a strong foundation.
  • You want to develop a solid understanding of Excel’s essential concepts and features.
  • You need to create, manage and analyze electronic spreadsheets effectively.
  • You are eager to enhance your data management capabilities in Excel.
  • You want to take your Excel skills to the next level and become more proficient in spreadsheet tasks.

Regardless of your starting point, this course is designed to meet your needs and help you excel in Excel. Join us today to unlock your full potential in this powerful spreadsheet software.

COURSE OBJECTIVES

By the end of this course, you will have the skills and knowledge to create and develop Excel worksheets and workbooks with confidence. With this level of proficiency, you’ll be able to work effectively with and analyze critical data, thereby contributing to the success of your organization. You’ll make use of Excel’s powerful features and functions to manipulate, organize and interpret data, empowering you to make informed decisions and drive business outcomes. Join us on this training journey to unlock your Excel potential and enhance your organization’s data-driven success.

COURSE PREREQUISITES

These prerequisites will enable you to follow this training with ease. To ensure your success in this course, we recommend that you have the following basic skills and knowledge:

  • Proficiency in Windows
    • End-user skills with any current version of Windows.
    • Ability to start programs, switch between programs and close programs.
    • Familiarity with locating saved files and accessing websites using a web browser.
  • Basic Microsoft 365 Knowledge:
    • Completion of the course ‘Microsoft 365 – Learn, Understand and Use Basic Functions and Concepts’ is beneficial.
    • Prior practical experience with Microsoft 365 is beneficial.
    • Essential skills include cloud file storage for convenient access across devices and knowledge of file sharing and co-authoring techniques.

METHOD


Get Instant Notification of New Courses on our Telegram channel.


In this training, your dedicated trainer will skillfully guide you through the various concepts and functions of Excel in an easy-to-understand, step-by-step way. The training provides clear explanations and demos that you can follow with confidence.

Working at your own pace throughout the course, you can pause the training videos to take breaks or review specific sections, meaning you’ll absorb information more effectively and can then apply it to your own Excel tasks. In addition to the comprehensive training videos, we also provide a range of support materials to enhance your learning experience. Helpful handouts with handy hints, practice exercises and interactive quizzes will all help to reinforce your knowledge and skills. These resources are designed to complement the training and help you to extract maximum benefit from the course.

So, join us today for a rewarding learning journey with our experienced trainer. You’ll receive expert guidance, engaging content and a wealth of supplementary resources to aid your Excel proficiency.

32 Training Videos including Subtitles (Run time: 3 hours 42 minutes) (Limited to 2 hrs in free preview)

In this Excel training, the trainer will guide you through the various features, providing clear explanations step-by-step. English subtitles are included to ensure easy comprehension. Get ready to excel in Excel with confidence!

5 Handouts (Download as PDF)

Handouts will be provided to either consolidate what you have learned or to give you a practical guide on putting it into practice.

17 Exercises

Enhance your self-guided Excel learning experience by engaging with our exercise files, gaining valuable insights and practical knowledge.

6 Quizzes

The quiz questions will consolidate what you have learned.

English
language

Content

00 Course Overview

How to learn most effectively

01 First Steps in Excel

First overview
The ribbon
Store workbooks on-premises and in the cloud
Enter data
AutoFill and Flash Fill
Quiz – 01 First Steps in Excel

02 Performing Calculations

Working with formulas
Frequently used functions
Absolute cell references
The error message ####
Quiz 02 – Performing Calculations

03 Formatting Spreadsheets

Editing cells
Formatting texts
Formatting numbers
Aligning cell content
Cell styles
Design
Conditional formatting
Quiz 03 – Formatting Spreadsheets

04 Modifying Spreadsheets

Find and replace
Spell check
Ensure Accessibility
Various tips
Templates
Quiz 04 – Modifying Spreadsheets

05 Printing Workbooks

Printing
Page layout
Header and footer
Quiz 05 – Printing Workbooks

06 Manage Workbooks

Manage Spreadsheets
Spreadsheet views
Properties of Workbooks
Excel Live
Search and help
Quiz 06 – Manage Workbooks

07 Practical application examples

Practical examples
Final remarks
Quiz 07 – Practical application examples