Microsoft Excel 2010 Course



Wichtige informationen

  • Kurs
  • Online
  • Wann:
    Freie Auswahl

 Microsoft Excel 2010 is one of the most popular software applications worldwide and is part of the Microsoft Office 2010 productivity suite. This free online course will help you switch to Excel 2010 from a previous version of the software, and will give you a thorough knowledge and understanding of Excel and its applications if you have never used it before. You can use Excel to analyse data, for example, in accounts, budgets, billing and many other areas. You learn how to navigate this revised version of Excel, exploring the menu bar and the different tasks that can be done with it. You will work on sample spreadsheets doing basic math, adding and deleting columns and rows, and preparing the worksheet for printing. You will learn how to represent your data visually to show trends, patterns and comparisons between the data in a chart, table or other template, and how Excel 2010 will automatically do all the calculations for you once you add in the formula. This course will be of great interest to all professionals in business, finance and many other areas that need to analyse data in accounts, or keep records of stock or schedules, and to anyone trying to keep track of their personal finances at home.

Wichtige informationen

Wo und wann

Beginn Lage
Freie Auswahl

Was lernen Sie in diesem Kurs?

Microsoft Excel
Microsoft excel training
MS Excel


Module Title Module 1: Make the Switch to Excel 2010 Module 2: What's New in Excel 2010 Module 3: Basic Tasks in Excel 2010 Module 4: Create Your First Spreadsheet Module 5: Get to Know Excel 2010 - Create Formulas Module 6: VLOOKUP - What It Is and When to Use It Module 7: Understand Data at a Glance with Conditional Formatting Microsoft Excel 2010 - First Assessment Module 8: Sparklines - Use Tiny Charts to Show Data Trends Module 9: Use Excel Tables to Manage Information Module 10: The IF function - What It Is and How to Use It Module 11: How to Create a Basic Chart in Excel 2010 Module 12: Create and Run Macros in Excel 2010 Module 13 : Figure Out Dates by Using Formulas in Excel 2010 Module 14: Plan Payments and Savings in Excel 2010 Module 15: Keyboard Shortcuts Module 16: Microsoft Office 2010 Security Microsoft Excel 2010 - Second Assessment Module 17: Microsoft Excel 2010 - Final Assessment

Study for Free at Your Own Pace! Start This Course

ALISON’s Diploma Courses category includes diploma-level courses in a variety of professional subjects, such as project management, business management and entrepreneurship, HR, web design, psychology, customer service, programming, social media marketing, children’s studies, nursing and patient care, social work, IT management, statistics, mental health, Six Sigma, teaching skills for educators, carpentry, supply chain management, international tourism, and PE. These diploma-level courses will give the learner a comprehensive understanding of the subject. Upon successful graduation, the student will have gained valuable skills and training that will greatly enhance employability and career prospects. The category also includes an innovative work-force re-entry skills advanced diploma that will be of interest to anyone re-entering the workforce after an extended absence.