Digital Literacy – Computer Basic Course

About Course

Digital Literacy course is designed to teach you how to master basic computer operations, modern AI tools, and office productivity softwares. This course will also develop your understanding related to freelancing and digital safety.

Course Content

Module 1

Topic 1 | What is Digital Literacy?
07:49
Topic 2 | Introduction of the Instructor
03:13
Topic 3 | Course Orientation
03:49
Topic 5 | Safe Online Behavior
07:00
Topic 6 | Responding to Unsafe Online Behavior
05:48
Topic 7 | Understanding Digital Footprints
05:00
Topic 8 | Controlling Your Digital Reputation
06:22
Topic 9 | Technology Use Ethics
05:00
Topic 10 | Building Healthy Digital Habits
07:56
Topic 11 | Exploring Digital Devices
05:00
Topic 12 | Understanding Operating Systems
11:57
Topic 13 | Connecting to Wi-Fi and Mobile Data
06:44
Topic 14 | Web Browsers and Navigation
10:53
Topic 15 | Smart and Safe Searching
07:00
Topic 16 | Understanding File Types and Extensions
10:00
Topic 17 | Creating and Naming Folders
11:00

Module 2

Module 3

Module 4

Module 5

Module 6

Module 7

Module 8

Module 9

Module 10

Module 11

Module 12

Advance Excel Software

Understanding the Excel Interface
00:00
Creating, Saving, and Managing Workbooks
00:00
Entering and Editing Data
00:00
Formatting Basics, Keyboard Shortcuts and Quick Access Toolbar
00:00
Introduction to Formulas and Functions
00:00
Basic Formulas and Real World Examples with Easy Techniques
00:00
Working with Mini Static Bar
00:00
Data Filter and Sort
00:00
Fill Handle and Autofill
00:00
Formula Operators and BODMAS
00:00
Understanding Relative, Absolute and Mix References
00:00
Handling Data using Range Name
00:00
Format as Table to Automate Data
00:00
Text to Column
00:00
Concatenate (Joining Text), Flash Fill, Filling Empty Cells
00:00
SumIFS – Summarizing Function
00:00
SumIFS – Summarizing Function – Level Up
00:00
CountIFs – Counting the data entries
00:00
IF – Decision Maker
00:00
IF AND OR – Decision Making with Complex Conditions
00:00
Text Function for Data Extracting
00:00
SEARCH – Data Extracting Using Delimiter
00:00
VLOOKUP – Understanding
00:00
VLOOKUP – Using Name Range
00:00
HLOOKUP – Extract Data Using Horizontal Lookup
00:00
VLOOKUP – Working with Duplicate Data
00:00
INDEX and MATCH
00:00
XLOOKUP – Extracting Data with more capabilities
00:00
Filter – Get the Data You Want
00:00
Advance Filters
00:00
Advance Filters with Formulas
00:00
Data Consolidation
00:00
Conditional Formatting – Part 1
00:00
Conditional Formatting – Part 2
00:00
Charts – Analysing Data with Graphs
00:00
Charts – Creating a Column Chart
00:00
Charts – Creating a Bar Chart
00:00
Charts – Bullet Chart
00:00
Charts – Creating a Pie Chart and Pie of Pie
00:00
Charts – Creating a Line Chart
00:00
Charts – Adding Form Controls to Handle Charts and Other Formulas using Button
00:00
Pivot Tables – Data Summarization and Analyzation
00:00
Pivot Tables – Adding Fields, Filtering and Sorting Data
00:00
Pivot Tables – Do More, Build More
00:00
Pivot Tables – Working with Dates
00:00
Pivot Tables – Groups
00:00
Pivot Tables – Slicers
00:00
Designing Dashboard Using Pivot Tables and Charts – Part 1
00:00
Designing Dashboard Using Pivot Tables and Charts – Part 2
00:00

Student Ratings & Reviews

No Review Yet

About Course

Course Content

Module 1

Topic 1 | What is Digital Literacy?

Topic 2 | Introduction of the Instructor

Topic 3 | Course Orientation

Topic 5 | Safe Online Behavior

Topic 6 | Responding to Unsafe Online Behavior

Topic 7 | Understanding Digital Footprints

Topic 8 | Controlling Your Digital Reputation

Topic 9 | Technology Use Ethics

Topic 10 | Building Healthy Digital Habits

Topic 11 | Exploring Digital Devices

Topic 12 | Understanding Operating Systems

Topic 13 | Connecting to Wi-Fi and Mobile Data

Topic 14 | Web Browsers and Navigation

Topic 15 | Smart and Safe Searching

Topic 16 | Understanding File Types and Extensions

Topic 17 | Creating and Naming Folders

Module 2

Topic 18 | Understanding File Naming Rules

Topic 19 | Uploading and Syncing Files

Topic 20 | Accessing Files Across Devices

Topic 21 | Sharing Files Safely

Topic 22 | Organizing Files for Projects

Topic 23 | Cleaning Up and Archiving Old Files

Topic 24 | Creating and Saving Documents

Topic 25 | Formatting Text Content

Topic 26 | Inserting Tables and Images

Topic 27 | File Saving and Exporting

Topic 28 | Using Templates Effectively

Topic 29 | Real-Time Collaboration

Topic 30 | Checking Spelling and Grammar

Topic 31 | Page Layout and Print Settings

Topic 32 | Tracking Changes and Comments

Topic 33 | Inserting Hyperlinks and Bookmarks

Module 3

Topic 34 | Designing Simple Slides

Topic 35 | Choosing the Right Color Scheme

Topic 36 | Using Visual Elements

Topic 37 | Working with Fonts and Text

Topic 38 | Applying Transitions & Animations

Topic 39 | Embedding Media in Slides

Topic 40 | Presenting with Confidence

Topic 41 | Using Presenter View

Topic 42 | Storytelling Techniques

Topic 43 | Preparing for Live Presentation

Topic 44 | Entering and Formatting Data

Topic 45 | Creating Simple Tables

Topic 46 | Using Basic Formulas

Module 4

Topic 47 | Applying Logical Formulas

Topic 48 | Exploring Common Functions

Topic 49 | Formatting as Currency & Percent

Topic 50 | Creating Charts and Graphs

Topic 51 | Using Pivot Tables

Topic 52 | Cleaning and Preparing Data

Topic 53 | Exporting and Sharing Sheets

Topic 54 | Typing Speed Practice

Topic 55 | Formatting Text Consistently

Topic 56 | Data Entry in Excel

Topic 57 | Using Find and Replace

Topic 58 | Digitizing Scanned Documents

Module 5

Topic 59 | Keyboard Shortcuts

Topic 60 | Reviewing for Errors

Topic 61 | Simulated Entry Tasks

Topic 62 | Joining Online Meetings

Topic 63 | Video Call Etiquette

Topic 64 | Email Writing Basics

Topic 65 | Chat Communication Skills

Topic 66 | Screen Sharing & Presentation

Topic 67 | Following Up After a Meeting

Module 6

Topic 68 | Managing Calendars

Topic 69 | Organizing Inboxes

Topic 70 | Writing Quick Client Responses

Topic 71 | Maintaining Task Lists

Topic 72 | Creating Weekly Reports

Topic 73 | File Sharing with Clients