Excel VBA Developer. If you have any questions please contact our Customer Service. At your office, home, conference room… you name it. Training at your location, at your convenience. Now your spreadsheets may come to life like they never did before. We run small, hands-on Excel training sessions. We hold regularly scheduled courses at our location as well as on-site staff training with highly customized curriculums. All instructors are working professionals.
Our passionate instructors are well regarded for their knowledge of the software, patience, and clarity of instructions. Courses of all levels are available: introductory to advanced. Customers also receive 15 days email support after the course.
One-on-One training, tutoring sessions and pre-designed classes in the Washington, DC area. Skip the nonsense and learn what you need in a working environment. Tell us what specifically you want to learn and you will learn just that or we will use our redesigned programs to provide you with the best knowledge base possible. Things you were spending weeks to get done will now be complete within minutes. The possibilities are endless! We can automate very complex tasks.
Those repetitive tasks that you had to do manually every time are over. We are here to make your life easy and get things done fast. Think of the savings you were missing out on all these years!
Connect your work with live data sources and be on a different level. Mastering Excel classes in Washington DC. Selecting cells and groups of cells 4m 58s. Copying and pasting cell data 2m 38s. Entering data using AutoFill and other techniques 4m 32s. Inserting symbols and special characters 5m 3s. Creating an Excel table 4m 43s. Locating and changing data using Find and Replace 4m 57s. Restricting input using validation rules 4m 42s. Using lists to limit data entered into a cell 2m 32s. Sorting worksheet data 3m 2s. Creating a custom sort order 3m 54s. Filtering worksheet data 4m 6s.
Inserting, moving, and deleting cells and cell ranges 3m 50s. Splitting and freezing rows and columns 3m 50s. Managing worksheets 5m 28s. Creating, editing, and deleting headers and footers 4m 41s. Summarizing Data Using Formulas and Functions. Introducing Excel formulas and functions 3m 17s. Adding a formula to a cell 3m 59s. Introducing arithmetic operators 4m 13s. Using absolute and relative cell references 6m 29s. Controlling how Excel copies and pastes formulas 6m 5s. Referring to Excel table data in formulas 2m 3s. Creating an AutoSum formula 3m 22s.
Summarizing data on the status bar 2m 22s. Joining text in cells with concatenation 3m 59s. Summarizing data using an IF function 6m 21s. Creating formulas to count cells 2m 37s. Rounding cell values up and down 4m 55s. Auditing formulas by identifying precedents and dependents 3m 25s.
Managing Excel formula error indicators 4m 42s. Managing scenarios 4m 59s. Performing Goal Seek analysis 2m 31s.icunpalase.ga
Austin Excel Classes - On-Site Training, Tutoring - Microsoft Office & Other Software
Formatting Worksheet Elements. Applying fonts, background colors, and borders 6m 7s. Applying number and date formats to cells 7m 1s. Managing text alignment 3m 56s. Copying cell formats 4m 2s.
How can we improve Excel for Mac?
Managing cell styles 3m 16s. Managing Office themes 3m 31s. Creating rule-based conditional formats 3m 54s. Defining Top 10 conditional formats 4m 19s. Defining data bar, color scale, and icon set conditional formats 6m 6s. Editing, ordering, and deleting conditional formats 3m 36s.
Working with Charts. Creating bar and column charts 5m 26s. Creating pie charts 2m 32s. Creating line charts 4m 34s. Creating XY scatter charts 1m 49s. Creating stock charts 4m 11s. Changing chart types and layouts 2m 22s. Changing the appearance of a chart 4m 25s. Managing chart axes and numbering 2m 51s. Adding trendlines to charts 4m 14s.