Microsoft Excel level 3 IT & Business Consulting Group

Course details

Audience Profile

  • This course is intended for novice information workers who want to learn advanced-level Excel 2010 skills.

At Course Completion

After completing this course, students will be able to:

  • Define an alternative data set.
  • Define multiple alternative data sets.
  • Vary your data to get a desired result by using Goal Seek.
  • Find optimal solutions by using Solver.
  • Analyze data by using descriptive statistics.
  • Analyze data dynamically by using PivotTables.
  • Filter, show, and hide PivotTable data.
  • Edit PivotTables.
  • Format PivotTables.
  • Create PivotTables from external data.
  • Create charts.
  • Customize the appearance of charts.
  • Find trends in your data.
  • Summarize your data by using sparklines.
  • Create dynamic charts by using PivotCharts.
  • Create diagrams by using SmartArt.
  • Create shapes and mathematical equations.
  • Enable and examine macros.
  • Create and modify macros.
  • Run macros when a button is clicked.
  • Run macros when a workbook is opened.
  • Include Office documents in workbooks.
  • Store workbooks as parts of other Office documents.
  • Create hyperlinks.
  • Paste charts into other documents.
  • Share workbooks.
  • Manage comments.
  • Track and manage colleagues’ changes.
  • Protect workbooks and worksheets.
  • Authenticate workbooks.
  • Save workbooks for the Web.

About IT & Business Consulting Group

Whether you need a one-day onsite training course, full-service consulting, or if you are not really sure which solution will work, we can help.
ITBCG is a leading and innovative learning provider with over twenty years’ experience of providing best in-class learning solutions. We work in partnership with our customers to deliver flexibility, value and service. We develop innovative programs to ensure that every aspect of the learning development, delivery and administration of courses work to our clients’ benefit.
We provide IT and business skills learning to both the private and public sector companies and organizations. Our core training is focused on Cisco, Microsoft, CompTIA Citrix, EC-Council, Oracle, and ISC2 and best practice. This includes ITIL® Service Management and ISO, and PMI which is tied into business process improvement, project management, and business analysis and leadership development.
See all IT & Business Consulting Group courses

Contact information not available.

Are you from IT & Business Consulting Group ? Claim your course!
Courses you can instantly connect with... Professional Diploma in Microsoft Office Exceligent Academy Certificate in Accounting by Excel Exceligent Academy Managing Office 365 Identities INFORM

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?