Videos

This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

Want to Know More About Your Training –

 Find Out Here1. When do I start my course?
As soon as you register, you have started on the course, we will then begin to send regular e-mails informing you of the next lesson in the course. If you have not registered yet, you can do so here.
Select your required course and follow the lessons.
2. How long does the course take?
We will send you an email every couple of days, and at that rate it will take about eighteen months for you to receive all the emails. We do add new content all the time which may extend the course.
You can work through the lessons at your own rate, and revisit ones that you found useful on the site by selecting the lessons tab on the navigation bar and choose the lesson you want to study.
3. Do I have to pay to access the course?
There is currently no charge for use of the website .The costs associated with the delivery of this training site are met by on page advertising only
4. How do I get my certificates?
The courses on this site are not certified.  Although some courses have a quiz, if any certificate is sent it will be for your own reference.
5. What if I can’t access my lesson?
You can usually access your lesson by clicking the link provided. If this doesn’t work, copy and paste the link into your web browser, or type it in.
7. How do I find a lesson?
Select the lessons tab on the navigation bar and choose the topic and lesson you want to study from the dropdown menu. The side bar of every lesson has a link to all the lesson modules on the site.
8. How do I search for a specific topic?
Open any lesson, and a search bar will appear near the top, beneath the blue navigation bar, at the right hand side.
9. Why has nobody replied to my question?
We have more than 250,000 visitors to the site each month, and receive hundreds of emails each day. We are a small team and cannot usually respond to individual questions.
10. I have asked for downloads to be emailed to me, why have they not been?
As above, we have more than 250,000 visitors to the site each month, and receive hundreds of emails each day. We are a small team and cannot usually respond to individual requests.
11. Can I invite a friend or colleague to visit the website and join the course?
Yes, you can invite as many friends or colleagues as you like, Just email this link to them 
12. My name has been spelled incorrectly on my account. Is this important?
This will mean that your certificates will be issued in the incorrect name. If you want to alter your name on the account please unsubscribe and then re-register.
13. I want to start the course again, how can I do that?
Please unsubscribe and then re-register. You will then receive emails from the start of the course on the new account.
14. I want to change my email address, how do I do that?
Please unsubscribe and then re-register. You will then receive emails from the start of the course on the new account.
15. Why does no one reply to my comments?
We have more than 250,000 visitors to the site each month, and receive hundreds of comments and emails each day. We are a small team and cannot usually respond to individual comments. Comments are moderated, but only rarely can we respond to specific comments
16. I no longer want to take the course and I would like the emails to stop.
At the bottom of every email we sen out there is a link titled "Not interested in receiving more?" Click on this link and you will be asked to confirm your request. Press the button and your information will be removed from the system and no further emails will be sent.
Share:

How To Install LibreOffice

LibreOffice is an Open Source office suite that works in almost all major computing platforms. The applications in the suite include a word processor Writer, a spreadsheet manager Calc, a presentation creator Impress, a drawing tool draw, a formulae creator Math and a database management system Base. This free and light office program is available in over 110 languages and is the first choice for open source enthusiasts.
LibreOffice package is available in two different versions – “fresh” and “still”. The “fresh” version consists of the latest enhancements that have been made since the latest release and the “still” version is for people who want to operate in an older yet more stable environment. In this tutorial, we would be seeing the installation procedure of the LibreOffice fresh version 4.3.5 for Windows. But before we can begin, we need to know the software and hardware prerequisites.
  • Operating system: Microsoft XP SP2, Vista, Windows 7 or Windows 8.
  • Processor: Pentium III or Athlon or more recent system-recommended processor.
  • RAM: A minimum of 256 MB, but we would recommend using a 512 MB.
  • Disk space: A maximum of 1.5 GB is needed.
  • Monitor resolution: 1024×768 with at least 256 colors; higher resolution is recommended
  • For some programs, especially Base, Java is required.
  • Administrator privilege is required.
As good practice, we would recommend you backup all your data before you begin the installation of any software.
The installation procedures are simple and straightforward. Follow these steps with me.
I am using Google Chrome Browser on Windows 8.1. If you have a different configuration the first part of this tutorial may look slightly different.
Step 1:
Download the latest LibreOffice package from here and save it in a directory on your system. If you already have the setup file of the package in your system, then double-click it.
Step 2:
When the setup file starts, you will be getting a dialog box asking if this file can be run in your system. Press “Run”
Step 3:
The setup file begins to run in your system and in a minute a welcome dialog box would pop in your screen. Press “Next”.
Step 4:
The next step involves you selecting the mode of installation- typical or custom. “Typical” mode will install the package with the default setting and configurations while the “Custom” mode lets you set program features that you want to be installed.
Step 5.1:
If you choose the “Typical” mode of installation you would be straightaway directed to the “Installation Wizard”. Check the relevant options for you and press “Install” for the installation to start.
The installation will begin right away in the “Typical” mode.
Step 5.2:
If you choose “Custom” mode of installation, you would be looking at custom setup dialog box asking you to choose optional components and the language packs.
Click on the dropdown arrow near the icon and select the type of installation of the components. There are some components that are installed by default. You can choose to not install it by the setting the icon to the red cross as shown in the picture. For example, you can expand the dictionaries module and can select the languages you want.
In the same step, you can select the additional user interface language. By default, the package will have English and the language of the operating system as interface languages. You can select more or remove one of them as per your preference.
As you can see in the description to the left, when you select a component or the language you want to install, the wizard will automatically calculate the amount of space required to install that particular component in your hard disk. When you are done with the selection of languages, continue with the installation by pressing “Next”.
Step 5.3:
The next step will open up a dialog box asking if you want to set LibreOffice as the default office program. It means that, if you check “Microsoft Word Documents”, you will open a Word document in LibreOffice. By default, all the boxes will be unchecked. After choosing, press “Next”.
You will be getting the dialog box mentioned in Step 5.1 after all the customization. Check the appropriate boxes and click “Install”.
Step 6:
Step 6 involves waiting. The installation would begin and depending on the speed of your computer this may take several minutes.
Step 7:
If you get this dialog box, then your installation is successful and complete. Click “Finish” and start working on your projects using the all new LibreOffice.
Share:

Office Productivity Software

Computers could be considered as the biggest invention of the 20th century. This Technology Era has removed so many obstacles and pushed boundaries much farther. You can love it or hate it, but they have invaded our present and would continue to expand in the future. From simple computing operations to robotic science, much of mankind’s progress till date could be attributed to computers and its related technologies. The functionalities of the computers have grown leaps and bounds and we are discovering new necessities every passing day. This machine has a great impact in advancements of every field that we cared to venture upon. Several tasks that were considered as uphill and mundane before are reduced to a matter of just-a-few-clicks now. One such development that made this dream possible for human beings is the productivity software.
The Productivity software, often called as Office Suite, is an application program that is programmed to make operations related to creating and processing of information much easier. We can now manage huge amount of data and perform a variety of operations in just a few seconds. With many million downloads a day and so many office programs in the market, there is no dearth in the availability of options. Let us dive deeper and know more about office software’s functions and how it has managed to make our lives easier.

The multi-faceted program

Office Suites can perform an array of operations, each with many dimensions, thus providing you all the solutions for your office needs. A few programs such as Word Processors, Spreadsheets and Presentation creators are used widely than other programs like mailer, database software, note-takers, project management software etc. These programs have cross-linking and sharing capabilities which make them so powerful and efficient.
The Word Processor is a program such as Microsoft Word, iWork Pages, Google Docs etc. that lets you create a document with pictures, hyperlinks and graphics. It offers you full freedom to customize the layout, fonts, size etc.; helps you to correct the grammar and spelling mistakes in the documents; provides you with suggestions from dictionary and thesaurus and allows you to save in many formats to run across many platforms. Advanced word processors help multiple users to edit a single document at the same time, help to create table of contents, provide version control for a document and so on. The Word Processors are widely used by authors, editors, copy writers, and students for their everyday works.
The Spreadsheet is intelligent software that typically has many sheets with thousands of rows and columns. The main purpose of a spreadsheet is to allow a user to record and analyze data in a tabular format. These spreadsheets have made accounting and other calculations easier with their built-in formulae. All you have to do is enter data, choose a row for your answer and select the formula that you want to apply. Advanced spreadsheets allow users to enter their own formulae to scale its functions. We can also compare the data entered and produce an analysis report with a variety of graphs and charts. A spreadsheet is capable of much more functionalities that make it one of the best tools for an organization. This software is especially useful for data analysts and accountants. Examples of spreadsheets are Microsoft Excel, Google Sheets, and iWork Numbers etc.
Presentation programs are designed to project your thoughts in a more intuitive and elegant way. This program has built-in layouts for slides that you can fill with the information you intend to present with pictures, graphs and animations. This software is very useful to create an effective visual aid for the students to learn. For businesses, this tool has become a necessity during meetings and brain-storming sessions. The presentations can be also be loaded with audio clippings and flash animations. When your presentation is equipped with interactive integrated hardware elements, you can project your information across many geographic locations.
The other products of productivity suites like email clients, desktop publishing software and personal information managers etc. are used by specific set of people for their business or academic requirements. The mailer software is used for sending and receiving of emails – from small groups to big enterprises. Note-taking programs are used to create and maintain notes from various sources. It also allows editing, analyzing and sharing of the notes. There are so much more programs that are tailored for personal use, thanks to the open source network.

The Audience

These office programs are particularly beneficial for the so-called “Knowledge Workers”. The knowledge workers can be students, doctors, engineers, data analysts, inventors or coders. This group consists of people from many streams of life whose day-to-day work involves processing of information. These programs evolve in order to meet the new challenges that they are exposed to everyday, thereby reducing time and increasing the efficiency. They need data and they need it in the way they can easily understand and process. These office suites are designed with them as the target beneficiaries.
Another group of users are the businessmen. They need information everyday to introspect and grow. In the age where information is considered to be the wealth, no wonder they consider these programs as God-sent. They use many office programs such as spreadsheets, presentation, note-taker etc. The dynamic nature of their industries goes well with the dynamic capabilities of these applications.

The Future

With the technology moving towards smaller and more compact models, smart phones and tablets have almost replaced the computers. Subsequently, these application programs are designed to work effortlessly in all these platforms. With many new service providers entering the market every day, the necessity to scale and fit has become inevitable for every technology. Another major enhancement that has been recently added to all these programs is the cloud-share capability for storing and sharing of information on the go. While we cannot accurately predict the next big thing in this industry, we can still say that we are equipped with technologies that can evolve, fit and work efficiently in any given scenario.
Share:

Office

Not so long ago people used pens and papers to create documents; manually calculated and tallied the expenditure statements; drew meticulously in OHP sheets for presentations? The development and popularity of office productivity programs has completely revolutionized the way offices function and has almost made the methodologies adopted a couple of decades back obsolete. The multi-dimensional functionalities of these application programs have made them a necessity for every kind of industry.

From the day of there inception as a tool for office administration, these programs have been refined, restructured and written over and over again to meet the growing demands. Probably, Microsoft’s office has been the winner by and large; but it hasn’t stopped its competitors from coming up with programs that are equal and in some cases superior in functionality. Here we will discuss the four main players in the market by mentioning their top features and the ways in which one is more suitable than the others.

Office:

MS OfficeMicrosoft Office is the most popular productivity suite with over 500 million users worldwide. It is compatible with both Windows and Mac operating systems. The Office 365 service is the non-PC, cloud based version of Office and it allows you to operate the application program in phones, tablets and iPads. The most used programs in the Office’s arsenal are Word, Excel, PowerPoint and Outlook. The abundant formatting options in Word, alluring designs in PowerPoint and the robust functionalities of Excel has definitely made office operations much easier.
However, this closed-source package has certain limitations like poor support for importing many graphics formats, layout problems in Word, lack of support for spreadsheet comparison, no auto-completion in Excel and the absence of work-around for XHTML or HTML conversion in PowerPoint, to name a few. Also, this application program is not free. Although The complete Microsoft Office Package is offered at a discount for student edition the full priced commercial edition is outside many peoples budget. Office 365’s package offers a monthly or yearly subscription. Also, you need a subscription to use Office 365 in Android and iOS devices.
Weighing up the functionality and the shortcomings, Microsoft’s office is clearly best suited for offices, commercial enterprises and schools that require high-level functionality and want to seamlessly manage their works across mobiles, PCs and tablets.

iWork:

iWorkiWork is Apple’s answer to Microsoft’s office. It is an Apple proprietary product that is built to run only in MAC operating system. iWork boasts of providing an intuitive user interface that is as simple as it can get. The easier menu and formatting options are a boon for people who have just started to learn about these programs. Pages is a much cleaner and simpler Word Processor program that has all the layouts and formatting options required to create and maintain documents. The MS Excel equivalent of iWork is Numbers which has similar functionality to Excel put together with complete control over the fonts and design used. Keynote is the presentation program of iWork that possesses rich designs, better animations and audio-video integration. The biggest advantage of them all is it is free for people owning a MAC device.
The main problem while operating in iWork is the lack of compatibility of the file types. It is difficult to open or save an Office document in iWorks without importing or exporting certain functions. Unfortunately, this is as difficult as it sounds. There is this danger of a few components of the original documents disapearing during this transition. Because iWork has a smaller ecosystem as compared to Office, this might be a big problem in the longer run.
pages As mentioned earlier, iWork does everything that Office does with much more clarity and simplicity. If you are a MAC user and your needs are limited to only medium range of functionality then iWork could be the choice for you.

Google Docs:

Google DocsGoogle came with an application suite solution known as Google Drive that lets you create and manage your works online. Google Drive is a whole package with individual apps – Docs for word processing, Sheets for spreadsheet functionality and Slides for presentations. All these applications run together in the Google Drive ecosystem. The biggest advantage of this package is all that you need is a Google account to access all these applications. It is free, it is online and it can be operated from almost anywhere. The capabilities of Docs, Sheets and slides for various operations are as competent as iWorks or Office but with limited sophistication. The sharing option allows you to share your documents or spreadsheets anywhere across the globe almost instantaneously. Google Drive also provides other features like form tool that allows you to build an online survey that stores results in a spreadsheet, create PDFs, fax documents etc.
But one major aspect that we need to worry about working in Google Drive is that you should be online, at least for creating a new document. While there are options available to edit your works offline, you would still need an internet connection for synchronization. So this would be a disadvantage when all you have is a stand-alone PC. So Google Drive is best suited when you want the information to be processed immediately and to be shared on the fly.

LibreOffice:

Libre OfficeLibre Office is a free and open-source application program. It is the forked version of OpenOffice with programs to cover all the functionality of Microsoft Office. Libre Office is available in over 110 languages and is slowly gaining popularity. Being an open-source program, this is considered as one of most sophisticated office suites available. It is available across Windows, Mac and Linux platforms and it has the capability to run on USB flash disks without any installation. The word processor in Libre is known as Writer; spreadsheet tool is known as Calc and the presentation tool is Impress. The functionality of these tools are akin to that of its Microsoft or Apple equivalents and in some cases, even better.
Being built in an open source environment has its short-comings. The presentation app has only a few themes and the customizable tool bars doesn’t adjust to your most-frequented options like it does in MS office. Libre office is suitable for tech-savvy people who strongly believe in the open source system.
Share:

স্প্রেডশীট ক্যুইজ বোঝা ? Understanding Spreadsheets Quiz

এই সফ্টওয়্যারটি সফ্টওয়্যার সুইট সিরিজের অংশ, বোঝার স্প্রেডশিটস কোর্সের সামগ্রীর আপনার জ্ঞান পরীক্ষা করার জন্য ডিজাইন করা হয়েছে। এই কুইজ আপনার স্প্রেডশীট দক্ষতা উন্নত করার জন্য ডিজাইন করা হয়।
This quiz is designed to test your knowledge of the contents of the Understanding Spreadsheets Course, part of the Office Software Suite series. These quizzes are designed to improve your Spreadsheet skills.
সেখানে বিশ প্রশ্ন আছে। পাস চিহ্নটি সম্ভাব্য 100 পয়েন্টের মধ্যে 70 টি, প্রতিটি প্রশ্নের জন্য 5।
There are twenty questions. The pass mark is 70 out of a potential 100 points, 5 for each question.
একবার আপনি আপনার উত্তরের সাথে সন্তুষ্ট হয়ে গেলে, আপনার নাম এবং ইমেল ঠিকানাটি পূরণ করুন এবং আপনার উত্তরগুলি চিহ্নিত করার জন্য "ক্যুইজ জমা দিন" নির্বাচন করুন।
Once you are satisfied with your answers, complete your name and email address and select “Submit Quiz“ to have your answers marked.
আপনি শীঘ্রই আপনার স্কোর সম্পর্কে পরামর্শ দেওয়ার জন্য একটি ইমেল পাবেন, আপনি কুইজটি পাস করেছেন কিনা এবং আপনার উত্তরগুলি কীভাবে স্কোর করা হয়েছে। এটি আপনার বিনামূল্যে অনলাইন প্রশিক্ষণ কোর্স যথাযথ ক্যুইজ জন্য কুইজ সমাপ্তি সার্টিফিকেট অন্তর্ভুক্ত করা হবে।
You will shortly receive an email advising you of your score, whether you have passed the quiz, and how your answers have been scored. It will also include your Free Online Training course quiz completion Certificate for the appropriate quiz.
1.What is the shortcut keyboard command for selecting the entire worksheet?
 
 
 
 
2.In LibreOffice Calc, which tool can be used to make incremental data entries into a spreadsheet?
 
 
 
 
3.Which of the following is not good practice when entering data to the cells of a spreadsheet in LibreOffice Calc?
 
 
 
 
4.Which of the following basic options/preferences can be set in the LibreOffice Calc application?
 
 
 
 
5.In LibreOffice Calc, the logical function ‘If’, takes how many arguments?
 
 
 
 
6.Which of the following error code signifies that the column, row or sheet for the referenced cell is missing?
 
 
 
 
7.To insert a new column into a spread sheet, we need to right-click on the column header to the right of which we want to insert a new column, and from the resulting menu we need to click on ‘Insert Columns Right’.
 
 
8.When working with worksheets, we should just accept the default names for the new worksheets instead of changing the names as it saves us time and does not make much of a difference.
 
 
9.When we enter a text value in a cell in LibreOffice Calc, then these are by default……
 
 
 
 
10.The ‘COUNT’ function from the ‘Statistical’ category in LibreOffice Calc counts how many values are present in the argument list. This function counts the number of all kinds of values present in the argument list, be it numbers or text or any other.
 
 
11.The undo command undoes the effect of the recent changes which were made to the document in such a way so that the most recent change is undone in the end.
 
 
12.Which among these is not a chart type available in LibreOffice Calc?
 
 
 
 
13.Which of the following cannot be changed when a spreadsheet is saved?
 
 
 
 
14.In Calc, freezing locks a number of rows at the top of a spread sheet or a number of columns on the left of a spread sheet or both rows and columns. Then, when moving around within a sheet, the cells in frozen rows and columns always remain in view.
 
 
15.It is possible to hide/display the different types of toolbars which are displayed at a time in LibreOffice Calc.
 
 
16.Which of the following is an acceptable syntax for absolute cell referencing in LibreOffice Calc?
 
 
 
 
17.In LibreOffice Calc, for the ‘ROUND’ function from the ‘Mathematical’ category, if the ‘number’ selected from a cell is ‘1006.5555’ and the ‘count’ given is 2, then the result will be ….
 
 
 
 
18.Which of the following error code signifies no valid reference for an argument?
 
 
 
 
19.When using functions and formulas in LibreOffice Calc, it is always better to enter cell references rather than typing numbers directly into the formulas.
 
 
20.Which among these tools is most commonly used to copy the formatting from a cell or a cell range to another cell or cell range?
 
 
 
 

Be sure to click Submit Quiz to see your results!
Share:

Definition List

Unordered List

Support