Solid Rock Institute

Let’s learn something today!

  • Time Words Days of the Week Months of the Year Other Time Words Family Words Nuclear Family Extended Family The Five Senses Sound Sight Touch Smell Taste Describing Words Distance Personality and Emotions Physical Adjectives Hair Size Looks Colors Arts…

  • Spanish and English both use the Latin alphabet, but learning your Spanish ABCs is more than just recognizing letters; it’s about getting those sounds just right! It is easy for English speakers to mix up the pronunciation on Spanish vowels…

  • Basics Introduce Yourself What’s Up Responses Etiquette Words Question Words Spanish Pronouns Greetings Talking About Age Celebrate! Say Good-Bye

  • Analyzing part of the data We have been working with various tables of data. We learned how to sort data alphabetically and from largest to smallest. This is all very useful and helpful. But what if you want to know…

  • People have worked with lists and tables of data for centuries. Until the last few decades the only option was a hand written list. You can imagine that a hand written list of information is not easily rearranged! Let’s say…

  • A world full of data The world is full of data. It always has been. For millennium people have needed to organize and record information. That information was then used in many different ways. The Bible is a very interesting…

  • VLOOKUP stands for “Vertical Lookup”. It is a function that makes Excel search for a certain value in a column, the “table array”, in order to return a value from a different column in the same row. Download File VLOOKUP()…

  • In this lesson we will work with some more functions. LEFT() and RIGHT() are some useful functions for separating out a part text that exists inside of a larger string of text. We can also use CONCAT() to join multiple…

  • Many times it is needed to use values from other cells to calculate totals, averages, or other useful information. This is a basic feature of all spreadsheets. In this lesson you will learn how to work with reference that change…

  • Conditional formatting is a wonderful way to draw attention to specific data. It also if very effective at highlighting differences in cell values. You will find other great uses for conditional formatting as you continue to use Excel. Download File…