Description

Excel is used in practically every business and in nearly all departments in those businesses ranging from sales to accounting and administration. Manyroles will require you to be proficient to this level.The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will help you to create accurate worksheets and stand out from the crowd.Work with multiple worksheets at the same timeLearn how large workbookswork and trace errorsUsingtheLOOKUP functionare very useful, butcan sometimes be a bit tricky so let’s demystify and master them.Sparklinesare small in cell charts. Learn how they allow you to compare data in a visual way and when they are better than Charts.Automate some repetitive tasks in Excel with macros.If you have historical time-based data, you can use it to create a forecast.This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.