Friday, April 15, 2022

Microsoft Excel Tip Aplying FILL Series for Days, Months and Number Series

Techniques in applying FILL Series for Days or Months and Number series in Excel

There are times as an Excel user new or otherwise when we accomplish tasks not in a very efficient and easy way in Excel. For example, you want to fill in Months by typing all the months because you may not be aware of the Series 'Fill-down' techniques or you would like to fill in a number series from 1 to 10000 and you wonder how you can accomplish that task by a few clicks like a 'Pro'. Click the short video tutorial for some helpful tips that can increase your efficiency when working in Microsoft Excel. We hope you find this tutorial helpful



Tuesday, April 12, 2022

Welcome to Bright Excel Campus community



Thank you and welcome to all who have joined the Bright Excel Campus Facebook community page (https://www.facebook.com/groups/959592901391249). The general objective of the online Campus is to help build useful Microsoft Excel Spreadsheet skills in members which are suitable for data manipulation, data analysis, and reporting using the power of Excel Tables, charting tools, or advanced methods such as Power Queries, Pivot tables, and Power Pivot.
As you may be aware, Microsoft Excel is a software program created by Microsoft that uses spreadsheets to organize numbers, text, and other forms of data with the ability to use formulas and functions. For spreadsheet lovers, it’s the software of choice for data modeling, statistical analysis, and reporting in meaningful ways. Excel can also be used by schools for general mathematical computation.
We welcome all our members to this community of Excel users. Some of our members may be new to Microsoft Excel, some could be basic users and others may be advanced users. At whatever level you are this is the place you are at liberty to ask questions and share ideas for the sole purposes of ultimately developing experts in Excel Spreadsheet in every member. The Bright Excel campus community Facebook page is connected to the online campus blog https://brightexcelcampus.blogspot.com/where resource materials of interest will be uploaded for you from time to time use and you will be free to download.

My name is Bright Mulenga holder of a BSc in Computer Science, Professional Diploma in Project Management (with Microsoft Projects software), Advanced Diploma in Computer Science & Information Processing, and Masters in Business Administration (MBA). I have been using spreadsheets for over 20 years starting with Lotus123 and Microsoft Excel from basic to advanced techniques. I am also an ardent user of the SPSS application for data analysis purposes. It's my hope to share my Excel experience with members of the Bright Excel campus community

Tuesday, April 5, 2022

Excel useful Keyboard short-cuts that make you work like 'Pro'

Microsoft Excel seems by far the Application of choice by many financial and Data Analysts working with sets of data for decision making and reporting. It is an interesting and user-friendly data manipulation software to work with. However, it is even more interesting when you learn how to use short-cut keys to carry out commands without using the traditional mouse. Excel has a lot of short-cut keys available for use but here are some of the most useful  that can make you the user work like 'Pro' and set you apart from most Excel users in the link below ->>

Useful Excel Short-cuts

Monday, April 4, 2022

Technolgy For 'the GOOD' of Africa

We can not afford to click the 'Undo' button to reverse technology: Technology is here to stay

One wonders why some people are still afraid of the computer! Is it related to the way the computer looks? The desktop computer looks so big that sometimes someone may think that with one mistake everything could break down? Or the Laptop computer is too small for their liking? Whilst some of these could be attributed, there is still one thing that the writer of this article has observed over the years of spending time teaching people how to use the computer equipment and the applications installed on them. First things first, it was common in the 90s that the people who learned how to use the early versions of computers and their application software wanted to keep the skills only to themselves hence, portrayed the computer as a very difficult piece of equipment to mess with. People were made to understand and believe that the computer needed special attributes or intellectual abilities to go around it. Believe me, some top executives could still be uncomfortable with computers. Whatever the reason some people are still not friends with the computer, it is time to simplify and demystify these valuable pieces of technology.

It is a fact without question that the modern era is a technology-driven one. Therefore, it is not for anyone to decide whether to use or not to use technology as a daily essential in third world nations. The truth in the face of everyone is that we are all affected by technology. The advent of mobile technology, email, social media, and virtual platforms such as Zoom has given mankind the ability to communicate and collaborate instantly across cities, countries, and continents with ease hence, bringing about efficiency in service delivery systems. Nearly all the banking services have been automated, therefore, who can escape the technological Trap. People in the third world nations require computers or technologies of some kind in their homes to do what previously they had to take a trip for in order to accomplish. Things like shopping, education and so on. However, the rate at which technological services are progressing does not seem to match the advancement in computer literacy amongst the elderly (improperly referred to as the BBC: born before Computers) and vulnerable groups in rural Africa. Most rural schools may yet to get a really good experience with a modern Desktop Computer far less a Laptop or Notebook computer. They may have seen a computer on paper but not enough to distinguish the different common parts of the equipment in reality when the equipment is physically present. The level and quality of some categories of Computer knowledge being imparted in certain cases may be half-baked. The Lecturer calls the System Unit a CPU (Central Processing Unit). Well, the argument in calling the computer's system unit as the CPU that may have been advanced could be that of trying to simplify the technical jargon. But if that is the case why not call the entire house a Toilet in order to describe what a house is. Africa needs to bridge the Technology gap A.S.A.P. and stop being spiritual about everything

We are about to be overwhelmed by the 5G technology era and everyone better get ready to join in or be left behind. Technology will contribute to the conservation of our environment as we go paperless with technology.

Welcome to BRIGHT EXCEL CAMPUS where we are sharing “Technology for Good” through applying the power of Computer applications such as Microsoft Excel to help in making data tell the whole story that can help in data-driven decisions making in personal, professional, and business arenas. 

Learn anywhere any time and don't stop learning

Igwee! Bright

 

Why Give?

  ic Give not because you have enough, not even because you expect a payback some day, and not even because you want to be celebrated by tho...