What you will learn:
• Introducing Excel, Interface
• Opening, Editing, Saving, and Sharing Workbooks
• Data Entry, Manipulation, Navigation
• Auto-Fill
o Copy
o Series
o Custom Lists
• Formatting
o Font
o Alignment
o Number
o Styles
o As a Table
• Formulas and Functions – 7 most popular functions
o SUM, AVERAGE, COUNT, MIN, MAX
o (IF and VLOOKUP are covered later in the session)
o SUMIF
• Relative & Absolute References
• Print and Export Workbooks
• Copy, Paste
• Logical Function – IF
• Text Functions and Nested Functions
o Flash Fill
o Format Painter
Time: 9 am – 3:30 pm
All costs include all materials, lunch per day, and 2 coffee breaks.
Cancellation Policy: Written notice must be received by the BCFCA 2 weeks prior to receive any refund.