By the end of this introductory Excel class in Sacramento, participants will be able to create and edit worksheets and workbooks; perform basic formulas and functions; and understand how to format, manipulate, print, and protect their data.
Upon successful completion of this intermediate Excel class in Sacramento, participants will be able to perform an array of common tasks more confidently and effectively, working with named ranges, tables, advanced formats, and charts.
Customizing the Ribbon, Quick Access Toolbar, Status Bar, Options
Inserting, Deleting, Hiding and Rearranging Worksheets
By the end of this class in Sacramento, participants will be able to manipulate large data sets more quickly and easily using a variety of advanced functions and formulas. Participants will also be able to summarize data efficiently using the consolidate and subtotals features.
Excel Level 4 is a one-day instructor led class, held in Sacramento, building upon the Level 3 course that continues teaching the more advanced features, macros, and data visualization in Microsoft Excel. Upon successful completion of this course, participants will be able to use what-if analysis to process data; apply validation to ensure the data in your workbook is appropriate; build lists; and use Quick Analysis features to automate many common tasks.
Recording Macros in Excel
Relative vs. Absolute Recording
Running Macros in Multiple Ways
Editing and Deleting Macros
What-If Analysis including Solver, Goal Seek and Scenario Manager
Custom Lists and Views
Saving in Different Formats
Quick Analysis Features and Conditional Formatting
Data Visualization including Charts, Totals, Tables and Sparklines
Excel Pivot Tables is a one-day instructor led class, held in Sacramento, covering Pivot Tables, a powerful feature in Microsoft Excel which enables data manipulation with simple dragging and dropping. At the end of this course, participants will be able to sort, filter, group, summarize, and format data with ease and efficiency using Pivot Tables. Pivot Tables allow the ability to analyze your data in a variety of ways to meet your needs.
Excel Power Pivot is a one-day instructor led class in Sacramento, covering the Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can combine large volumes of data from various sources; perform information analysis rapidly; and share insights easily.
Importing Data from Access and Excel
Relationships Between Data Tables
Shaping the Data Model with Data Analysis Expressions Functions (DAX)
VBA Coding is a two-day instructor-led advanced Excel class, held in Sacramento, that teaches participants how to take complex and time-consuming tasks and automate them with code. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA’s capabilities and to optimize and debug your code. As far as coding languages go, VBA is one of the easier languages to learn.