Today, Excel Ignited and SSSVEDA Day 10, I show beginners that Pivot Tables are available to them. Pivot Tables aren’t an intermediate-level tool.
The issue with Pivot Tables is that they require proper spreadsheet layout and an understanding of what’s being asked of the data. Then, Excel’s Pivot Table wizard takes care of the rest.
DIVE IN!
My book: Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog-2-2
In Day 9 of Excel Ignited and SSSVEDA I share some thoughts on how we’ll be going forward through the rest of this month. Rather than teach tips and tricks, we’ll learn by integrating Excel features and data management concepts.
Tips & tricks feel too much like the painful way that my dad and other old jazz musicians learned their craft. No! Let’s actually “make some music” and borrow ideas that have stuck with me since 2005 when I attended Victor Wooten’s Bass/Nature Camp.
My book: Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog-2-2
Day 6 of Excel Ignited (Illumintating Excel for Beginners) we look at the symbols in Excel formulas.
$ : , ^
What do they mean? What are they doing?
In this video I go through those one at a time.
My book: Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog-2-2
Just 5 days into the “Vlog Every Day” challenge and I wanted to let you know I needed a break. A video a day … WOW! This is going to be a battle. But we’re going to do it.
I just needed to reassess how to pace the content creation over these next few weeks.
My book: Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog-2-2
Day 4 of Excel Ignited (Illuminating Excel for Beginners), Today: The IF Function. This is one of what I consider Excel’s primary colors because these 3 things can take a beginner a long long way:
– Filter
– Sort
– IF function
This video provides an extensive explanation of the IF funtion and wraps up with an example of a nested IF statement.
Mentioned in this video is the new IFS function.
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog-2-2
Day 3 of SSSVEDA and Excel Ignited: Introduction to Excel Formulas and Functions
The month of August 2016 is dedicated to Excel Beginners.
Video on Absolute and Relative Cell References
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog-2-2
Day 2 of Excel Ignited and SSSVEDA: Overview of the Excel Ribbon.
Here I cover each of the main tabs, showing the most important features that an Excel beginner should know, and I point out features that are more advanced or specialized.
The video includes brief demos of key Excel features, including: conditional formatting, sort, filter, Find/Replace, and number formatting.
Chris Macro’s survey of how professionals use Excel’s Quick Access Toolbar:
VIDEO TIMELINE
2:35 Opening Excel
4:00 Pinning a working to the Recent menu
5:01 Changing the Office Theme to black
6:00 The Home tab
6:10 Format Painter
7:08 Change font
7:44 Cell Borders
8:07 Cell Alignment
8:25 Wrap Text
8:50 Number Formats
9:30 Conditional Formatting
10:44 Format as Table
12:18 Insert Row/Column
12:49 Find and Replace
13:54 The Insert Tab
13:59 Pivot Table
14:50 Insert Shapes
15:13 Insert Charts
15:28 Slicers
16:00 Text Box, Word Art
16:45 The Draw Tab
17:08 The Page Layout Tab
17:14 Margins, Orientation
17:38 Scale to Fit (controlling how many pages a worksheet prints out on)
18:37 Turn off grid lines
18:49 Aligning objects
20:00 The Formulas Tab
20:45 Formula Evaluator
21:03 The Data Tab
21:03 Get & Transform
21:34 Sort, Filter
25:22 Text-to-Columns
25:43 Flash Fill
26:45 Data Validation: Drop Down Lists and other ways to prevent input of bizarre data
28:26 The Review Tab
28:26 Sheet and Workbook Protection
29:06 The View Tab
29:06 Show or hide: Page breaks, Page Layout, Formula Bar, Headers
29:30 Freeze Panes
29:44 The Developer Tab
29:44 VBA window and Form Controls
30:26 The Quick Access Toolbar (QAT)
31:40 Chris Macro’s QAT Survey
31:52 Closing Summary
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog-2-2
“What is Excel?”
I’ve been asked this over the years by people who are curious about Excel or want some insight into what Excel can do.
Answering the question is difficult because of the endless ways that people have used Excel to serve their needs.
In this video I answer “What is Excel?” several ways, in summary:
– Excel is a development platform for managing data
– Excel is the second best software for ANY purpose
– Excel is just a tool that serves a purpose.
This video is Day 1 of 31 days of videos as part of #SSSVEDA: Vlog Every Day in August (VEDA). The SSS part is Amy Schmittawer’s SavvySexySocial
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog-2-2