From Spreadsheet to Dashboard: How Microsoft Excel is Enabling Better Decision-Making for Businesses
Business professionals have long relied on Microsoft Excel as their go-to application for data management, analysis, and reporting. Excel...
top of page
New Excel Classes start every week at 10am EST M-F
Derek Burrows-Johnson
- Mar 17
- 1 min
5 Essential Excel Tricks for Mastering GPT-4 Chatbot Training
Conditional Formatting: With Conditional formatting, you can color-code and highlight particular cells, columns, and rows in your excel...
Derek Burrows-Johnson
- Mar 6
- 2 min
Why AI Is the Future of Excel and Data Analytics
Data analytics is now an essential component of decision-making across industries in today's data-driven environment. The spreadsheet...
Derek Burrows-Johnson
- Jan 30
- 2 min
Protecting Your Work: How to Mark Your Excel Workbook as Final
When it comes to your Excel workbooks, it's important to protect the integrity of your data. One way to do this is by marking the...
Derek Burrows-Johnson
- Jan 20
- 2 min
Excel Macros with ChatGPT
The new AI tool is a powerful tool and can help produce macros in your Excel tables to automating data entry or data cleaning tasks,...
Derek Burrows-Johnson
- Dec 30, 2022
- 2 min
Getting Started with Power View
HOW DO I GET POWER VIEW? First it's important to know you will need to add Power View in the Excel options tab before starting. See...
Derek Burrows-Johnson
- Dec 30, 2022
- 2 min
IF Function
WHAT IS IT? The IF function in Excel is a powerful tool that allows users to perform conditional logic in their spreadsheets. It allows...
Derek Burrows-Johnson
- Dec 17, 2022
- 1 min
Quick Analysis in Excel Using Charts
Select a range of cells. Select the Quick Analysis button that appears in the bottom right corner after the data is selected. You can...
Derek Burrows-Johnson
- Dec 16, 2022
- 1 min
How to Use Flash Fill in Excel
Flash Fill in Excel is a tool that detects patterns in your data and fills in information to save you time. So for example in the columns...
Derek Burrows-Johnson
- Dec 16, 2022
- 1 min
VLOOKUP - How and When to Use It
VLOOKUP function is used when a person is trying to find a piece of information in a large set of data In the Formula Bar, type...
Derek Burrows-Johnson
- Dec 9, 2022
- 1 min
Formatting or Modifying a Cell in Excel
Format Cells Select the cells. Go to the ribbon and select one of the options such as Bold, Font Color, Font Size. Apply Excel Styles...
Derek Burrows-Johnson
- Dec 9, 2022
- 1 min
Create a Chart in Excel - Visualize your Data
Select the data in the chart you want to visualize Select Insert > Recommended Charts Select the chart you'd like to preview on the...
Derek Burrows-Johnson
- Dec 2, 2022
- 1 min
The Complete Excel Shortcut Keys Guide
Ctrl + Shift + ; Enter the current time Ctrl + ; Enter the current date Alt + Shift +F1 Insert new worksheet Shift + F3 ...
Derek Burrows-Johnson
- Nov 30, 2022
- 1 min
Creating a PivotTable
Select the cells you want to create the PivotTable from Select Insert>Pivot Table 3. Once you click this, it will create a PivotTable...
Derek Burrows-Johnson
- Nov 28, 2022
- 1 min
Data Sorting in Excel - Essential Excel skills series
1. Select a cell with the data. 2. Select Home>Sort & Filter 3. Select one of the following options: Sort A to Z - Sorts the selected...
Derek Burrows-Johnson
- Nov 26, 2022
- 1 min
Creating Data Filters in Excel - The most important Excel skill
FILTER A RANGE OF DATA 1. Select any cell on your table within the range 2. Select DATA and then FILTER 3. Select the column header arrow...
Derek Burrows-Johnson
- Nov 15, 2022
- 4 min
20 NEED TO KNOW EXCEL SKILLS FOR WORK
DATA FILTERS In Excel, data filters allow you to create complex queries and extract actionable insights from your workbook. When you know...
Derek Burrows-Johnson
- Nov 10, 2022
- 2 min
The rise of online courses since COVID
Since Covid started in late 2019, there's been a trend in people taking courses online. The trend is that it's much easier to learn...
Derek Burrows-Johnson
- Nov 3, 2022
- 2 min
Excel is the most in demand workplace skill
Excel skills are important in the workplace because they are necessary for data tables. With these skills, companies can have trained...
James Dupuis-Howard
- Oct 30, 2022
- 2 min
Upgrade your conditional formatting game
Most people think conditional formats is a very limited tool that only lets you edit some colors for simple things. In reality,...
bottom of page