Computer Training

Computer Physicians Computer Repair Data Recovery in Longmont Boulder Erie Denver Colorado Networking PC services help virus removal training

Maximizing Your Technology with Computer Physicians, LLC in Longmont, CO

As a business owner or individual in Longmont, Colorado, you rely on technology to help you stay productive and competitive. But when your computer or network experiences problems, it can quickly bring your operations to a halt. That’s where Computer Physicians, LLC comes in.

Computer Physicians, LLC is a leading IT computer repair and web design company in Longmont that offers a wide range of technology services to help you get back up and running as quickly as possible. Steve is an experienced professional dedicated to helping you maximize your technology investments and achieve your business goals.

We offer comprehensive computer repair services to help you resolve any technical issues you may be facing, whether it’s a simple software problem or a more complex hardware issue. We also offer web design services to help you create a professional and user-friendly online presence for your business. And, with our data recovery services, you can rest assured that your important files and information are safe and secure, even in the event of a disaster.

At Computer Physicians, LLC, we understand that technology can be complex and confusing, which is why we strive to provide clear and straightforward solutions. Steve is always available to answer your questions and help you understand your technology options, so you can make informed decisions.

We are committed to delivering high-quality services at an affordable price, and we always go the extra mile to ensure that our clients are completely satisfied with their experience. Whether you need help with computer repair, web design, or data recovery, we have the expertise and resources to get the job done.

So, if you’re looking for a trusted partner to help you maximize your technology investments in Longmont, look no further than Computer Physicians, LLC. Contact us today to schedule a consultation and find out how we can help you achieve your business goals.

By computerpy, ago

Computer IT support (Information technology) Computer Physicians, LLC Longmont/Boulder CO

Computer Physicians Provides IT support for PC computer maintenance and to make sure your systems are running smoothly in the Longmont, Boulder and Denver areas of Colorado and we can also provide REMOTE support through the internet.

Computer Physicians, LLC provides:

  • Onsite, in-shop, and remote PC troubleshooting, repair and customization
  • IT Support, Network setup, maintenance, troubleshooting
  • Data Recovery
  • Internet setup, troubleshooting, repair
  • Virus, spyware, malware, and adware removal
  • Hardware and software repair
  • Smartphone help, setup, and training
  • Website design, hosting
  • Computer Sales – new and used systems available
  • Computer peripherals, parts and accessories for sale
  • Upgrades & Installations
  • Building customized PC computer systems
  • Tutoring & Training
  • Computer and network security
  • Working with all versions of Microsoft O.S. From DOS to Windows 10, Server 2012.
  • Troubleshooting, maintaining, customizing application programs such as MSOFFICE, ACCESS, EXCEL, WORD, QuickBooks, email programs, Outlook, Outlook express, etc.
  • Troubleshooting and maintaining networks-wireless, wired, router setup, switches, cable modems, CAT 5e cable installations.
  • Email, internet problem solving and customization
  • Networking – managing users, groups, sharing, permissions, printers and troubleshooting the network. stand alone PC’s as well as workstations.
  • Computer Physicians provides remote computer help.  Just give us a call or text or email us and we will arrange a time to help you with your computer issues remotely through the internet.   By using your internet connection we can access your computer temporarily to fix your computer problems.  We use a secure connection and once we log off the session is ended and would need a new password to reconnect again.We have found that by using remote access and with you on the other end to deal with moving of equipment or pressing buttons that many problems can be resolved. Many times we can help you the same time you call.

We provide on-site, in-shop, and remote computer service.  In many cases, we can repair your computer the the day you call us. We also provide remote computer help through the internet or we can come to you so you never have to leave your office. For a reduced rate and quick turn-over time you can visit us at our workshop in Longmont close to 19th and Main. This is about 7 miles from downtown Boulder  Colorado. You will need to call us first to let us know what time you will be coming to drop it off, and to get directions. By appointment only. Servicing Boulder, Longmont, Erie, Denver and the Colorado Front Range and worldwide via remote access.

Call us for information on pricing or to schedule an appointment.

By computerpy, ago

Microsoft 365 Excel Advanced Video lessons

Microsoft 365 Excel Advanced class

Click link above to access class

Introduction Excel 365 advanced                              

Overview of entire course Excel 365 advanced                                

Chapter 1:  Introduction to Macros                           

Overview                               

Understanding and creating macros part 1                            

Understanding and creating macros part 2                            

Running and editing a macro                         

Chapter 2 Pivot Tables                                  

Overview                               

Creating Pivot Tables                         

Changing and Manipulating Pivot Table Data                                  

Grouping by date and time                            

Grouping by other factors                              

Using slicers to clarify and manipulate fields                       

Using Pivot Charts                             

Chapter 3 Working with lists                         

Overview                               

Query Data with Database functions                         

Outline and Subtotal data Part 1                                

Outline and Subtotal data Part 2                                

Outline and Subtotal data Part 3                                

Chapter 4 Data Analysis tools                                   

Overview                               

Using goal seek                                  

Using solver                           

Using scenario manager                                 

Using data tables                                

Chapter 5: Data management                        

Overview                               

Sorting data                           

Using filters                           

Splitting data into multiple columns                          

Using flash fill                                   

Removing duplicate records                          

Using validation tools                        

Chapter 6  Exchanging Excel data with other programs                               

Overview                               

Embedding objects from Excel                                  

Linking objects from Excel                           

Importing objects into Excel                          

Working with Raw data

Conclusion                 

By computerpy, ago

Microsoft 365 Excel video instruction intermediate lessons

Microsoft 365 Intermediate class – Excel                                            

Click the link above to access class

Introduction Excel 365 Videos classes Intermediate                                                   

Overview of entire course Excel 365 Intermediate                                                    

Chapter 1 Basic Table features                                                          

Chapter 1 Overview                                                   

What tables are                                                          

Sort and filter data part 1                                                       

Sort and filter data part 2                                                       

Creating and using tables                                                       

Chapter 2  Adding charts and graphics                                                          

Chapter 2 Overview                                                   

What are Charts and Graphs and the difference                                                        

Creating a chart                                                          

Enhancing a chart                                                      

Modifying chart data                                                 

Changing chart types                                                 

Inserting shapes and other features                                                   

Working with chart elements                                                 

Formatting charts                                                       

Inserting pictures                                                       

Creating in-cell charts with sparklines                                                           

Chapter 3 Working with functions                                                    

Chapter 3: Overview                                                  

Using statistical functions                                                     

Calculating present value                                                       

Calculating loan payments and payoff                                                          

Calculating principle & interest paid                                                

Calculating interest rate, auto calculations                                                    

Working with text functions                                                  

Working with ranges                                                  

Using date and time functions                                                           

Working with logical functions                                                         

Copying formula values                                                         

Chapter 4 IF, VLOOKUP, COUNTIF, Power Functions                                                     

Chapter 4  Overview                                                  

Using the IF Function                                                

Using IF with relational operators                                                     

Using the IFS function                                                          

Using VLOOKUP                                                     

Using VLOOKUP approximate table data                                                    

Using VLOOKUP exact table data                                                   

Using COUNTIF Functions part 1                                                    

Using COUNTIF Functions part 2                                                    

Chapter 5 Finalize, Print and Save                                                    

Chapter 5  Overview                                                  

Use proofing help and research tools                                                

exploring the page layout and view tabs                                                       

working with layout and page setup                                                  

changing view options                                                           

Previewing and modifying page breaks                                                         

Adding headers and footers                                                   

previewing and printing the worksheet                                                         

Arranging multiple workbooks                                                          

Adding hyperlinks                                                     

Saving workbooks in different formats                                                         

Emailing a workbook                                                

Chapter 6 Security and Sharing in Excel 365                                                

Chapter 6 Overview                                                   

Unlocking cells and protecting worksheets                                                   

Protecting workbooks                                                

Assigning passwords to workbooks                                                  

Sharing workbooks part 1                                                      

Sharing workbooks part 2                                                      

Tracking Changes                                                      

Conclusion                             

By computerpy, ago

Learn Microsoft 365 Office Excel – Beginner class

Longmont Computer Physicians learning series – Learn how to use and work with Excel 365 from Microsoft Office.  This is an in-depth beginner class and part one of 3 courses Beginner, Intermediate and Advanced.  This course covers new features of Excel 365, Starting up and working with Excel, creating new workbooks, Organizing your worksheet, Basic formulas, Using templates and themes, and a downloadable Test Quiz is included at the end.

This Excel 365 class is taught by a Microsoft Certified Professional and Comptia A+ Computer consultant from Longmont, Colorado. He has been the President and owner of Computer Physicians, a Longmont, CO computer repair, networking and software company for the past 20 years. He has 3 college degrees in computers which include computer science, programming, networking and GIS. He has programmed, designed, and created professional software programs. He has helped and taught over 3,000 clients how to use Microsoft computer software, hardware and peripherals in Longmont, Boulder, Denver, Erie Colorado as well as across the country.

Microsoft 365 Beginner class – Excel
Microsoft 365 Intermediate class – Excel
Microsoft 365 Advanced class – Excel

Chapter 1: New Features for 365
Overview
How Excel is different from older versions
What is new in Excel 365
How new features are added
365 using Office and Excel
365 in the Cloud
Example of a Excel wookbook/worksheet
Chapter 2: Starting up Excel
Overview
Opening up a workbook and worksheet
The Excel Screen
Difference between a workbook, worksheet and spreadsheet
cells, gridlines, entering data, sheet tabs
The Title bar, Quick access tool bar and namebox
File tab, backstage minitool bar
Customizing and using the Ribbon and KeyTips
Finding and replacing data, undo/redo,  copy and paste, selecting cells
scrolling, adjusting columns, rows
 inserting and deleting rows and columns, adjusting cells
Using Autofill
Using Comments
The file, view tab,  workbook window, status bar
zoom slider
font styles and effects
Chapter 3: Creating new workbooks
Overview
Entering text, numbers and dates
Editing data
More on Editing data
Designing borders and backgrounds
opening and saving workbooks
excel file formats
using conditional formatting
Chapter 4: Organizing your worksheet
Overview
Freeze panes
Split panes
creating, renaming hiding, unhiding worksheets
Format Painter
Alignment and wrap text
Formatting numbers and dates
copying and moving worksheets
hiding and unhiding rows and columns
copying and pasting data numbers, using paste special
Chapter 5: Basic Formulas
Overview
Formulas and functions
Creating basic formulas
Sum a column of numbers, autosum
copying a formula to other cells
simple formula syntax
inserting functions
auto calculate
add, subtract, multiply and divide cells
editing a range of cells
Chapter 6: Using a Template
Overview
Creating and using templates
Applying styles and themes
Conclusion
By computerpy, ago
Longmont Computer Physicians Logo

Longmont Computer Physicians Learning Series – Windows 10 apps

As part of our series of helping customers with their small business needs Longmont Computer Physicians, LLC is offering these free classes on how to use and install Apps in Windows 10.

Starting with Windows 8, Microsoft decided that it wanted to have a common interface for the version of Windows running on tablets and the version running on desktop PCs. Unfortunately for them, this idea didn’t work out too well. Windows 8 was kind of a flop, and didn’t last too long. Even though Windows 10 is a huge improvement over Windows 8, Microsoft still tried to sneak in some of that tablet interface aspect into Windows 10, but this time it works, for the most part. Apps vs. Programs Even though most of us are used to running programs like Microsoft Word or Adobe Photoshop, that doesn’t mean that they are the only types of software we can run. Windows 10 comes with apps that are preinstalled on your computer and also allows you to install more apps for things like games, photo editing programs, and so on. There is a difference between a program and an app, even though they may function in a similar way. A Program (also called Desktop App) is a traditional Windows software package that you install on your computer, and it can be from any number of software manufacturers. Programs will have a specific type of interface designed to be used with a mouse and keyboard and will only run on PCs, not smartphones or tablets. Windows Apps on the other hand look and feel more like an app you would use on your smartphone or tablet, and run on all types of devices.

Windows 10 comes with a bunch of apps preinstalled, and you can find these apps on the start menu. They will be listed alongside your desktop apps. Some examples of common default Windows 10 apps include Facebook, Calendar, News, Mail, Maps, and Paint 3D. Microsoft Store Apps If you have a smartphone, you have most likely used the App Store (Apple) or Google Play (Android) to get more apps for your phone or tablet. Windows 10 comes with the Microsoft Store that lets you search and download new apps that can be used on your computer. There are many free applications to choose from as well as more advanced apps that you can purchase. To get to the Microsoft Store simply find it on your Start Menu, or do a search for it using Cortana. After you find and open the app, you will see a window similar to figure 5.3. As you can see, the Microsoft Store is categorized by types of apps on the top and then has a search function underneath that.

Once you find an app you want to try out, simply click on the Get button to have Windows download and install the app for you. If you scroll down past the Get button you will see the system requirements for the app as well as additional information such as the developer name, release date, and size of the app itself. Just like with your smartphone, there are many apps that you can download and try out for free and many that you can purchase, but just remember that when you install these apps on your computer they will take up disk space, just like regular programs will. Uninstalling Apps If you are the type that likes to try new things, then there is a chance you might go overboard at the Microsoft Store and download one too many apps while checking things out. If this is the case there is no need to worry, because it’s easy to uninstall these apps once you have installed them.

Longmont Computer Physicians, LLC can help you with any computer problem you may have. Please call us to set up an appointment. In Longmont, Boulder, Denver Colorado

By computerpy, ago

How to use the IF function with relational operators with Excel in Microsoft and Office 365

As part of our series of helping customers with their small business needs Longmont Computer Physicians, LLC is offering these free classes on how to use different software programs. Here is our instructional video on using Microsoft Excel spreadsheets.

Microsoft 365 Beginner class – Excel
Microsoft 365 Intermediate class – Excel
Microsoft 365 Advanced class – Excel

 

The IF function in Excel is one of its logical functions, which evaluate to either a “TRUE” or “FALSE” value. The IF function in Excel lets you perform a logical test on a cell’s value and then return a result based on whether or not the cell’s value passes or fails the test. The IF function is similar to an “If…then…else” coding statement. You must know at least three different arguments to write a logical function. The first argument is the “logical test” to apply to the cell. The second is the cell value or formula to return if the test returns a “TRUE” value or “passes” the logical test. The third is the cell value or formula to return if the test returns a “FALSE” value or “fails” the logical test. The syntax of the IF function is: =IF(logical_test,true_response,false_response) If you want the formula to display a text value for the true response or false response, then you must place the text value inside double quotation marks (“ ”). If you want the function to display a date, it must be enclosed within pound signs (##). The only time you wouldn’t mark the data type of the value to return is if you want the function to display a numerical result or calculate a formula. Often, you may want to know if a cell passes or fails multiple logical tests.

One way to apply multiple logical tests to a cell is to use nested logical functions. A “nested” logical function in Excel is one that places the cell through a second logical test if it “fails” the first. These functions are useful for determining the value of a cell by placing it through several different tests, displaying different results based on which test it passes. You can nest up to 127 additional IF statements behind your original, if needed. The syntax for these are: =IF(logical_test _1,true_response,IF(logical_test_2,true_response,false_response)) You must remember to close all open parentheses for every IF statement you nest within the logical function at the end of the formula. In this case since there are two IF statements, there are two closing parentheses at the end of the formula. Alternatively, if using Excel 2019 or later or using Excel as part of Office 365, you can use the new IFS function to pass a cell though multiple logical tests and return a value for the test it passes. The IFS function replicates the features provided by nested IF functions, but uses a simpler, streamlined syntax. We’ll examine the IFS function in a later lesson.

In addition, you may also want to know if a cell meets multiple criteria at the same time. You can use the AND and OR functions to find this out. The AND function returns a “TRUE” value if the evaluated cell passes all the logical tests listed after the AND function. The OR function returns a true value if the evaluated cell passes any of the logical tests that follow the OR function. Note that you can evaluate up to 255 different logical tests after the AND and OR statements. When you look at how you can combine these tests with the IF function or nested IF functions, you can see how you can start to become a very powerful formula creator. Combining these Excel functions lets you place cells through a battery of tests, and then decide what function to perform or value to display, based on the results from the tests. The general syntax when combining the IF function with the AND and OR functions is as follows: =IF(AND(logical_test_1,logical_test_2,logical_test_3,etc.),true_response,false_response) =IF(OR(logical_test_1,logical_test_2,logical_test_3,etc.),true_response,false_response) The IFS function is only available in Excel 2019 or later or Excel as part of an Office 365 subscription. The IFS function in Excel lets you pass a cell through a series of logical tests and then return a value based on which logical test the cell passes. This provides a very similar functionality to using multiple, nested IF statements. When using Microsoft Office Excel 365.

By computerpy, ago

How to create charts and graphs with Excel in Microsoft Office 365

As part of our series of helping customers with their small business needs Longmont Computer Physicians, LLC is offering these free classes on how to use different software programs. Here is our instructional video on using Microsoft Excel spreadsheets. 

Microsoft 365 Beginner class – Excel
Microsoft 365 Intermediate class – Excel
Microsoft 365 Advanced class – Excel

Excel lets you easily create charts from the data in a worksheet. Charts are useful for times when you want to create visual representations of the worksheet data for meetings, presentations, or reports. To insert a chart, select the cell range that contains the data for the chart. Be sure to also select the data’s adjacent row and column labels to automatically apply them to the chart, saving you the step of selecting them later. You can adjust your data selection later, if needed, but selecting the data first lets you see chart previews more clearly. Next, click the “Insert” tab in the Ribbon. In the “Charts” button group are the types of charts you can insert. Starting in Excel 2019, two new chart types appear in this button group. You can access the new “Funnel” and “Map” chart types by clicking them within their respective chart type drop-down buttons in the “Charts” button group on the “Insert” tab of the Ribbon. Alternatively, you can select them after clicking the “Recommended Charts” button in the “Charts” button group on the “Insert” tab of the Ribbon.

One way to insert a chart is to click the “Recommended Charts” button in the “Charts” button group on the “Insert” tab of the Ribbon to open the “Insert Chart” dialog box and display the “Recommended Charts” tab. This tab shows the types of charts Excel thinks would best illustrate your selected data. You can click the choices at the left side of the tab to see a preview of the chart appear to the right. To insert one of the chart choices into the worksheet, click it to select it in the listing at the left side of the tab. Then click the “OK” button at the bottom of the “Insert Chart” dialog box. Another way to insert a chart based on your currently-selected data is to click the button that represents the general chart type to insert within the “Charts” button group on the “Insert” tab of the Ribbon. Then click the specific chart subtype to insert in the button’s drop-down menu. To view all the chart type choices and then insert a selected chart type, click the “See All Charts” button in the lower-right corner of the “Charts” button group to open the “Insert Chart” dialog box. To show all the available chart choices, click the “All Charts” tab. On this tab, you can select a major chart type from the listing at the left side of the dialog box. You can then select the specific subtype to insert by clicking the desired subtype in the list at the right side of the dialog box. To then insert the chart of the selected subtype, click the “OK” button at the bottom of the dialog box. Using any of these chart insertion methods inserts a chart of the selected subtype as an embedded chart object in the current worksheet. The next thing to note is that when a chart object is selected, a new contextual tab then appears in the Ribbon.

This is the “Chart Tools” contextual tab and it consists of two tabs, “Design” and “Format.” You use the buttons in the various button groups on these two tabs within the “Chart Tools” contextual tab to change the selected chart objects. When a chart is selected in Excel, a two-button or three-button grouping of chart options appears at the right side of the selected chart, depending on the chart type you inserted. The buttons are, from top to bottom, “Chart Elements,” “Chart Styles,” and, optionally, “Chart Filters.” You can also use these buttons to change your selected chart. When you insert a new chart into a worksheet, the entire chart is initially selected. The “Chart Tools” contextual tabs then appear in the Ribbon. Two or three drop-down buttons then also appear at the right side of the chart. When editing charts, the first task with which to familiarize yourself is selecting chart elements. Note that a chart is not a single object, but rather, is a complex object comprised of many smaller, selectable objects. You must know exactly which chart element is selected before starting any procedure, like formatting or editing the chart. One way to select chart objects is by using your mouse. You can click the individual chart elements to select them. To select the entire chart, click into the “Chart Area.” The Chart Area is the blank area surrounding most of the actual chart elements. For Microsoft Excel spreadsheets. Using Excel.

By computerpy, ago

Longmont Computer Repair in Longmont, Colorado

Longmont’s Computer Physicians loves Longmont! We are glad to be your full time Computer company in Longmont, CO. Opening in 1999 in Longmont. Call us for a appointment in Longmont Colorado. Providing Computer Repair, upgrades, sales, installations, troubleshooting, networking, internet help, Virus removal, data recovery and training.

By computerpy, ago
%d bloggers like this: