MS Excel Training in San Diego
Microsoft Excel is a program used most often for processing calculations on data. It can be used for budgets, timesheets, financial data, calendars, lists, charts, graphs, and much more. The training is conducted by instructors with extensive real-world experience who can help you rapidly master the essentials. This class is recommended for anyone who hasn't worked with formulas or charts before or those with little or no experience with Excel. Great refresher course for students who haven't used Excel in a long time.
Learn how to navigate the Excel user interface and customize the Quick Access Toolbar to include your favorite commands. Learn keyboard shortcuts that will speed up common tasks. Spreadsheet design principles and "best practices" will also be covered, along with lots of tips and tricks to make Excel easier to use.
Use AutoSum to add numbers and formulas to perform basic calculations: Add, subtract, multiply, divide numbers, calculate percentages, and averages. Use the Fill feature to copy formulas. Much of the class will be devoted to creating formulas.
Formatting and Editing Spreadsheets
Format text and numbers, add borders and background colors to cells. Learn the 6 most common number formats, including currency and percentages. Select, copy, move, format, and delete text and numbers. Insert and delete sheets, columns, and rows. Resize columns and rows. Sort data. Add graphics and SmartArt diagrams, rename a spreadsheet tab, change tab colors, etc.
Charts and Graphs
Create and edit a variety of different charts, including Pie, Column, and Line Charts. Change the chart type, apply Styles and Layouts options, format individual elements in a chart, etc. Create Sparkline charts (mini charts that occupy a single cell).
Working with Large Spreadsheets
Use Freeze Panes so column and/or row headings always remain visible as you scroll. Hide / unhide columns and / or rows. Learn about various printing options, including how to fit everything on one page. Make titles (column headings) print on every page. Add headers and footers, page numbers, logos, etc.
Learn a few common functions:
- Average (average a range of cells)
- Max (display the highest number in a range of cells)
- Min (display the lowest number in a range of cells)
- Sum (sum or total of a range of cells)
Transpose data (switch columns and rows), fill in word, date, and number patterns, and much more.
Microsoft Excel Training Reviews:
Rated 4.8/5 based on 534 student reviews.
► More reviews...