This course will take you from the very basics of Excel 2016 Introduction to the advanced options of it. Excel is a crucial skill for every stream of work, whether that is Marketing, Accounting, Engineering, Social Research, Data Storage, Data Analysis, Forecasting, Reporting or Visualizations. Here I do not intend to teach any of the tips and tricks that may give you the upper hand in your work, but to get inside how to use options available in excel and how you can use them to fulfill your purpose. All lessons have practical data attached to them as a resource so that you can use it wherever needed. Course will give you insight about Excel 2016 and every topic discussed into this course is supported with practical use with practic data. To Master Excel Skills you may needs to go through each of the topics severl times. Videos also show the presentation as I make reading of them, you can pouse the video and go through the discription at your own and you can also download presentation attached to each leacture as downloadable resource. IntroductionExcel Navigation BasicsBest Ways to Enter and Edit DataBasic Worksheet OperationsFormatting WorksheetsAuditing, Validating, and Protecting Your DataUsing Hyperlinks, and Working with the Status BarImporting DataEnhancing Workbooks with MultimediaExcel TemplatesPrinting Your WorkWorking with TablesMastering ChartsMastering Pivot Table and Pivot ChartsMastering PowerPivotMastering Excel MacrosExcel Short Cuts
