Besides quick tips, here are some other areas in our education group that you will find interesting.
Charting Excel PowerPoint Snapshots VBA Video lessons
Here are some key training programs from our affiliates.
If you want to see certain training programs, then send us an email at info@techronology.com. We will see what we can do for you. Otherwise, enjoy all of the lessons in our education group.
This quick tip shows you 3 ways to insert a worksheet in Excel. Steps to insert a worksheet in 3 ways Below are 3 ways you can insert a worksheet in Excel. Method 1 Firstly, in method 1, we use the main menu and ribbon to insert a sheet. So, there you have it. A […]
How to add a footnote marker to a category in Excel This quick tip shows you how to add a footnote marker to a category in Excel. The short video Below is the short video on adding footnote markers to categories in Excel. Now, you may need to maximize the video, to get the full […]
How to add average line to column chart This quick tip shows you how to add average line to column chart in Excel. Also, you may hear the term “target line” to describe this type of chart. Target line Overall, a target line represents a goal or a particular measuring point. So, your target may […]
This quick how-to video shows you how to add Excel camera tool to quick access toolbar (or QAT). In addition, we took it for a test drive. Video to add Excel camera to QAT One thing to note is, there is a part that jumps directly to Excel options, without seeing the mouse movement. So, […]
This how-to quick snapshot video shows you examples of using For Next statement for basic counting in Excel VBA. Remember, this snapshot is not a full tutorial. How to show basic counting using For Next statement We use Debug.Print to show results of different ways to count numbers from zero to ten. Debug.Print is a […]
This quick how-to snapshot shows you basic Excel operators that you use in spreadsheet development and analysis. Please pay attention to the table and not the chart holder. Overview of basic Excel operators So, the main operators to use in spreadsheets are: assignment, addition, subtraction, multiplication, division, power, and concatenation. Keep in mind, we are […]
This quick video tip shows you how to change cells from night to day in Excel. Change cells from night to day in Excel In this instance, we use a macro to accomplish this task. So, what we do is record the process of selecting all the cells in the sheet. Then, we change the […]
How to create a bar chart in Excel This quick tip shows you how to create a bar chart in Excel. The short video Below is the short video on creating a bar chart in Excel. Now, you may need to maximize the video, to get the full effect of this quick tip. Education home
This quick video tip shows you how to create a blue Pac-man figure in PowerPoint (or PPT). For the purpose of this video, we use PowerPoint version 2203 on a Windows system. However, it should work great in PowerPoint 2007 or higher. Create a blue Pac-man figure in PPT Sometimes, you need to cut loose […]
How to create a column chart in Excel This quick tip shows you how to create a column chart in Excel. The short video Below is the short video on creating a column chart in Excel. Now, you may need to maximize the video, to get the full effect of this quick tip. Education home
Create a face in PowerPoint This quick video shows you how to create a face in PowerPoint (or PPT). Although I was a little messy with certain parts of the video, it is still pretty fun to watch. By the way, I plan to make it possible for you to download some faces too. So, […]
This snapshot how-to shows you how to create formula from math function. Remember, snapshots are just quick snippets or screenshots of a task. How to create formula from math function Below are the step-by-step instructions on turning a basic math function into a workable formula for computing. Feel free to copy this huge image to […]
Want to see everything, well almost everything on Excel Effects?
How-to guides Charting Excel PowerPoint Quick tips Quiz Snapshots VBA Videos Google courses Python courses Question of the day Tech Tuesday
Chart library Area charts Bar charts Bubble charts Column charts Combo charts Donut charts Line charts Math charts Pie charts Scatter charts Sheet charts Special charts
Excel Effects filing and organizational tools for your digital office needs.
Yearly calendar Monthly calendar Project schedule template Templates
Affiliate stuff – Move up and excel with Excel
