I chose to learn about GoalSeek on Excel this week on a blog titled: How to use Goal Seek in Excel for What-If analysis , the author provided images and descriptions of how to determine a passing grade for an exam. The problem is as follows: At the end of the course, a student takes 3 exams. The passing score is 70%. All the exams have the same weight, so the overall score is calculated by averaging the 3 scores….
I want to preface this my saying that no ounce of my being considers myself an artist, but excel art is actually super fun (and pretty simple if you know a few tricks)!! Bringing myself back to the article that started this whole project I wanted to learn how to make artwork on excel I found some tutorials on YouTube for excel art, but I had some issues because I am using a macbook and I don’t have access to…
For my learning post this week I used Alison which incorporated video tools, and descriptions for learning excel. They have a lot of free online courses, but I chose Data Entry Tools and Techniques module. There are quizzes built into the presentations which made feedback instant and easy to understand. It was super basic to start and slowly progressed to a point where I felt adequately challenged. They have lots of other free classes online that might be cool to…
This week I found an excel obstacle course. Which is actually a super fin way to learn shortcuts on excel. If you want to check this out it can be downloaded from the ExcelObstacleCourse YouTube channel!! I began by navigating through the various pages. I started by deleting columns and rows with only the keyboard as a tool. I learned that shift and space bar together will highlight an entire row, then to delete it I simply had to use…
So this week I thought I would watch a series of tiktok videos from a creator named Mike Tholfsen. He has hundreds of videos (give or take) that discuss helpful tricks or cool aspects of Excel. His videos are able to show how exactly you can follow the steps to acquire the desired results. I am not someone who does well with vague instructions so his videos were the best ones that I found. I was also asked by my…
The past two weeks I have been focusing on learning about formulas and functions on Excel. I am combining two sources for this, first I looked at the Microsoft support website, then I watched some videos on YouTube. I started by watching a video from Kevin Stratvert titled Excel Formulas and Functions Tutorial, then I watched a more in depth video from The Organic Chemistry Tutor (who I have used a lot for my university courses). The video was titled…
For my learning project I have chosen to learn more about Microsoft excel. I have always found it to be so interesting when people can create elaborate worksheets, and I felt that since this class was about technology I should finally learn to use excel. This is also an inexpensive skill that does take time to learn, so while I have an opportunity to learn I probably should. As it currently stands I don’t have many capabilities with Excel beyond…