Category: Uncategorized

365 days of excelling with Clyve

Post author By clyve
Post date March 31, 2021
No Comments on 365 days of excelling with Clyve

file picture: from Mucheka Mountain zowa, zimbabwe

Hello Friends

Tomorrow I embark on a 365 days long Journey in which I will be posting one Excel Tip/how-to video on my YouTube channel and I will be putting the excel link on my wall.

I am banking on your support to cheer me along the way.

To support me please share my videos on your walls so that your friends can also see my posts.

My YouTube channel link is

https://www.youtube.com/channel/UCwcbjIV_8w1PyDNL4iM1dfA

Uncategorized

Excel 101 Introduction to Excel

Post author By clyve
Post date March 22, 2021
No Comments on Excel 101 Introduction to Excel

CELL BASICS (Coming tomorrow)

In this video series which is a follow up video on our first video what is excel you will learn more on excel expanding your knowledge on understanding excel cells and how you can make them work for you to do un imaginable things.
You will learn the following among other things:

What is a cell
Cell address how it is determined
- Name box
- Changing cell name
Cell range
- Address
- Named range
Cell Content
- Text
- Formatting
- Formulas
Inserting content into cells
Delete cells
Delete cells content
Copy & paste cell content
More paste options
Drag & drop contents
Fill handle (corner of cells)
Continue a series with fill handle(Monday etc)
Find Content, Find and replace, Find Next

Uncategorized

Excel 101 Course Content

In this exciting series, you will learn excel from beginner level to expert level in 5 simple levels. In level 1 named excel 101 here is what you will learn:

Lesson	Lesson Contents	YouTube Video Link
Getting Started with Excel \| Lesson 1	Understanding Excel Interface Creating new workbook Sharing workbooks Saving workbooks	Click here
Cell Basics \| Lesson 2	What is a cell Using cells	Coming Soon
Formatting Cells \| Lesson 2	Formatting Cells	Coming Soon
Modifying Columns, Rows and Cells \| Lesson 3	Resizing columns	Coming Soon
Formulas and Functions \| Lesson 4	Simple formulas Complex formulas Nested formulas	Coming Soon
Functions \| Lesson 5	Excel Functions	Coming Soon
Working with Data \| Lesson 6	Sorting Filtering Etc	Coming Soon
Working with Charts \| Lesson 7	Creating a new chart Customizing charts Editing charts Custom visualisation	Coming Soon
Printing Workbooks \| Lesson 8	Print to an external printer Print to PDF	Coming Soon

Uncategorized

Automating Excel | Method 2 Power Query

Post author By clyve
Post date March 13, 2021
No Comments on Automating Excel | Method 2 Power Query

In this video we learn how we can automate data collection/ data transformation process by making use of power query and we will look at the following sources of data:

Excel table :You will learn how you can grab data from a particular excel table and add some transformation steps to clean the data and use it for reporting.
Excel worksheet: You will learn how you can grab data from a particular sheet and add some transformation steps to clean the data and use it for reporting.
Folder: You will learn how to combine multiple excel files into one single file by just dropping the different files into a particular folder.