In case it would sync automatically, please don't launch iTunes when running TunesKit iPhone Data Recovery. Upon the startup of the software, choose 'Recover from iOS' mode. At this moment, a window will pop up on your iPhone/iPad/iPod touch. Then TunesKit iPhone Data Recovery for Mac will automatically detect your iPhone/iPad/iPod info.Note: To avoid any problem during the recovery process, you are highly suggested to upgrade your iTunes app to the latest version in advance. Tap the 'Trust' option to authorize the computer so that the iPhone Data Recovery could be able to access to the data of your device.Then launch TunesKit Data Recovery for iPhone on Mac.
Manual Excel Macros
1.
Excel data cleaning and Pivot Tables —Cleaning Data in Excel, by Maarten Lambrechts —Pivot Tables 1 —Pivot Tables 2 WEEK 2 Wrangling data with Data Wrangler and Exploring data with visualizations in INZight All videos and data are inside this folder. To read about the techniques I explain in them, read The Truthful Art, chapters 5-9.
Mac OS macOS High Sierra v10.13 macOS Sierra v10.12 OS X El Capitan v10.11 Word Microsoft ® Word 2016 for Mac Microsoft ® Word for Mac 2011 Excel Microsoft® Excel® 2016 for Mac Microsoft®Excel® for Mac 2011 PowerPoint Microsoft® PowerPoint ® 2016 for Mac Microsoft®PowerPoint ® for Mac 2011 Outlook Microsoft ® Outlook® 2016 for Mac. Microsoft's annual giveaway of ebooks is on again. Thousands of free downloads, including Office related ebooks. The full list is on the Microsoft blog. We've copied the Microsoft Office related titles into a easily searchable list below. Microsoft Word, Excel, and Outlook. Share notes by using email, Microsoft OneDrive, and SharePoint. Look up just the tasks and lessons you need The quick way to learn Microsoft OneNote! Easy numbered steps Colorful screenshots Helpful tips and pointers IN FULL COLOR! Step by Step Curtis Frye PRACTICE FILES Celebrating over 30 years.
I generate base graphics in programs such as Flourish, iNZight, RAWgraphs, Data Illustrator, QGIS, etc.2.I export these as vector files, open them up in Illustrator, style them, and arrange the final compositions there.
3.Finally, I use ai2html to export the Illustrator file if I'm going to show it online. If it's a print project, I save it as a PDF.
4. If I use Flourish and the output is an interactive graphic, I do the styling and exporting in it.
This diagram summarizes this process, showing most of the tools I explain in my introductory courses (click to maximize):
The videos I've recorded myself are in DropBox folders and they are not compressed. Why? Because I'm giving you permission to use them at will in your own classes. You decide whether to compress them for your own purposes or not.
I recommend not to play these DropBox videos in your browser, but to download them first to your computer. Then, if you have trouble opening them, try a player like VLC, which is safe and free.
WEEK 1
Excel data cleaning and Pivot Tables
—Cleaning Data in Excel, by Maarten Lambrechts
—Pivot Tables 1
—Pivot Tables 2
WEEK 2
Wrangling data with Data Wrangler and Exploring data with visualizations in INZight
All videos and data are inside this folder. To read about the techniques I explain in them, read The Truthful Art, chapters 5-9.
Data Wrangleris an old but very simple tool that lets you transform data in wide format into long (or 'tidy') format.
INZight is a powerful and easy to use free tool for data discovery.
WEEK 3
Adobe Illustrator basics
—
—Lesson 2: Elementary shapes
—Lesson 3: Compositions in Illustrator
—Lesson 4: Charts and maps in Illustrator
Manual Excel Macros
1.
Excel data cleaning and Pivot Tables —Cleaning Data in Excel, by Maarten Lambrechts —Pivot Tables 1 —Pivot Tables 2 WEEK 2 Wrangling data with Data Wrangler and Exploring data with visualizations in INZight All videos and data are inside this folder. To read about the techniques I explain in them, read The Truthful Art, chapters 5-9.
Mac OS macOS High Sierra v10.13 macOS Sierra v10.12 OS X El Capitan v10.11 Word Microsoft ® Word 2016 for Mac Microsoft ® Word for Mac 2011 Excel Microsoft® Excel® 2016 for Mac Microsoft®Excel® for Mac 2011 PowerPoint Microsoft® PowerPoint ® 2016 for Mac Microsoft®PowerPoint ® for Mac 2011 Outlook Microsoft ® Outlook® 2016 for Mac. Microsoft's annual giveaway of ebooks is on again. Thousands of free downloads, including Office related ebooks. The full list is on the Microsoft blog. We've copied the Microsoft Office related titles into a easily searchable list below. Microsoft Word, Excel, and Outlook. Share notes by using email, Microsoft OneDrive, and SharePoint. Look up just the tasks and lessons you need The quick way to learn Microsoft OneNote! Easy numbered steps Colorful screenshots Helpful tips and pointers IN FULL COLOR! Step by Step Curtis Frye PRACTICE FILES Celebrating over 30 years.
I generate base graphics in programs such as Flourish, iNZight, RAWgraphs, Data Illustrator, QGIS, etc.2.I export these as vector files, open them up in Illustrator, style them, and arrange the final compositions there.
3.Finally, I use ai2html to export the Illustrator file if I'm going to show it online. If it's a print project, I save it as a PDF.
4. If I use Flourish and the output is an interactive graphic, I do the styling and exporting in it.
This diagram summarizes this process, showing most of the tools I explain in my introductory courses (click to maximize):
The videos I've recorded myself are in DropBox folders and they are not compressed. Why? Because I'm giving you permission to use them at will in your own classes. You decide whether to compress them for your own purposes or not.
I recommend not to play these DropBox videos in your browser, but to download them first to your computer. Then, if you have trouble opening them, try a player like VLC, which is safe and free.
WEEK 1
Excel data cleaning and Pivot Tables
—Cleaning Data in Excel, by Maarten Lambrechts
—Pivot Tables 1
—Pivot Tables 2
WEEK 2
Wrangling data with Data Wrangler and Exploring data with visualizations in INZight
All videos and data are inside this folder. To read about the techniques I explain in them, read The Truthful Art, chapters 5-9.
Data Wrangleris an old but very simple tool that lets you transform data in wide format into long (or 'tidy') format.
INZight is a powerful and easy to use free tool for data discovery.
WEEK 3
Adobe Illustrator basics
—Lesson 1: Basic skills
—Lesson 2: Elementary shapes
—Lesson 3: Compositions in Illustrator
—Lesson 4: Charts and maps in Illustrator
—Lesson 5: The pen tool
NOTE: If you want to learn more about Illustrator, consider purchasing my 12-hour tutorial.
WEEK 4
Data Illustrator
Manual Excel Macros Pdf
This tutorial is by Data Illustrator's co-creator John Thompson.Data Illustratoris a tool that greatly expands on the charting capabilities of tools such as Adobe Illustrator.
All videos and data are in this folder.
WEEK 5
Flourish
Flourish is a tool to design both interactive and static data visualizations. It's quickly becoming one of my favorites. All the videos and data are inside this folder.
WEEK 6
RAWgraphs
RawGraphs is a wonderful tool that lets you create graphs and charts that you can later style in Illustrator or InkScape. Here is a tutorial designed by the RawGraphs team.
WEEK 7
Styling charts with Adobe Illustrator
After designing your charts with INZight or Raw, you should change their style to make them more elegant. Adobe Illustrator can help with that.
—Videos: 1, 2, 3, 4
WEEK 8
Using AI2HTML to export Adobe Illustrator infographics as HTML files
This tutorial is by Luís Melgar.
—Download the files
—Videos: 1, 2, 3, 4
MORE VIDEOS COMING SOON
Other resources
—A great introduction to QGIS
—My personal collection of R resources
Manual Excel Mac
—My complete Illustrator video tutorial
More about Pivot Tables:
—Using Excel Pivot tables (Mac version): Six videos on YouTubeand the data used
—See also this short explanation of Pivot Tables
—Another (longer) tutorial about Pivot Tables