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

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.

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.

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.

Boulder Computer Repair

Computer Physicians loves Boulder! We are glad to be your full time Computer company in Boulder, CO. We have been in business since 1999. Our office is close by Boulder servicing Boulder regularly. Call us for a appointment in Boulder Colorado. Providing Computer Repair, upgrades, sales, installations, troubleshooting, networking, internet help, Virus removal, and training.

Erie Computer Repair in Erie, CO Colorado

We are glad to be your full time Computer company in Erie, CO Colorado. We have been in Erie, Colorado from 2003 to 2015. We are now close by in Longmont, CO still servicing Erie CO regularly. Call us for a appointment in Erie Colorado. Providing Computer Repair, upgrades, sales, installations, troubleshooting, networking, internet help, Virus removal, and training.

Microsoft SCAM Solved

I went to  fix a computer from a customer in Erie, Colorado who got scammed from someone that took over their computer on remote access saying they were from Microsoft.

Microsoft SCAM Erie, Colorado

I traced the steps.Very interesting what they did they use the command prompt to put fake commands in saying that hackers were infiltrating your system and they needed to pay money to fix the issue. They said they were from Microsoft and need to fix the problems created by the hackers.

There are no hackers they put fake messages in certain places where you check the system for errors. Here’s a printout of the Windows command prompt with  bogus information

People who are not technicians are fooled by this. but this is a command prompt this is not a error screen. That’s why it says it’s an unrecognized command Copying and pasting bogus error information in the command prompt you supposed to only be typing commands People get confused by this who don’t know about computers.

Saying that you must  install Microsoft services at $1.54 a piece 198 times for each service. Then they take the credit card information charge your credit card for that and God knows for what else. They also did other things working very fast having the customer do things on the computer to distract your attention and having a lot of pop-up screens. While taking over the computer with remote access.

Microsoft SCAM Fixed Erie Colorado

I was able to undo any damage they caused and get the computer back up and running like before.  So in the end I fixed the issue.  But people need to call Computer Physicians if they get a problem with their computer so that they don’t cause more issues or problems.  This hacker could have done worse if the customer did not call Longmont Computer Physicians to come solve the issue.

Computer Networks in Longmont Denver Erie Colorado Computer Physicians

Networking is one of the jobs that Longmont Computer Physicians, LLC does to help it’s clients.  Sometimes it is wireless networks, other times the client wants a wired computer network.

I needed to hard wire an entire house with CAT5e cabling for a client a few months ago for internet and file sharing access.   It was a great success!  8 rooms in the house had access to a network cable for computers.

Here are some pictures of the job of the patch cables and routers running into the house and through the walls.

Computer networking in Denver Boulder Colorado router and CAT 5e cable PC repair

Computer Networking in Boulder Longmont Denver Erie Colorado PC Repair

PC Computer Networking in Longmont, Boulder, Denver, Erie Colorado

Boulder/Longmont Computer Repair – PC with no hard drive used

Longmont Colorado PC Computer not using it’s hard drive:

Computer Physicians, LLC  just worked on a unusual situation on a Zotac mini PC computer in Longmont, CO that had a boot windows drive that was filled up.  I thought this would be good to share with my readers:

This very small Zotac mini PC computer running Windows 10 home with 4GB of RAM was booting to a 64GB memory chip located on the motherboard and was not using the 300GB internal SATA hard drive.  As a result since the Windows OS was on a small 64GB memory chip it quickly got filled to capacity.  I backed up the customer’s data to an external hard drive.   The internal hard drive was not being used except for the storing of a few small files.   I could not clone the 64GB memory chip but was able to transfer the OS using special disk software.  I then needed to go into the BIOS and set the boot drive to the internal drive.  The computer is running  slower now since it is not using the small 64GB memory chip for windows and the CPU and computer itself is an inexpensive under-powered computer which was designed to run on the 64GB memory chip. The problem with this design is that the 64GB memory chip quickly gets filled to capacity.  (Windows 10 uses a lot of hard drive memory most systems have 1000GB or more)

I do not like this design and would not recommend this Zotac computer to a client.

The computer will run faster if the original drive is replaced with a solid state drive and if the OS can be transferred and if more RAM memory is installed.

These are some of the situations that Computer Physicians, LLC runs into.

-Steve

Boulder/Longmont Computer Repair – History of the Computer – Computer Physicians, LLC

Boulder/Longmont Computer Repair – History of the Computer – Computer Physicians, LLC  

Computer Physicians provides data recovery, computer troubleshooting, virus removal, networking and other computer fixes.

Here is a good article about the history of computers by marygrove.edu

History of the Computer

The history of the computer can be divided into six generations each of which was
marked by critical conceptual advances.
The Mechanical Era (1623-1945)
The idea of using machines to solve mathematical problems can be traced at least as
far back as the early 17th century, to mathematicians who designed and implemented
calculators that were capable of addition, subtraction, multiplication, and division.
Among the earliest of these was Gottfried Wilhelm Leibniz (1646-1716), German
philosopher and co-founder (with Newton) of the calculus. Leibniz proposed the idea
that mechanical calculators (as opposed to humans doing arithmetic) would function
fastest and most accurately using a base-two, that is, binary system.
Leibniz actually built a digital calculator and presented it to the scientific authorities
in Paris and London in 1673. His other great contribution to the development of the
modern computer was the insight that any proposition that could be expressed
logically could also be expressed as a calculation, “a general method by which all the
truths of the reason would be reduced to a kind of calculation” (Goldstine 1972).
Inherent in the argument is the principle that binary arithmetic and logic were in some
sense indistinguishable: zeroes and ones could as well be made to represent positive
and negative or true and false. In modern times this would result in the understanding
that computers were at the same time calculators and logic machines.
The first multi-purpose, i.e. programmable, computing device was probably Charles
Babbage’s Difference Engine, which was begun in 1823 but never completed. A more
ambitious machine was the Analytical Engine. It was designed in 1842, but
unfortunately it also was only partially completed by Babbage.
That the modern computer was actually capable of doing something other than
numerical calculations is probably to the credit of George Boole (1815-1864), to
whom Babbage, and his successors, were in deep debt. By showing that formal logic
could be reduced to an equation whose results could only be zero or one, he made it
possible for binary calculators to function as logic machines (Goldstine 1972).
First Generation Electronic Computers (1937–1953)
Three machines have been promoted at various times as the first electronic computers.
These machines used electronic switches, in the form of vacuum tubes, instead of
electromechanical relays. Electronic components had one major benefit, however:
they could “open” and “close” about 1,000 times faster than mechanical switches.
A second early electronic machine was Colossus, designed by Alan Turing for the
British military in 1943. This machine played an important role in breaking codes
used by the German army in World War II. Turing’s main contribution to the field of
computer science was the idea of the “Turing machine,” a mathematical formalism,
indebted to George Boole, concerning computable functions.
The machine could be envisioned as a binary calculator with a read/write head
inscribing the equivalent of zeroes and ones on a movable and indefinitely long tape.
2
The Turing machine held the far-reaching promise that any problem that could be
calculated could be calculated with such an “automaton,” and, picking up from
Leibniz, that any proposition that could be expressed logically could, likewise, be
expressed by such an “automaton.”
The first general purpose programmable electronic computer was the Electronic
Numerical Integrator and Computer (ENIAC), built by J. Presper Eckert and John V.
Mauchly at the University of Pennsylvania. The machine wasn’t completed until 1945,
but then it was used extensively for calculations during the design of the hydrogen
bomb.
The successor of the ENIAC, the EDVAC project was significant as an example of
the power of interdisciplinary projects that characterize modern computational science.
By recognizing that functions, in the form of a sequence of instructions for a
computer, can be encoded as numbers, the EDVAC group knew the instructions could
be stored in the computer’s memory along with numerical data (a “von Neumann
Machine”).
The notion of using numbers to represent functions was a key step used by Gödel in
his incompleteness theorem in 1937, work with which von Neumann, as a logician,
was quite familiar. Von Neumann’s own role in the development of the modern digital
computer is profound and complex, having as much to do with brilliant administrative
leadership as with his foundation insight that the instructions for dealing with data,
that is, programming, and the data themselves, were both expressible in binary terms
to the computer, and in that sense indistinguishable one from the other. It is that
insight which laid the basis for the “von Neumann machine,” which remains the
principal architecture for most actual computers manufactured today.
Second Generation Computers (1954–1962)
The second generation saw several important developments at all levels of computer
system design, from the technology used to build the basic circuits to the
programming languages used to write scientific applications.
Memory technology was based on magnetic cores which could be accessed in random
order, as opposed to mercury delay lines, in which data was stored as an acoustic
wave that passed sequentially through the medium and could be accessed only when
the data moved by the I/O interface.
During this second generation many high level programming languages were
introduced, including FORTRAN (1956), ALGOL (1958), and COBOL (1959).
Important commercial machines of this era include the IBM 704 and its successors,
the 709 and 7094. The latter introduced I/O processors for better throughput between
I/O devices and main memory.
Third Generation Computers (1963–1972)
The third generation brought huge gains in computational power. Innovations in this
era include the use of integrated circuits, or ICs (semiconductor devices with several
transistors built into one physical component), semiconductor memories starting to be
used instead of magnetic cores, microprogramming as a technique for efficiently
designing complex processors, the coming of age of pipelining and other forms of
3
parallel processing, and the introduction of operating systems and time-sharing.
Fourth Generation Computers (1972–1984)
The next generation of computer systems saw the use of large scale integration (LSI —
1000 devices per chip) and very large scale integration (VLSI — 100,000 devices per
chip) in the construction of computing elements. At this scale entire processors will fit
onto a single chip, and for simple systems the entire computer (processor, main
memory, and I/O controllers) can fit on one chip. Gate delays dropped to about 1ns
per gate.
Two important events marked the early part of the third generation: the development
of the C programming language and the UNIX operating system, both at Bell Labs. In
1972, Dennis Ritchie, seeking to meet the design goals of CPL and generalize
Thompson’s B, developed the C language.
Fifth Generation Computers (1984–1990)
The development of the next generation of computer systems is characterized mainly
by the acceptance of parallel processing. The fifth generation saw the introduction of
machines with hundreds of processors that could all be working on different parts of a
single program. The scale of integration in semiconductors continued at an incredible
pace — by 1990 it was possible to build chips with a million components — and
semiconductor memories became standard on all computers.
Sixth Generation Computers (1990–)
Many of the developments in computer systems since 1990 reflect gradual
improvements over established systems, and thus it is hard to claim they represent a
transition to a new “generation”, but other developments will prove to be significant
changes.
One of the most dramatic changes in the sixth generation will be the explosive growth
of wide area networking. Network bandwidth has expanded tremendously in the last
few years and will continue to improve for the next several years.