You are here:Courses|Microsoft Office|Excel|Excel: Intermediate

Excel: Intermediate

Course Objective:

This course is designed for learners who wish to upgrade their current knowledge of Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets. They will also be able to perform calculations and functions within a workbook, manipulate tables and how to add nuances that will enable the user to maintain and present data in a visually stimulating manner.

Overview of Course:

Upon successful completion of this course, learners will be able to:

  • Advanced File: Tasks This section teaches students how to use the Open and Save dialogs to create new files and folders. It also covers file types that are compatible with Excel, how to work with older file formats, and how to protect their workbook against accidental or intentional changes to the data. Finally, this section will discuss the many file management tools and checkers that are used to scan workbooks for personal information and compatibility issues.
  • Working with Functions and Formulas: In this section, participants will learn how to properly reference cells, use mathematical operators, and how to check their formulas for errors. This section also covers how to browse, insert, and use functions to perform complex mathematical operations. Students will learn how to use the IF function, use nested functions to perform multiple operations, and define and use range names. Finally, array formulas will be discussed.
  • Managing Tables: Tables are an important part of Excel because they inherently contain a lot of useful functionality, including sorting and filtering. This section teaches participants how to add and edit tables, edit table information, perform sort and filter operations, and even how to use Excel as a database.
  • Adding the Finishing Touches: This section details how to round off a spreadsheet by discussing how to check spelling and use the research pane to look up words, facts, and figures. Students will learn how to apply and use theme effects and create text boxes, pictures, and Clip Art. Basic image editing will also be discussed.
  • Showing Data as a Graphic: This final section will show how to turn data into informative visual aids. Students will learn how to add and edit SmartArt; how to add symbols, special characters, and equations; and also how to add and edit shapes. Finally, the new Sparkline feature will be discussed, showing participants how to add, edit, and customize these useful graphs-in-a-cell.

Prerequisites:

This course is designed for those users learners who process a working knowledge and understanding of the concepts covered in the Excel Foundation course

Related items

Price & Other Information

  • Course Price $150
  • Duration 6 Hours
  • Class Type Public, Group, Individual
  • Next Course:

    No Upcoming Dates - Contact Us for More Info

  • Other Info:

    Contact Us To Book A Class





Microsoft Office

Skillshare

Other Curriculum

MS Office Courses

Our Number

Phone: 917.796.0861

Our Email

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Software Amortas

Empowerment Through Learning

Proper training is the cornerstone of the successful implementation of a company's business objectives and mission. Presentation Guru is a training firm that specializes in customized Microsoft Office, project management, website, graphics and proprietary training for law firms, ad agencies, city agencies, small businesses and individuals.

As technology continues its dynamic evolution, PresGuru's Technical Training team offers innovative and diverse training solutions for the specialized methods that are necessary to meet current business needs, and for an individual's professional development goals. Our team believes in empowerment through learning. We have spent years cultivating knowledge transference formulas for the adult learner that enhances the comprehension and retention of learning objectives.