ICS 101: MS Excel Skills for Students & Job Seekers
| Institution | Maseno University |
| Course | Bachelor of scince I... |
| Year | 1st Year |
| Semester | Unknown |
| Posted By | Smart ICT Notes – Kenya |
| File Type | |
| Pages | 10 Pages |
| File Size | 10.01 KB |
| Views | 93 |
| Downloads | 0 |
| Price: |
Buy Now
|
Description
MS EXCEL MASTERCLASS
For Students & Job Seekers
From Basics to Advanced – Practical Step-by-Step Guide
By GmanTech Solutions Ltd
Unlock the power of Microsoft Excel with this comprehensive masterclass designed especially for beginners, students, and job seekers. Whether you’re new to Excel or want to sharpen your skills for real-world applications, this practical guide takes you through every essential concept with clear examples, easy-to-follow steps, and real-life projects.
What You’ll Learn:
Lesson 1: Introduction to Microsoft Excel
Understand what Excel is and how it’s used across education, business, and personal life to organize, analyze, and present data effectively.
Lesson 2: Data Entry & Formatting
Learn to enter text, numbers, and dates, and apply formatting tools like bold, borders, and tables to make your worksheets clear and professional.
Lesson 3: Basic Excel Formulas
Master fundamental formulas such as addition, subtraction, multiplication, and division that automate calculations.
Lesson 4: Common Functions
Use powerful built-in functions like SUM, AVERAGE, MIN, and MAX to analyze data quickly and accurately.
Lesson 5: IF Function
Make logical decisions in your data with the IF function to categorize and evaluate values dynamically.
Lesson 6: COUNTIF & SUMIF
Apply conditions to count and sum data based on specific criteria—key skills for data filtering and analysis.
Lesson 7: VLOOKUP
Retrieve information from large tables with VLOOKUP—an essential tool for managing databases and price lists.
Lesson 8: Charts & Graphs
Visualize your data with bar charts, line charts, and pie charts to communicate insights clearly and professionally.
Final Practical Projects
Put your skills to the test with real-world projects:
Student Grading Sheet: Calculate totals and assign grades
Monthly Budget Planner: Track income and expenses
Sales Tracker: Monitor daily sales and performance
Why Choose This Masterclass?
Step-by-step lessons designed for easy learning
Practical examples and exercises for hands-on experience
Perfect for students preparing for exams or job seekers enhancing their resume
Boost your digital skills and improve your employability
Empower Your Career with Excel!
Get started today with GmanTech Solutions Ltd and transform your data skills from basics to advanced mastery.
Below is the document preview.
Financial Economics notes
Pricing of financial assets: stocks, bonds and options. present value and noise trader models of pricing financial assets; usefulness of derivatives – particularly futures and options contracts and risk averse agents, interaction between domestic and foreign interest rates: premium on forward foreign exchange contracts, interest rate parity; determinants of the yield curve; the link between short and long term yields on government bonds; yield curve and structure models; term structure of interest rates>profitability of investment strategies; link between interest differentials and spot and forward exchange rates and many more on the financial market.
541 Pages
682 Views
0 Downloads
2.13 MB
BEC 317: Urban Economics
The text is designed for use in undergraduate courses in urban economics and
urban affairs. It could also be used for graduate courses in urban planning, public
policy, and public administration
529 Pages
558 Views
0 Downloads
8.19 MB
BHR 209: FUNDAMENTALS OF HUMAN RESOURCE MANAGEMENT TOPIC 4-6
Performance Appraisal is systematic or formal evaluation of an employee’s
performance over a given period of time.
22 Pages
427 Views
0 Downloads
209.4 KB
AKI 208
The following article will aid a student , learners and also researchers to know different styles in writing and how to differentiate between one style and another
358 Views
0 Downloads
16.98 KB
AEN 102 & AEN 104 MASENO UNIVERSITY PAST PAPERS
Grab a copy of a collection of Maseno University past papers for AEN 102: INTRODUCTION TO LINGUISTICS and AEN 104: ART OF WRITING. This is a great resource for purposes of your revision. Download your copy today!
19 Pages
751 Views
0 Downloads
6.75 MB
ECONOMIC PLANNING NOTES
Economic development has been closely linked with planning. Planning has
become a craze in modern times, especially in under-developed and developing
countries. The idea of planning acquired a tremendous support after the end of World
War II when advanced but disrupted economies had to be rehabilitated and the underdeveloped economies were fired with the ambition of rapid economic development.
46 Pages
547 Views
0 Downloads
422.09 KB
IT Project Management Notes – PMBOK, Exams & Practical Examples
IT Project management Notes
56 Pages
470 Views
1 Downloads
1.45 MB
Money Management Notes
The Money Management Notes provide a clear and practical guide to handling personal finances effectively. Covering ten key areas—such as budgeting, saving, spending wisely, investing, and debt management—the notes are designed to help individuals take control of their income, avoid unnecessary debt, build financial discipline, and make informed financial decisions. Whether you're a student, a young professional, or running a small business, these notes offer essential tips, examples, and tools to improve your financial well-being and achieve your short- and long-term financial goals.
10 Pages
437 Views
0 Downloads
5.41 KB