{"id":748,"date":"2020-05-07T17:12:52","date_gmt":"2020-05-07T09:12:52","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=748"},"modified":"2020-05-07T23:29:31","modified_gmt":"2020-05-07T15:29:31","slug":"easy-excel-analysis-guide","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/easy-excel-analysis-guide\/","title":{"rendered":"Easy Excel Analysis Guide"},"content":{"rendered":"

The Easy Excel Analysis Getting Started Guide<\/h2>\n

getting started<\/a>
\nExplains how to import an Excel or CSV file into an analysis table.<\/p>\n

formatting date and time values in CSV files<\/a>
\nExplains how to import date and time values from CSV files when the format differs from the local machine regional settings.<\/p>\n

importing from multiple Excel worksheets and\/or files<\/a>
\nExplains how you can import data from multiple worksheets and\/or files.<\/p>\n

importing from multiple CSV files<\/a>
\nExplains how you can import data from multiple CSV files.<\/p>\n

using data files<\/a>
\nExplains data files, and how they can be used to share data with other users without having to grant them access to your databases.<\/p>\n

using analysis tables<\/a>
\nExplains how to create groups, summaries, and use charts with your data sets.<\/p>\n

working with copies of the same data sets<\/a>
\nExplains how you can create multiple analysis and pivot tables from the same data set without having to repeatedly run the same query.<\/p>\n

working with analysis table columns<\/a>
\nExplains how to hide and freeze columns, and create multi-row headers in your analysis tables.<\/p>\n

working with charts<\/a>
\nExplains how charts can be used to get a big picture analysis of your data set, and used as a navigation tool to support the analysis table.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

The Easy Excel Analysis Getting Started Guide getting started Explains how to import an Excel or CSV file into an analysis table. formatting date and time values in CSV files Explains how to import date and time values from CSV files when the format differs from the local machine regional settings. importing from multiple Excel […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82],"tags":[83,101],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/748"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=748"}],"version-history":[{"count":4,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/748\/revisions"}],"predecessor-version":[{"id":778,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/748\/revisions\/778"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}