# Data Analyst Skills

## 14 Best Tableau Courses Online (April 2024)

Choosing the right Tableau course is important. You need a well-structured course that’s broad in scope, engaging, and requires a reasonable time commitment. In this guide, I ranked and reviewed the 15 best Tableau courses, as well as our top 5 picks so you can choose the one that’s best for you. Best Overall (LinkedIn […]

## How to Use Excel Without a Mouse (32 Shortcuts)

If you’re a data analyst, a business analyst, a financial professional (or anyone who uses Excel for that matter) then you know the feeling of wanting to move faster in Excel. Nobody likes to get bogged down clicking buttons with the mouse while their train of thought moves forward. In addition, the further you progress

## F2 Key Toggle Between Edit, Enter, & Point Mode: Using Arrow Keys to Navigate Cells in LibreOffice Calc

If you’re used to navigating Excel spreadsheets with the F2 key and arrow keys, the switch the LibreOffice Calc can be tough. While most standard functionalities are the same between the two spreadsheet applications, many of the nuanced shortcuts that Excel formula warriors are accustomed to don’t transfer. Unfortunately, the F2 toggle function is one

## Filter On Two Substring Values With STARTSWITH() in Tableau

Last week, I was working on an accounting exercise in Tableau in which I needed to filter a trial balance for all accounts starting with “6” and “7.” Where I work, these are the accounts present on the profit and loss statement. The first thing I did was look at the wildcard filter settings, since

## How to Set the Total Bar in an Excel Waterfall Chart

If you’re anything like me, you can’t use waterfall charts enough. They’re the ideal visualization of the addition and subtraction of values from a total over time. In Excel, there’s a really simple way to create waterfall charts. However, getting/setting total columns? Not so easy. Total columns are essential to waterfall charts. Yet for some

## 4 Top Data Analyst Skills (That You Can Learn Right Now)

When I started learning data analysis, I had a mentor who taught me not to think about learning skills, but about learning the data treatment cycle. The data treatment cycle is cleaning, exploring, visualizing, & analyzing. When we think about skills as parts of these steps, it’s much easier to understand why we learn them,

## Data Analysis for Qualitative Research: 6 Step Guide

Data analysis for qualitative research is not intuitive. This is because qualitative data stands in opposition to traditional data analysis methodologies: while data analysis is concerned with quantities, qualitative data is by definition unquantified. But there is an easy, methodical approach that anyone can take use to get reliable results when performing data analysis for

## Qualitative Content Analysis: a Simple Guide with Examples

Content analysis is a type of qualitative research (as opposed to quantitative research) that focuses on analyzing content in various mediums, the most common of which is written words in documents. It’s a very common technique used in academia, especially for students working on theses and dissertations, but here we’re going to talk about how

Scroll to Top