Need Help?
Analytics Vidhya is an well maintained blog with many contributors in the areas of Business Analytics, Business Intelligence, Big Data and Infographics. See their Simple Yet Powerful Excel Tricks for Analyzing Data for useful Excel for analytics advice.
Keep track of Excel enhancements for BA by following their Blog. The entries What’s new for business analytics in Excel 2016 and Take control of data with Excel’s business analytics tools are good places to start.
Search for formulas or solutions to common problems at the Excel support site.
At then Udemy blog, Steve Quartrani does an great job covering basic formulas with his entry Excel Formulas: 10 Formulas That Helped Me Keep My Job.
Excel is the workhorse of basic business analytics. Most large data sets are in excel or excel-compatible formats, and once running in the program, users can easily manipulate and visualize the data.
Creating graphs and charts is as easy as choosing the data within the spreadsheet you want to include, and choosing "Charts" from the "Insert" Menu. A full guide to customizing Excel charts is available from Microsoft here.
Research Sources:
PowerMap is a plug in available to all Excel 2013 and later. It can be found in the "Insert" menu. If you do not see it, there is a guide to ensuring it is enabled here.
For any Excel data set with feographic tags, PowerMap offers quick and easy geographic mapping capabilities. The created maps are customizable, and the application will even create a video of a moving "tour".