Courses
Web Development Software Design Programming Languages Mobile Development IT Infrastructure IT Basics Game Development Engineering Electrical Engineering Data Science & AI Cybersecurity & Ethical Hacking Cloud Computing & Networking Blockchain & Cryptocurrency Zen Philosophy Success Habits Resilience Productivity & Time Management
Services
Online courses Become a certified teacher Sagson Home Academy Imperial English Test
Our Story
Who Are We Licenses and Accreditation Our Team
About us

Excel Simplified - 101 Tips

by Super Admin

$ 10

Business & Entrepreneurship Office Tools

Excel Simplified - 101 Tips

Best seller
0
Created By Super Admin

$ 10

50% off $ 20

Estimated Time

4 hours 25 mins

On demand video

Enrolled By

0

Students & professionals

Total

102

Resources

Full

Lifetime

Access

About this Professional course

Course Description
Boost your Excel skills with Sagson Educational Portal’s 101 Tips for Excel Course. Perfect for all levels, this instructor-led course offers over 100 video lessons covering essentials like data entry, formatting, chart creation, and pivot tables. Gain practical skills to organize, analyze, and interpret data—abilities highly valued across industries. Study anytime, anywhere with Sagson Educational Portal’s user-friendly platform, designed for a self-paced learning experience. Invest in your professional growth with this comprehensive Excel course and navigate data analysis confidently to elevate your career.

Key Course Features

Thoroughly Researched Content: Each course is designed with meticulously researched materials to ensure comprehensive learning.
Engaging Audiovisual Modules: Enjoy bite-sized modules that enhance understanding and retention through dynamic audiovisual content.
Expert Access: Connect with leading industry professionals and academic experts for guidance and insights.
Flexible Learning Duration: Gain full access to the course for 365 days, with round-the-clock customer support available to assist you.
Instant Certification: Receive a digital certificate immediately upon course completion, validating your new skills.

Assessments & Certification

To earn certification from the Sagson Educational Portal, learners might be required to complete and pass certain assessments that test their understanding of the course material. These assessments are crucial in determining their eligibility for certification.

Order Your Certificate

Complete the course and claim your certificate.

Course Requirements

A Stable Internet Connection

To access video lessons, downloadable materials, and online assessments without interruption.

A Laptop, Desktop, or Mobile Device

Courses are accessible via any modern device with a web browser. For optimal experience, a larger screen is recommended.

Basic Digital Literacy

Familiarity with using a web browser, email, and basic navigation is helpful to complete the course smoothly.

Up-to-Date Web Browser

Ensure your device is running the latest version of Google Chrome, Firefox, Safari, or Microsoft Edge for full compatibility.

A Willingness to Learn

Self-motivation and commitment to personal development are key to completing the course successfully.

What You Will Learn

Enhanced Knowledge and Skills

Gain practical and theoretical understanding relevant to the subject area, improving both personal and professional competencies.


Certified Achievement

Receive Accredited Certificate upon successful completion, verifying your professional development.


Career and Workplace Readiness

Apply new skills confidently in real-world scenarios, boosting your employability and performance at work.


Self-Paced Learning Completion

Learn at your own convenience with full control over your pace, helping you achieve your goals more effectively.


Increased Confidence and Capability

Develop greater confidence in your abilities, enabling you to take on new challenges and responsibilities with ease.


Course content

INTRODUCTION TO THE COURSE AND YOUR TUTOR

Intro to the Course and Your Tutor

3 mins to complete
1 lessons

DATA

Enter Number and Fractions

Entering Dates and Times

Name Cells and Ranges

Validate Data Ebtry Using a Pick List

Extend a Series of Dates with Autofill

Add a Symbol or Special Character

Compare Multiple Spreadsheets Using Freeze Panels

Hide Rows

Keyboard

Speak Cells

Find and Replace data

1 hour 12 mins to complete
11 lessons

FORMULAS AND FUNCTIONS

Add Values

Function Wizard

Formulas with Comments

OneNote

Define a Constant

Apply Names in Functions

Figure Out the Best Loan Terms

Internal Rate of Return

Nth Largest Value

Large, Dmall, Max, Min

Conditional Formula

Conditional Formula with Names

Count if

Conditional sum

Inner Calculator

Square Roots

Calculate the Duration Between Two Times

Calculate Days Between Two Dates

1 hour 21 mins to complete
18 lessons

COPYING DATA, FORMATS ETC.

Copy a Range

Transpose a Row into a Column

Copy Styles to Another Workbook

Chart Formatting

Paste Special and Copying Worksheets

Track Changes While Editing

36 mins to complete
6 lessons

LISTS

Enter List Data Using a Form

Searching Through a Data List

Import a Word List into Excel

Sort a List

Filter a List

Sort by Multiple Criteria

Find Averages in Sorted Group

Filter by Multiple Criteria

Remove Duplicate Records from a List

Count Filtered Records

Filter by Multiple Criteria in the Same Column

Chart a Filtered List

Look up Information in a List

1 hour 0 mins to complete
13 lessons

DATA PATTERNS

Hide Rows and Columns in a PivotTable

AutoFormat a PivotTable

Create a PivotChart

Turning on the Data Analysis Function so that Statistical info can be Run

Describe Data with Statistics

Discover associations within your Data

Product Numbers

What-if Analysis

Goal Seek

Create a Pivot Table

Modify a PivotTable and Layout

Find the Average of a Field

Create a Calculated Field

Calculated Fields and Charts

52 mins to complete
14 lessons

CREATING CHARTS

Create a Chart

Modify Chart Details

Change the Chart Type

Add a Trendline to a Chart

Remove Chart Data

Add Chart Data

Missing Chart Data

Error Bars

Pull a Slice from a Pie Chart

Label Slices of a Pie Chart

Histogram

Paste a Chart into Word

Amending a Chart in Word

Paste-link a Chart into Word

1 hour 4 mins to complete
14 lessons

WORKSHEETS

Format Numbers as Percentages

Format currencies in Currency and Accounting Formats

Format Column Headings

Format Quickly with Format Painter

Insert a Background Image into your Worksheet

Create a Transparent Image

24 mins to complete
6 lessons

SAVING AND PRINITING WORKSHEETS

Save a Workbooks as a Template

Save a Workbook as an XML Spreadsheet

Print Multiple Cell Ranges on One Page

Page Set Up - Header Footer Margins - 1 pg printing

Print Multiple Areas of a Workbook

Print Multiple Worksheets of a Workbook

Repeat Headings of a Row of Column

Print Functions to Show Calculations and Comments

48 mins to complete
8 lessons

EXTENDING EXCEL

Hyperlink a Worksheet to another Office Document

Embed a Chart within PowerPoint

Publish an Interactive Workbook

Importing Data from a Website or Access Database

Import a Worksheet into Access

Use Excel Data to Create labels in Word

37 mins to complete
6 lessons

CUSTOMIZING EXCEL

Launch a Specific Workbook when Excel Opens

Save Time by Creating a Custom View

Create a Custom Number Format

Changing Text to Columns

Create a Macro to Format Numbers

28 mins to complete
5 lessons

Top Reviews

No reviews yet

Frequently Asked Questions

How do I purchase a course?

To purchase your course online just follow the link. Online purchases can either be paid for immediately by credit/debit card, you can nominate somebody else to pay on your behalf, or an invoice can be requested.

How do I access the courses I have paid for?

On completing the online purchase process you will have immediate access to your course. 

How long do I have access to my purchased course?

You have access to the courses you have purchased indefinitely. Once the payment is made, the confirmation notice will be sent to the client via email within 24 hours of receipt of payment.

Do I have to complete a course in one go?

No, you can visit it at any time, wherever you are. Each course is made up of a number of individual modules which enables you to complete it in your own time and at times convenient to you. If you wish to return to the course at the point, you last left it at, please ensure you use the same device to access the course and do not clear your cache in between visits.

I have purchased the course online but cannot access the course?

Please contact the QH social media or by calling +97150209580.

Can I download or print a copy of the course material?

The software that we use for our eLearning does not have a download or print function, so there is no easy way to obtain this. For this reason, once you have purchased individual eLearning courses with us you have indefinite access to them so that you may return to the information and review it at any time.  

When I will receive the refund payment?

Refunds will be made onto the original mode of payment and will be processed within 10 to 45 days depending on the issuing bank of the credit card used.

What are the criteria in refund the payment for courses?

Any learner can withdraw from the programme and receive a refund based on the following Criteria:1- Online courses 24 hours Before the course starts: No refund.2- more than 24 hours before the course starts: Full refund.3- Products Full refunds within 14 days of purchase.Services As per terms and conditions in the service delivery contract.4. Payment confirmation

Can I cancel any program\course I sign in?

Customer can cancel their order/requested services within 24 hours; refunds will be made back to the payment solution used initially by the customer. Please allow for up to 45 days for the refund transfer to be completed.

If I fail a course, can I retake it?

If you did not pass the course with the grade required to earn the certificate, you can enroll in a future session.

Options for Purchasing a Program.?

There are 2 options:Option 1: purchase the program bundle:One-click bundle purchase to add all the program courses at once.Option 2: Upgrade Course by CourseYou can also purchase the program courses one by one.  

What types of certificates does SEP offers?

SEP currently offers two types of certificates:- Certificates for single courses- Program certificates for programs (series of courses)

Does SEP offer free certificates?

SEP courses do not award free certificates. Certificates are awarded only to passing students registered in the paid certificate track. The enrollment fee for this track varies by course.

Can I get a paper copy of my certificate?

SEP cannot send individual printed copies of certificates. However, you can save the certificate by downloading it as a PDF file.

I am not interested in a certificate. Can I still enroll in a course?

Yes. With the exception of professional education courses.

How do I download my certificate?

You can save your certificate on your computer by downloading it as a PDF using either the Chrome or Safari browser. 

How can I add my certificate to my LinkedIn profile?

To add your SEP certificate directly to your LinkedIn profileLog in to your LinkedIn account, then go to your profile.On the right, in the Add profile section dropdown, choose Background and then select the drop-down triangle next to Licenses & Certifications.In Name, enter the name of the course or program.In Issuing Organization, enter "SEP".(Optional) In Issue Date, enter the time period during which you earned the certification.(Optional) Select the checkbox This certification does not expire.You can leave the Credential ID field empty.In Certification URL, enter the URL for your certificate.

More questions? Visit the Learner Help Center.

Shopping Cart

Loading...