Excel Training logoExcel Training Course
in San Francisco

We offer a 1-day beginner, 1-day intermediate and a 1-day advanced Excel training course in San Francisco

We currently offer public Excel training courses in San Francisco and in many cities around the country. Private course are available on-site, online or at a venue in city near you. Please click on the schedule link above to see a complete list of our Excel courses including Excel courses offered in San Francisco.

You can register for these courses by clicking on the link at the top of this page or by clicking on the register link next to the scheduled dates on the right.

One on OneWould you prefer to take a private Excel course at the same cost, with one of our certified instructors on dates suited to your schedule? Click here for more information.

Our Excel training and support team have over 10 years experience developing and teaching Microsoft applications.

We can also offer custom Excel training courses and consulting which can be tailored and targeted specifically to you and your staff in San Francisco. Please contact our Excel training and support team at training@americanmediatraining.com for more information regarding our Excel courses in San Francisco.

Excel Logo   Excel Beginner Class

Microsoft Excel is the premier software application for creating, editing and sharing spreadsheets, with countless practical applications, from financial reporting and general record keeping to operations management and decision support. As a part of this Microsoft Excel 2007/2010 training, you will create an Excel spreadsheet, use it track several types of data, use Excel to perform calculations on spreadsheet data, and generate professional, presentation-ready graphs and charts that show statistics, trends, and forecasts. Our Microsoft Excel classes have been crafted to help you develop skill with both Excel 2007 and Excel 2010. This Excel class emphasizes practical exercises and real-world examples, so that you will leave training ready to apply your new knowledge right away.

View Outline...

Microsoft Excel Course outline

Navigating Spreadsheets with Confidence and Speed

  • Understand spreadsheet terminology, including worksheets, workbooks, columns, rows and cells.
  • Work efficiently with Excel's tool ribbons, gallery commands, and Live Preview feature.
  • Master shortcuts to quickly navigate through multiple pages of data.


Entering and Editing Text and Formulas

  • Use AutoFill to complete the entry of sequential data with a minimum of errors.
  • Perform basic calculations and use cell references to apply calculations accurately.
  • Understand and use cell references to apply calculations accurately throughout a spreadsheet.
  • Search for specific data and replace data selectively or globally.


Formatting Cells and Tables For Clarity and Visual Impact

  • Use styles and style galleries to quickly format cells, tables and entire worksheets.
  • Apply conditional formatting rules to visually enhance your data.
  • Automatically display numbers as percentages, currencies, fractions, dates or in the format of your choice.


Printing Spreadsheet Data for Professional Appearance

  • Avoid multiple printing attempts by adjusting margins and sizing in Page Layout View.
  • Control page breaking and print options to print the desired number of pages.
  • Define the print area to exclude unwanted data from your printout.


Creating Professional-Looking Charts

  • Create dynamically-updating charts quickly with predefined layouts and styles.
  • Modify chart components manually to graphically display information, to meet your specific requirements.
  • Easily change chart types, without modifying the data.
  • Use visual effects to design compelling graphic summaries and accentuate key data.


Managing and Navigating Large Workbooks

  • Freeze row and column headings in place so that they will always appear when scrolling.
  • Divide a larger worksheet into smaller, more manageable panes.
  • Hide columns and rows, as needed, to emphasize key data.
  • Define page breaks at logical points in your spreadsheet.


Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Excel Logo   Excel Intermediate Class

With an impressive array of automated functions and tools to display data graphically, Microsoft Excel is the premier spreadsheet software application used by businesses, organizations and professionals worldwide. Microsoft Excel 2007/2010 training covers the powerful set of features which will enable you to accomplish more with this industry-standard application. Our Microsoft Excel classes have been crafted to help you develop skill with both Excel 2007 and Excel 2010. As a result, this hands-on class will prepare you to link workbooks to manage larger data sets, employ advanced formatting techniques on tables and charts, create custom filters to target specific data for analysis and allow multiple users to work on a spreadsheet while protecting critical data from deletion. Your instructor brings a wealth of experience using these advanced Excel techniques, and will work with you to make sure you leave class with a new set of skills ready to apply immediately.

View Outline...

Microsoft Excel Course outline

Linking Workbooks to Manage Large Interconnected Data Sets

  • Use 3-D formulas to link multiple workbooks.
  • Reference cells and ranges in other workbooks accurately ... on the first try!
  • Implement best practices for easy maintenance of linked workbooks.


Formatting Techniques: Beyond the Basics

  • Combine functions and styles to format text.
  • Automatically standardize the display format of numbers and text.
  • Apply a theme for a consistent appearance between spreadsheets and other Microsoft Office documents and presentations.
  • Quickly convert a row into a column and vice versa.
  • Add background images and watermarks to a spreadsheet.


Managing and Manipulating Table Data

  • Consolidate lists into collapsable outlines for simplified viewing.
  • Target specific data for analysis with sorting and filtering
  • Create powerful data filters with multiple criteria.
  • Maintain data integrity with data validation and structured references.


Using Advanced Chart and Graphing Options

  • Understand the powerful (and complex) chart formatting options.
  • Create custom charts which combine two or more chart types.
  • Make important features in charts stand out by including graphic elements.


Auditing, Collaborating and Securing Spreadsheet Data

  • Test formulas and trace errors with Error Checking and Auditing tools.
  • Include cell comments for increased usability and collaboration.
  • Prevent accidental or deliberate data deletion by protecting specific portions of a workbook.
  • Permit multiple users to edit a spreadsheet simultaneously, without creating inconsistencies.


Creating, Modifying and Using Excel Templates and Settings

  • Quickly find the best built-in spreadsheet template for your needs.
  • Design Excel templates with scalability and usability in mind.
  • Understand how application settings affect Excel's functioning.


Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Excel Logo   Excel Advanced Class

Take your Microsoft Excel skills to new heights with our Advanced Excel course, which continues where the Excel 2007/2010 Intermediate course left off. Our Microsoft Excel classes have been crafted to help you develop skill with both Excel 2007 and Excel 2010. As a result, you will accomplish more by taking full advantage of Excel's power: more powerful calculations, more effective data analysis, more time saved with automated routines, more successful data presentations - make sure you know exactly what Excel can do for you.

View Outline...


Advanced Functions in Excel

  • Automate your work with logical functions (IF, AND, OR, NOT, IFERROR) that calculate values based on criteria you specify
  • Apply math and statistical functions to calculate conditional sums and averages
  • Use financial functions, such as the PMT function, which calculates loan payment amounts


V Lookups and Data Tables in Excel

  • Create lookup functions to find exact or approximate matches in lists of data
  • Use the MATCH function to determine a specified value's relative position in a list
  • Use the INDEX function to return a value based on a specified cell in a range
  • Create "what-if" scenarios with one-variable and two-variable data tables


Advanced List Management in Excel

  • Set up cells to accept only valid dates, whole numbers, or other valid values you specify
  • Use database functions to summarize values that meet complex criteria, for example, the total sales in a specific region for a specific year


Excel PivotTables and PivotCharts

  • Create and use interactive PivotTables to analyze and compare large amounts of data from your workbooks or from external databases
  • Make a PivotTable easier to read with effective automatic formatting
  • Create a PivotChart to graphically display PivotTable data


Exporting and Importing within Excel

  • Export your Excel data to a text file that can be read by other programs
  • Import data from a text file and organize it automatically into appropriate columns
  • Easily remove duplicate rows from your imported data
  • Create an XML map that maps your Excel data to an XML schema
  • Use Microsoft Query to access data in external databases
  • Set up a Web Query to automatically pull data such as online currency quotes or stock quotes from the web


Analytical Options

  • Perform a simple one-variable "what-if" analysis using the Goal Seek utility
  • Perform complex "what-if" analyses with multiple variables using the Solver utility
  • Expand your data analysis capabilities with the tools in the Analysis ToolPak, including Random Number Generation, Histogram, Regression, Sampling tools and many more
  • Simplify your budget planning by creating and easily switching between Scenarios
  • Save time by saving Views with different worksheet display and print settings


Macros & Custom Excel Functions

  • Determine when a macro makes sense
  • Record and run macros that work for you
  • Enable and disable macros in a spreadsheet
  • Make changes to existing macros using the Visual Basic Editor
  • Create custom functions for your business, for example, a Profit function with sales and cost arguments


Conditional Formatting and SmartArt

  • Use data bars or icon sets to graphically display how different cell values compare to each other
  • Communicate with color by setting up color scales to automatically format cells depending on their values
  • Get your message across by inserting and customizing SmartArt graphics


Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Sorry at this time we have no public San Francisco Level One courses scheduled, please call or email us to see if we can arrange a private course for you. training@americanmediatraining.com

Microsoft Certified Expert

Microsoft Certified Instructor




Excel training courses offered all cities

Course Start Date Duration Cost Register
Excel level 1 beginner course Training Courses in Chicago 8/29/2019 1 days $350 Register
Excel level 2 intermediate course Training Courses in Chicago 8/29/2019 1 days $350 Register
Excel level 3 advanced course Training Courses in Chicago 8/29/2019 1 days $350 Register

We can offer you customized on-site training courses in Excel wherever you are in the USA:

Atlanta, Chicago, Los Angeles, Denver, Miami, Philadelphia, Orlando, Charlotte, Houston, Richmond, Washington DC, New York, Boston, Columbus, Cincinnati, Memphis, Indianapolis, Baltimore, Dallas, Austin, Phoenix, Albuquerque, Las Vegas, Salt Lake City, Seattle, Portland, San Francisco, San Diego, Long Beach, Sacramento, St Paul/Minneapolis

We also provide Excel training courses in the following cities:

Excel training courses in Los Angeles
Excel training courses in Denver
Excel training courses in Minneapolis
Excel training courses in San Francisco
Excel training courses in Phoenix
Excel training courses in Boston
Excel training courses in Salt Lake City
Excel training courses in Philadelphia
Excel training courses in Miami
Excel training courses in Portland
Excel training courses in Chicago
Excel training courses in New York
Excel training courses in Dallas
Excel training courses in Houston
Excel training courses in San Diego
Excel training courses in Kansas
Excel training courses in Cleveland

©Copyright 2002 - 2014 American Media Training