Page 216 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

1 Provide more examples
Flash Fill learns by example. If it is unable to recognize a pattern in your data, fill in a couple more cells manually,
so that Excel could try out different patterns and find the one best suited for your needs.
2 Force it to run
If Flash Fill suggestions do not appear automatically as you type, try to run it manually.
3 Make sure Flash Fill is enabled
If it does not start either automatically or manually, check if the Flash Fill functionality is turned on in your Excel.
4 Flash Fill error persists
If none of the above suggestions has worked and Excel Flash Fill still throws an error, there is nothing else you
can do but enter the data manually or with formulas.
That's how you use Flash Fill in Excel. I thank you for reading and hope to see you on our blog next week!
Database access from MS Excel

“Microsoft Access is an excellent general-purpose database management system whereas Excel
is a spread sheet package, with lots of extra features thrown in.”

MS Excel vs Access Comparison
MS Excel and Access are both Microsoft Office products. Microsoft Access, from the Office suite, is an excellent
general-purpose database management system made for storing and analysing data.
Excel on the other hand is a spread sheet package, with lots of extra features thrown in which allow you to do
things like creating pivot tables for summarising data. Using Excel as a database is great for small businesses
and database beginners.
What Is MS Excel Used For?
Many people use Excel in business for a range of tasks from simple admin to full-scale automation. Thanks to its
easy to use features Excel is very flexible and allows you to summarise data quickly without having to do anything
too complicated.
Some of the uses for Excel include:
• Tabulating and analysing complex numerical data

• Creating tables and forms
• Writing and running macros to automate tasks
• General day-to-day data management (e.g., creating reports, charts, etc.)
• Store and manipulate audio and video files

Excel is very intuitive and easy to use, which allows most people to learn it quickly. If you’re job hunting, including
Excel skills on your CV can help you out a lot!
What Is An MS Access Database Used For?

MS Access is a database management system that gives you the ability to store your data in a relational database.
This means that you can have multiple tables, linked together to form a relationship, which is all stored in one file.

203

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77