Microsoft excel 2010 advanced tutorial. This tutorial has been designed for all those readers who depend heavily on ms excel to prepare charts tables and professional reports. Find and open microsoft excel in windows use microsoft excels menu and toolbar. Office excel 2010 includes a huge array of chart improvements with galleries of predesigned formats you can apply instantly great new 3 d options and a full set of contextual tools that you can use to communicate your message in just the right way. What youll learn learn advanced microsoft excel 2010 from a professional trainer from your own desk.
Begin the process by selecting the data range s you want to chart. A page that covered everything related to microsoft excel 2010 from the basic features to the advanced tips and tricks. Please let the instructor know if you have questions or concerns before the class or as we go along. Ideal for users who learn faster when shown.
It has plenty of screenshots that explain how to use a particular feature in a step by step manner. Advanced excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in microsoft excel 2013. F1 displays the microsoft office excel helptask pane. Altf1 creates a chart of the data in the current range.
136 lectures 85 hours of content teaching you lookups advanced if statements macros sparklines and much more. Suitable advanced excel users. Description ideal for those seeking to enhance their excel 2010 knowledge the learn excel 2010 advanced by simon sez it is a 7 hour training course covering advanced level excel topics. An easy to follow step by step tutorial outlining everything you need to know on excel for the corporate environment.
At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. Learn excel in just a couple hours. You should know that microsoft excel is one of the worlds most popular spreadsheet programs. Ctrlf1 displays or hides the ribbon a component of the microsoft office fluent user interface.
Altshiftf1 inserts a new worksheet. Microsoft has added very powerful tools to excel over previous versions. Welcome to the excel 2010 tutorials info page.